Consider the following scenario:

The National Sales meeting is approaching. Each regional sales manager has to do a short presentation for the marketing department that highlights how the consumers in their territory are different from those in the total United States. You are still working with the local regional sales manager. Complete the following:

  • Clickhereto download the reports for the United States. This file contains reports generated from a marketing organization's 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, and Income Summary based on the entire United States.
  • Clickhereto 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 leasttwo 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).

For assistance with the usage of Tableau for analysis and reporting, review and use the following instructions. This should be helpful if you are having problems with the software usage or with problems with the data. But, 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.

  1. 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%