For this assignment, you will need to become familiar with specialized business intelligence (BI) software, then download the software. Complete the following steps to begin:
Step 1: Watch an instructional video on the BI software.
Step 2: Review various BI Software options including Tableau; Excel or other Business Intelligence. Search the CTU Library and the internet to learn about optional software.
Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any Business Intelligence software to create a graph illustrating comparison between the US and zip code data.
Consider the following scenario, continued from the 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 in order to make the best recommendation possible. Complete the following:
Click here to download the reports for the United States. 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, and Income Summary based on the entire United States.
Click here to download the reports for zip code 60614. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and 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 this data.