Unit 2 Chicago versus United States Demographic Profile Analysis

Question # 00653578
Subject: Business
Due on: 07/18/2024
Posted On: 07/18/2024 03:22 AM
Tutorials: 1
Rating:
4.9/5
Question Dot Image

Unit 2 Chicago versus United States Demographic Profile Analysis Presentation

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.
  • Use the business intelligence 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 two 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 (100–150 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.

Instructions to Create Bar Graph in Tableau (optional) or in another BI Software.

  1. Open the assignment CTU instructions.
  2. Download Business Intelligence Software.
  3. Create your Tableau Public Account.
  4. Click the download link for the zip code (60614) file (file will open in Excel).
  5. Click the download link for the US file (file will open in Excel).
  6. The following are some options:
    1. 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%
    1. Create a file with data organized without extraneous rows and columns but including headings.
    2. The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
    3. Note in the real situation, when using BI software, you will want to ensure your data are clean and you have similar data in your files.
  1. Save the file(s) on your computer.
  2. Open Tableau. Then do a File > Open > Open your saved file.
  3. At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner).
  4. Under Measures (on left), you should see Chicago and U.S. Click on U.S. and pull it into rows at the top of the screen. Then click on Chicago and pull it over into rows.
  5. Under Dimensions on the left, you should see Household Income. Click on Household Income and pull it into column.
  6. Now in the second column from the left, you should see measures.
  7. In the top right corner, you should see a “show me” box illustrating ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data.
  8. To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password.
  9. When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in tableau public.)
  10. After the file is saved, open the .png file, and edit or copy the graph.
  11. Open your PowerPoint file, then paste (special) it on the slide. You can adjust the size.
  12. Repeat the same in Tableau opening of any other prepped and cleaned file.

Note: Measure values are your number fields; measure names are the descriptors.

Please submit your assignment.

For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.

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 

Microsoft. (2018). Create a chart from start to finish. Retrieved from https://support.office.com/en-us/article/Create-a-...

References

Pak, A. (2013, August 12). Tableau Public - Overview and Applications [Video file]. Retrieved from 

Tableau(2018). Tableau public. Retrieved from http://www.tableausoftware.com/public/

Dot Image
Getsolution Posted By :
Questions: 15478 Tutorials: 15477
Tutorials for this Question

Unit 2 Chicago versus United States Demographic Profile Analysis

Tutorial # 00652473
Posted On: 07/18/2024 03:22 AM
Feedback Score: Not rated yet!
Purchased By: 2
Getsolution
Posted By:
Questions:
15478
Tutorials:
15477
Report this Tutorial as Inappropriate
Tutorial Preview
The solution of Unit 2 Chicago versus United States Demographic Profile Analysis...
Attachments
Unit_2_Chicago_versus_United_States_Demographic_Profile_Analysis.ZIP (18.96 KB)

Great! We have found the solution of this question!

Related Questions
Management Discussion - In Chapters 16 & 17 we must
National University Management Discussion In Chapters 16 & 17 we must broaden our bandwidth and understand our roles. What roles are included in Table 17.1 and how may we utilize them to gain t …
Management - Conflict Resolution, Identify a company of your choice 
National University Management Question Conflict Resolution   This assignment will guide you through a difficult topic -- conflict resolution.  You will apply what you've learned t …
Industrial Hazardous and Waste Management
Industrial Hazardous and Waste Management Do you use any of the treatment technologies discussed in this unit at home or work? Please discuss. If you don't use any at home or work, do an intern …
Industrial and Hazardous Waste Management
Industrial and Hazardous Waste Management This unit focuses on management principles related to industrial and hazardous wastes. Environmental managers face pressures to satisfy corporate financial …
Leadership Essay - Choose any two leaders who you consider
 South University Leadership Essay put well-known personalities and  yourself under the microscope to learn what makes you and the  individuals you select not only leaders but also w …
Unit 2 Chicago versus United States Demographic Profile Analysis
Unit 2 Chicago versus United States Demographic Profile Analysis Presentation For this assignment, you will need to become familiar with specialized business intelligence (BI) software, then downlo …
Management Unit 2 Chi Square and Hypothesis Testing Analysis Essay
NA Management Unit 2 Chi Square and Hypothesis Testing Analysis Essay Based upon the input from Units 1 and 2, you have just received your next assignment that will contribute to your next decision …
Management Practical Problem on Technology Consultant
WU Management Practical Problem on Technology Consultant Questions Question 1 Have you observed a practical problem on the job(Technology consultant) that you learned about in a MBA program cour …
MGMT Unit 5 Big D Incorporated Long Term Objectives
NA MGMT Unit 5 Big D Incorporated Long Term Objectives and Outcomes HW Next, download the file Sample Data. Prepare a chart similar to the one in the downloaded file to indicate whether the co …
Applying Valuation Technique in Personal Investment Strategy Discussion
CGTC Applying Valuation Technique in Personal Investment Strategy Discussion 1.Go to www.cnbc.com and explore the video tab by using several different key terms such as stock pricing …
Recent Questions
Social work process evalution - Agency Context: Briefly describe
Social work process evalution The purpose of this assignment is to prepare a proposal for a process or outcome evaluation thatcould be implemented at your placement or place of employment (if you w …
Psychology - Why Zebras Don’t Get Ulcers by Robert Sapolsky
Psychology Question Purpose The purpose of this assignment is to increase your knowledge of health psychology concepts beyond the textbook. It also designed to utilize your critical thinking ski …
PSY605 ITESM Erickson's Late Adulthood Analytical Review
PSY 605 ITESM Erickson's Late Adulthood Analytical Review PSY 605 FINAL Integrating the Field of Developmental Psychology: A Review of the Literature Prior to beginning work on this assig …
PSY225 - Survey, What were your five highest strengths
psy/225 survey, What were your five highest strengths Take the VIA© survey. Using your results, write a 350- to 700-word paper covering the following points: What were …
Ashford PSY699 Resources for the Integrative Literature Review
PSY699 Ashford University Resources for the Integrative Literature Review Prior to beginning work on this written assignment, be sure to carefully review the instructions for the Final Assignment, …
PSY630 Variations in Drug Response - Ms. Jones is a 30-year-old
Variations in Drug Response PSY630 Using the knowledge you gained from the readings, evaluate how a typical drug, when orally administered, may be handled differently by these two patients: …
Technology is ubiquitous; it is everywhere. Since humans
provide insights into how technology has changed the way people interact Technology is ubiquitous; it is everywhere. Since humans are social creatures that need to interact, cell phones and social …
SOC401 - A strong cover letter is an accompaniment
SOC401 Crafting the Cover Letter A strong cover letter is an accompaniment to a strong résumé and is often the key to securing an interview. While a resume goes through ATS programs, …
SOC401 Identity and Social Change
soc401 Identity and Social Change First, turn to the Needs-Based Assessments and Community Outreach discussion from Week 2, and choose your community and issue or a colleague’s community and …
SOC401 Civic Engagement, Volunteerism, and Community Outreach
SOC401 Civic Engagement, Volunteerism, and Community Outreach Share your previous experiences of civic engagement or volunteering. Describe the identity groups and communities that were supported b …