Wage & Employment Analysis Dashboard

Project Description: Wage and Employment Analysis Dashboard

The Wage and Employment Analysis Dashboard provides an interactive overview of US labor trends from 2017 to 2020, covering average wages, employment size, and state-specific opportunities across industries. Designed to help users—especially high school seniors—explore potential career paths, the dashboard delivers clear, data-driven insights for informed decision-making.

Key Insights:

• Highest Wages: Identifies industries with the highest average annual wages.
• Employment Size: Shows the relative size of employment by industry across the US.
• Yearly Trends: Highlights wage growth and employment changes over time.
• State Opportunities: Pinpoints states with the best career prospects in each industry.

Key Skills Used:

• Excel Tools: Pivot tables, manual formulas, slicers, and conditional formatting for dynamic data analysis.
• Data Preparation: Cleaned raw data to ensure accuracy and relevance.
• File Protection: Implemented protection features to secure data integrity.
• Data Storytelling: Structured insights for clarity, helping users easily understand labor trends.

This dashboard combines simplicity, data accuracy, and effective storytelling, making complex labor data accessible and actionable.