I will clean messy data and build excel dashboards with power query
Data Analyst Excel, Power Query and SQL
About this Gig
Got a messy spreadsheet? I'll turn it into clean, ready-to-use data and, if you want, a clear Excel dashboard you can filter and understand at a glance.
What I do:
- Clean your data: remove duplicates, fix formats (dates, prices, text), handle missing values and standardize columns using Excel and Power Query
- Summarize it: PivotTables and charts that answer your questions
- Build dashboards: KPI cards, charts and slicers so you can filter by city, category, date and more
Proof of work: check my portfolio. I cleaned 22,721 real rental listings across 10 Pakistani cities and built a full interactive dashboard from the raw data (a personal sample project).
How it works:
1. Send your file and tell me what you want to learn from it
2. I confirm the scope and timeline before I start
3. You get your cleaned file or dashboard, plus a short note explaining what I did
Have a file with more than 10,000 rows, or one that's not in Excel or Google Sheets? Message me before ordering so I can quote it correctly.
Analysis type:
Quantitative Analysis
•
Descriptive Analysis
Expertise:
Business Insights
•
Trends
Technology:
Excel
•
Google Sheets
•
Power Query
Programming language:
SQL
My Portfolio
FAQ
What file formats do you accept?
Excel (.xlsx), CSV, and Google Sheets. If your data is in another format, message me first.
Is my data kept private?
Yes. I use your file only to complete your order and don't share it with anyone.
What if I need changes after delivery?
Message me within 3 days of delivery and I'll fix any issues within the agreed scope.
Can you work in Power BI or Tableau?
Right now I build in Excel, Power Query, and Google Sheets. If you need Power BI or Tableau, this gig isn't the right fit.

