You will get an automated Power Query pipeline to clean your messy Excel data
Rising Talent
Project details
Are you spending hours manually formatting the same weekly Excel exports? Raw, messy data is a massive liability to your business.
I specialize in rescuing broken datasets. Instead of just doing a manual, one-time cleanup, I engineer structural data pipelines using Power Query and VBA so your data cleans itself.
Whether you are dealing with scattered e-commerce sales reports, complex academic research, or raw ESG and Scope 1, 2, and 3 carbon metrics, I transform messy CSVs into audit-ready, structured master files.
Core Capabilities:
• Excel Data Cleaning: Eliminating duplicates, fixing broken data types, and standardizing text formats.
• Power Query Automation: Building dynamic templates so future multi-source exports clean themselves with a single "Refresh" click.
• Data Transformation: Unpivoting, merging, and appending massive datasets for accurate analysis.
• Structural Formatting: Preparing raw data for Power BI or financial modeling.
Send me a message with a sample of your raw data to get started.
I specialize in rescuing broken datasets. Instead of just doing a manual, one-time cleanup, I engineer structural data pipelines using Power Query and VBA so your data cleans itself.
Whether you are dealing with scattered e-commerce sales reports, complex academic research, or raw ESG and Scope 1, 2, and 3 carbon metrics, I transform messy CSVs into audit-ready, structured master files.
Core Capabilities:
• Excel Data Cleaning: Eliminating duplicates, fixing broken data types, and standardizing text formats.
• Power Query Automation: Building dynamic templates so future multi-source exports clean themselves with a single "Refresh" click.
• Data Transformation: Unpivoting, merging, and appending massive datasets for accurate analysis.
• Structural Formatting: Preparing raw data for Power BI or financial modeling.
Send me a message with a sample of your raw data to get started.
Data Tool
Microsoft Power BIWhat's included
| Service Tiers |
Starter
$45
|
Standard
$150
|
Advanced
$350
|
|---|---|---|---|
| Delivery Time | 2 days | 4 days | 7 days |
Number of Revisions | 5 | 5 | 9 |
Number of Pages Mined/Scraped | 1 | 1 | 5 |
Number of Sources Mined/Scraped | 1 | 1 | 5 |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$10 - $50Frequently asked questions
About Ayesha
Data Analyst | Excel, Power BI & Power Query | ESG/Carbon Accounting
Attock City, Pakistan - 7:29 pm local time
Core services:
• Excel data cleaning, formulas, Pivot Tables, Power Query
• Power BI dashboard design & data visualization
• Basic SQL for data querying and reporting
• Sustainability/ESG reporting, GHG emissions (Scope 1 hands-on project, Scope 3.2 client experience), carbon accounting Excel templates
Recent work: completed a paid Scope 3.2 emissions reporting project for a client, and built a Scope 1 GHG Accounting Calculator from real EPA/IPCC emission factors, viewable in my portfolio and on GitHub.
New to Upwork, not new to the work, happy to start with a smaller-scope project to prove quality and turnaround time.
Steps for completing your project
After purchasing the project, send requirements so Ayesha can start the project.
Delivery time starts when Ayesha receives requirements from you.
Ayesha works on your project following the steps below.
Revisions may occur after the delivery date.
Data Audit & Structural Assessment
Power Query Pipeline Engineering