Control Tower Dashboard
A comprehensive Control Tower dashboard that became the central hub for monitoring KPIs across the manufacturer's motor vehicles division, with automated data pipelines and interactive drill-down capabilities.
- Daily
- automated data preparation
- One view
- sales and aging inventory
- Faster
- aging-stock review
The Challenge
The manufacturer needed a centralized view of their key performance indicators across multiple business units. Data was scattered across systems, manual reporting consumed hours daily, and teams lacked real-time visibility into aging inventory and sales performance.
The Build
I designed and built a Power BI Control Tower dashboard fed by automated R scripts that ran daily data manipulation and enrichment. The dashboard featured interactive KPI cards, drill-down capabilities by region and product line, and automated alerts for metrics outside acceptable ranges. I also created a companion R Shiny web app specifically for aging inventory visibility.
The Impact
The automated pipeline reduced recurring manual preparation. The inventory Shiny app made aging stock easier to identify and act on, while the Control Tower supported the division's daily operating review.