Executive Data Analytics

at
Categories
Tags

 

create a PowerPoint presentation that includes texts, charts, and graphs answering the questions 1-9 in the following case study:

Question 1: What is the average travel time (commute) to work for individuals in your
metro area?
Question 2: What is the median household income for individuals within your state?
Question 3: How does the median income in your state compare to other states? (Hint: Use
a chart or map.)
Question 4: What is the population of your state?
Question 5: Is the population in your state growing or shrinking? By how much?
Question 6: What percent of the population within your state is between the ages of 20 and
60?
Question 7: How many vehicles are available to the households within your state?
Question 8: How many individuals in your state take alternative methods cabs or bicycles
to get to work?
Question 9: Create a dashboard of two or more charts that you accessed on the website
and paste a screenshot here.

Sample Solution

Presentation Title: A Demographic Analysis of [Metro Area]

Slide 1: Title Slide

  • Title: A Demographic Analysis of [Metro Area]
  • Your Name
  • Date

Slide 2: Average Commute Time

  • Text: The average commute time for individuals in [Metro Area] is [X] minutes.
  • Chart: A bar chart comparing commute times in [Metro Area] to other major cities.

Slide 3: Median Household Income

  • Text: The median household income in [State] is [X] dollars.
  • Table: A table comparing median incomes in [State] to other states in the region.

Slide 4: State Income Comparison

  • Map: A choropleth map showing median income variations across states in the U.S.
  • Note: Use a color scale to represent income levels.

Slide 5: State Population

  • Text: The population of [State] is [X] people.
  • Chart: A line chart showing population growth or decline over time.

Slide 6: Population Age Distribution

  • Text: [X]% of the population in [State] is between the ages of 20 and 60.
  • Pie chart: A pie chart representing the age distribution of the population.

Slide 7: Vehicle Ownership

  • Text: There are [X] vehicles available to households in [State].
  • Bar chart: A bar chart comparing vehicle ownership rates in [State] to other states.

Slide 8: Alternative Transportation

  • Text: [X]% of individuals in [State] use alternative transportation (cabs or bicycles) to commute to work.
  • Pie chart: A pie chart showing the distribution of transportation methods.

Slide 9: Dashboard

  • Screenshot: A screenshot of a dashboard from a data visualization tool (e.g., Tableau, Power BI) showing two or more relevant charts.
  • Example charts: Population growth over time, income distribution by age group.

Additional Tips:

  • Use clear and concise language.
  • Ensure that charts and graphs are visually appealing and easy to understand.
  • Cite your sources for all data used.
  • Customize the presentation to fit the specific needs and interests of your audience.

By following these guidelines and incorporating relevant data for your chosen metro area, you can create a comprehensive and informative presentation.

 

This question has been answered.

Get Answer