Consider the following scenario, continued from Unit 1 Individual Project:
Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market.
As the business analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets to make the best recommendation possible.
Complete the following:
Download the reports for the United States from this Web site. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports:
General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary (based on the entire United States)
Download the reports for zip code 60614 from this Web site. This particular file contains 4 reports:
General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary based on the U.S. zip code 60614
Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page summary slide explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in the data.
Use the BI software you choose to depict information from these reports.
Prepare a presentation of 4–5 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least 2 graphs and a headline that summarizes a key takeaway from the graph.
Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (75-word minimum per slide).
For assistance with the usage of Tableau for analysis and reporting, review and use the instructions below. Those should be helpful if you are having problems with the software usage or data. However, you do not need to use Tableau.
For BI software usage such as Excel, resort to using the Help functions and other resources on the Internet and in videos to learn how to use Excel to create graphical presentations including table usage.
