US Labor Statistics

Description :

Maven Careers is a fictional non profit organization helping high school seniors find career paths. Need to create Dashboard for upcoming round of school visits, that seniors can use to explore wages and employment trends, and compare them across industries.

Tool Used : Microsoft Excel

Key Objective of Dashboard :

1. Define the purpose for the Dashboard.
2. Choose the key metrics & interactivity.
3. Prepare the data for visualization.
4. Create Primary and Supporting visuals.
5. Design the Final Dashboard layout.
6. Configure the workbook for viewers.

Observation:

1. Average Annual Wages by Industry Trend to identify top and bottom Industry based on Average Annual Wage.
2. % Share of Employment by industry relative to whole market.
3. Employee per 1,000 based on total population under given State.
4. Yearly Trend of Wages and Employment.
5. State wise opportunities for Industries while comparing Average Wages & Employment per 1,000 through Map visual.

Data Source : US Labor Statistics by Industry & State from 2017 to 2019.

Dimensions & Measures :

1. Dimensions : Year, Industry, State
2. Measures : Total Employees, Avg. Annual Wages.

Concept Covered :

1. Statistical & Lookup Formulas.
2. Inserting & Formatting Custom Charts.
3. Dynamically Highlighting Series.
4. Creating New Data with Data Types.
5. Adding Form Controls.
6. Protecting Workbooks & Worksheets