Business Intelligence software

Step 1: Watch an https://www.youtube.com/watch?v=PnkMiHocqR on the BI software.
• Step 2: Review various BI Software options including Tableau; Excel or other Business Intelligence. Search the internet to learn about optional software.
• Step 3: use any Business Intelligence software to create at least 2 graphs illustrating at least 2 comparisons between the US and zip code data.
Consider the following scenario,
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:
• 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.
• 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 memo explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in this data.
• Use the business intelligence software you choose to depict information from these reports.
• Prepare a presentation of 5–6 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 two graphs and a headline that summarizes a key takeaway from the graph. The last page should contain at least 3 questions that you would want answered based on what you’ve seen in this comparison.
Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (200–250 words per slide).

  1. The following are some options:
  2. Create separate demographical worksheets. For example: Education Attainment File – Worksheet (include both Zip Code and U.S. data); Household Income (include Zip Code and U.S. data)
     See a sample of the file available with column headings and extraneous blanks.
    Household Income Chicago U.S.
    1980 1990 1980 to 1990 2000 1990 to 2000 1980
    Median Household Income 18,438 41,227 1.236 69,311 0.681 16,902
    Average household Income 24,245 67,607 1.788 114,615 0.695 20,382
    Per Capita Income 13,564 38,518 1.84 63,791 0.656 7,321
     See a sample of the file available with column headings and extraneous blanks.
    2000 Educational Attainment U.S. Chicago
    College: Associates Degree 6.3% 1.9%
    College: Bachelor’s Degree 15.5% 44.2%
    College: Graduate Degree 8.9% 34.0%
    College: Some College, no Degree 21.1% 8.7%
    School: 9th to 11th grade, no diploma 12.1% 3.2%
    School: Grade K-9 6.1% 2.0%
    School: High School Graduate 28.6% 5.6%

Additional Resources
American Marketing Association. (n.d.). Summary reports. Retrieved from http:/www.marketingpower.com/content753.php
Igines. (2012, December 9). How to make a line graph in Excel (Scientific data) [Video file]. Retrieved from https://www.youtube.com/watch?v=Xn7Sd5Uu42A
Microsoft. (2018). Create a chart from start to finish. Retrieved from https://support.office.com/en-us/article/Create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2
References
Pak, A. (2013, August 12). Tableau Public – Overview and Applications [Video file]. Retrieved from http://youtu.be/PnkMiHocqRw
Tableau. (2018). Tableau public. Retrieved from http://www.tableausoftware.com/public/

Sample Solution

find the cost of your paper