A complete, automated Excel reporting system. I design the full pipeline: Messy Raw Data --> Power Query Cleaning (ETL) --> Power Pivot Data Model --> DAX (Analytics Engine) --> Pivot Table Controller (Filter) --> Cube Formulas (Reporting Layer) --> Dashboard Visualizations. One-click refresh, no manual rework needed.
What's included:
Tier 1
✔Data Cleaning and Formatting(500 Rows Max)
✔Basic Excel Dashboard with 5 MAX KPIs
✔2 Hours of Work
✔1 Review
TIER 2
✔Data Cleaning and Formatting(1,000 Rows Max)
✔Data Validation
✔Interactive Dashboards with 10 MAX KPIs
✔5 Hours of Work
✔2 Reviews
TIER3
Everything in Tier 1 & 2
✔500,000 MAX ROWS
✔Full Power Query ETL pipeline (multiple messy/raw sources → clean model)
✔Robust Power Pivot data model with proper relationships and calculated columns
✔12–25 custom DAX measures (KPIs, ratios, growth %, targets vs. actuals, time intelligence)
✔Executive dashboard tab: KPI cards, trend charts, comparison visuals, slicers
✔One-click "Refresh All" automation setup
✔Documentation: 1-page guide on how to update/refresh the workbook
✔10 Hours of Work
✔30-minute live walkthrough call (Zoom/Google Meet)
✔3 Reviews