The Maven Jobs project is part of the course, "Microsoft Excel: Advanced Excel Dashboard Design," on Udemy.
In this mock project, the non-profit Maven Careers helps high school students find a career path and are in need of a dashboard for an upcoming round of school visits. The data is labor statistics from 2017 to 2020. The dashboard should help seniors explore wage and employment trends, and compare them across industries. A map to show the differences by state is also requested.
Our data includes US labor statistics by industry & state from 2017 to 2020. The variables are year, industry, state, establishments, employees, and average annual wage.
The key objectives for this project were to:
Define the purpose of the dashboard.
Choose the key metrics & interactivity.
Prepare the data for visualization.
Create primary & supporting visuals.
Design the final dashboard layout.
Configure the workbook for viewers.
The project includes the following features:
bar charts, a line graph, a donut chart, and a map,
Statistical functions (AVERAGEIFS, SUMIFS),
Lookup functions (INDEX, UNIQUE),
dynamically highlighting series,
form controls (spin buttons and radio buttons),
custom color theme, and
worksheet and structure protection.
Comments