Executive Data Analytics
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.
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.