I will clean messy data and build excel dashboards with power query

Pakistan

Data Analyst Excel, Power Query and SQL

I help small businesses and individuals turn messy spreadsheets into clear, easy-to-read dashboards. I work with Excel and Google Sheets: data cleaning with Power Query, PivotTables and PivotCharts, K...
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