Business Question: How do state-level metrics trend over time, and what insights can we gain from pivoted monthly data?
Tools Used: Excel, PivotTables
Summary: This project involved cleaning and transforming time series data from state-level records, creating a dynamic dashboard using Excel PivotTables. Monthly performance metrics were visualized to reveal seasonality, trends, and anomalies across states.
Highlights:
- Built a pivoted dashboard to compare states over time.
- Identified outliers and seasonal spikes in performance data.
- Demonstrated ability to clean, reshape, and visualize complex datasets.
Note: This analysis was based on an MBA assignment and extended to include additional comparative metrics.