I transformed a raw, 45,000+ row banking dataset into an automated Power Pivot Data Model and dynamic executive dashboard. By moving away from lagging grid formulas, I built a system that delivers real-time conversion insights without file bloat or calculation lag.
What I Delivered & Built:
- Power Query ETL Pipeline: I standardized raw header schemas, cleaned messy text entries, and structured the data for easy automation.
- Power Pivot & DAX Engine: I created structured data relationships and context-aware DAX measures to calculate dynamic KPIs across thousands of customer records instantly.
- Executive Dashboard & Visuals: I designed polished horizontal bar charts, KPI summary tables, and intuitive layout hierarchies tailored for executive decision-making.