I will clean excel data and build dashboards with power query
About this Gig
Turn messy spreadsheets into a clear, usable report.
I clean and standardize Excel or CSV data, remove duplicates using agreed rules, merge matching files, and build dashboards around your business metrics. Standard and Premium include a Power Query workflow you can refresh when source files keep the agreed structure.
Basic: 1 sheet, up to 100 rows and 20 columns.
Standard: up to 3 files and 500 rows total, 20 columns per file, 4 KPIs and 3 charts.
Premium: folder import from up to 5 matching files and 1,000 rows total, 30 columns per file, 6 KPIs and 4 charts.
You receive the completed XLSX workbook, cleaned data, a summary of changes, and short instructions. An item means one data row.
Before ordering, send a sample, your Excel version, and your desired result so I can confirm scope and compatibility.
Scanned PDFs, external APIs, VBA and major source-layout changes require a separate quote. Revisions cover adjustments within the agreed scope. Please remove confidential or personal information that is not needed for the project.
