Problem
KPI files arrived from different departments with inconsistent schemas. Reporting was fragmented, manual effort was high, and management lacked a central KPI model that could scale over time.
Solution
Built a standardized KPI data structure, consolidated department files via Power Query, and transformed wide monthly formats into a normalized dashboard-ready model with repeatable refresh logic.
Workflow
Department KPI Files
Schema Mapping
Power Query Consolidation
Normalized Data Model
Management Dashboard
Key Features
Multi-department consolidation
Unified KPI schema
Refreshable update flow
Wide-to-long transformation
Dashboard mapping layer
Scalable onboarding model
Tech Stack
Excel
Power Query
Data Modeling
KPI Reporting
Data Transformation
Dashboard Integration
Impact
Centralized KPI governance
Reduced manual reporting effort
Scalable department onboarding