I will do professional data cleaning with power query and dax in excel
Excel and Data Specialist Power Query DAX VBA Automation Clean Data Every Time
About this Gig
Messy data slows everything down duplicate rows, mismatched date formats, blank cells, information pulled from three different sources that don't match up. I fix that.
I clean and structure your data in Excel, then build a Power Query pipeline so future updates take a few clicks instead of hours of manual re-work. If you need deeper analysis, I also build DAX measures and connect multiple tables into a proper data model.
What's included:
- Removing duplicates and fixing inconsistent formatting
- Standardizing dates, text, and numbers
- Reusable Power Query transformations
- DAX measures and multi-table data models
- A clean, ready-to-use Excel file, no clutter
I'm finishing Google's Data Analytics Professional Certificate right now, and these are the exact tools from that program Power Query, DAX, data modeling that I use on real projects, not just practice exercises.
Before you order, send me:
- Your raw data file (Excel, CSV, or Sheets)
- What you want the final output to look like
- Any deadline or specific instructions
If your project is large or a bit unusual, message me first I'll take a quick look before you place the order so there are no surprises later.
My Portfolio
FAQ
Q: What file formats do you accept?
I work with Excel (.xlsx, .xls) and CSV files. If your data is in Google Sheets, just share the link and I'll handle the rest.
Q: How do you count "items cleaned"?
Each row in your dataset counts as one item — so 300 items cleaned means your file has around 300 rows once cleaned and structured.
Q: I don't know what Power Query or DAX means — can you still help me?
Yes. You don't need to know the technical terms. Just tell me what your data looks like now and what you want the end result to be — I'll handle the rest and explain anything you need.
Q: Will I be able to update the data myself later?
For Standard and Premium packages, yes — I build the Power Query steps so you can refresh with new data using just a few clicks, no need to redo the cleaning manually.
Q: What do you need from me before starting?
Your raw data file, a short note on what the final result should look like, and any deadline. The clearer the instructions, the faster and more accurate the delivery.

