You will get Excel Data Cleaning, Automation & KPI Dashboards Power Query, Power Pivot

Project details
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
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
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$25
|
Standard
$45
|
Advanced
$120
|
|---|---|---|---|
| Delivery Time | 2 days | 4 days | 7 days |
Number of Revisions | 1 | 2 | 3 |
Number of Pages Mined/Scraped | 1 | 3 | 10 |
Number of Sources Mined/Scraped | 1 | 2 | 4 |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$10 - $50
Additional Revision
+$5
Additional Page Mined/Scraped
(+ 1 Day)
+$15
Additional Source Mined/Scraped
(+ 1 Day)
+$25About Isaac
Data Analyst
Lagos, Nigeria - 12:27 am local time
Steps for completing your project
After purchasing the project, send requirements so Isaac can start the project.
Delivery time starts when Isaac receives requirements from you.
Isaac works on your project following the steps below.
Revisions may occur after the delivery date.
I will ask you the information you would like to extract from your data
Remove duplicates, blanks, and inconsistent entries Standardize date formats, text casing, and units Power Query steps documented so the client can refresh it themselves Delivery as a ready-to-use .xlsx workbook