BPCS9705P E-Commerce Applications

As a graduate from Red River College, you are working as a consultant for Claw Construction. The owner is trying to decide whether to change business models to generate more revenue; the company primarily works on non-residential construction projects, but is interested in expanding into residential markets. How to Proceed Part 1 - Excel Your supervisor has asked you to research demand and profitability indicators to decide if this idea is worth considering. Is it more profitable to remain in non-residential construction, or are there missed opportunities in residential construction?

 

Using the City of Winnipeg's open data website (use aggregate data), you will compare the frequency (#) and total value ($) of residential construction permits vs non-residential permits that have been issued in the following neighborhoods between the years 2015 to 2020: The Forks Tuxedo Waverley Heights West Broadway Transfer the relevant data into an Excel spreadsheet, and ensure you:

 

Download the raw data into a separate worksheet and use your name_raw in the label Sort the relevant data using a structured table and format it into a table of your choice. Use accounting format with zero decimal places. Create properly formatted title and table elements on a separate worksheet with your name_table in the label. Insert at least one mathematical/statistical function(s) into the spreadsheet.

 

Create a chart or graph of your choice to help visualize your information on a separate worksheet with your name_graph in the label.