Maven Careers - excel dashboard

This Excel dashboard visualization provides a comprehensive view of wage and employment data for the finance industry across the United States. Here’s a breakdown of each element:

1. Title and Header:
   • The title, "What do wage and employment figure look like by industry?", frames the context of the dashboard, focusing on wages and employment metrics.
   • The industry being analyzed, Finance, is highlighted in a yellow box below the title.
2. Average Annual Wage:
   • On the left side, a horizontal bar chart shows the average annual wages by industry, with a teal color bar for each industry.
   • Industries such as "Information" and "Finance" have the highest wages, while "Leisure & Hospitality" has the lowest.
   • The finance industry is highlighted, suggesting it has relatively high wages compared to other industries.
3. Share of Total Employees:
   • In the center, a donut chart shows that 7% of total employees are in the finance industry, emphasized in bold, yellow text.
4. Wage & Employee Trends:
   • This section is divided into two parts:
     • A line graph showing a trend in wages for the finance industry from 2017 to 2020, indicating steady growth from $77,330 in 2017 to $90,041 in 2020.
     • A bar chart displaying total employment numbers for each year, which grew from approximately 8,021,586 in 2017 to 8,142,043 in 2020.
5. Employees per 1000 Capita:
   • On the right, a map of the United States shows the concentration of finance employees per 1,000 people by state.
   • States with darker yellow shades indicate a higher concentration of finance employees, with a gradient from light to dark yellow.
6. Color Scheme:
   • Teal is used for wage-related data, while yellow represents employment metrics. This color distinction helps differentiate the wage and employment components.

This dashboard is a useful snapshot for analyzing finance industry employment concentration, wage trends, and employment share across states and in relation to other industries.