You will get Data Cleaning — Excel & CSV Files (Python + Power Query)
Project details
I deliver clean, structured data you can actually use — no more wasted time fixing spreadsheets manually.
Using Power Query and Python (Pandas for complex files), I remove duplicates, standardise dates and names, fix formatting inconsistencies, flag missing values, and validate amounts. Every delivery includes a clear summary of all changes made so you know exactly what was done.
What sets this service apart: I don't just run a macro and hand it back. I review your file first, identify every issue, and apply a systematic cleaning process — then deliver a reusable script so your next file takes minutes, not hours.
Using Power Query and Python (Pandas for complex files), I remove duplicates, standardise dates and names, fix formatting inconsistencies, flag missing values, and validate amounts. Every delivery includes a clear summary of all changes made so you know exactly what was done.
What sets this service apart: I don't just run a macro and hand it back. I review your file first, identify every issue, and apply a systematic cleaning process — then deliver a reusable script so your next file takes minutes, not hours.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$30
|
Standard
$65
|
Advanced
$120
|
|---|---|---|---|
| Delivery Time | 2 days | 3 days | 3 days |
Number of Revisions | 1 | 2 | 3 |
Number of Sources Mined/Scraped | 0 |
Frequently asked questions
About Edwin
Data Cleaning & Power BI Dashboards | Excel & CSV | Xero Reporting
Meridan Plains, Australia - 9:50 pm local time
I specialise in two services:
1. Data Cleaning — I take your raw Excel or CSV files, remove duplicates, fix formatting, standardise values, and deliver a clean, structured file ready to use. I use Python (Pandas) and Power Query to automate the process.
2. Power BI Dashboards — I build interactive dashboards connected to your clean data, with KPI cards, trend charts and filters. For Xero users, I can connect Power BI directly to your Xero account for live financial reporting.
My background in IT support and software testing gives me a strong attention to detail and a quality-first mindset. I don’t just build reports — I make sure the numbers are right, the logic is clear, and the process works long-term.
What I can help you with: Power BI dashboards, Excel automation (Power Query), data cleaning and transformation, and Xero reporting.
I communicate clearly, ask the right questions, and focus on delivering practical results that save time and improve decision-making.
If you need clean reporting, reliable automation, or help understanding your data, I’d be happy to help.
Steps for completing your project
After purchasing the project, send requirements so Edwin can start the project.
Delivery time starts when Edwin receives requirements from you.
Edwin works on your project following the steps below.
Revisions may occur after the delivery date.
File Review
I review your file, identify all data quality issues, and confirm the scope matches your selected package before starting.
Cleaning & Standardisation
I clean your data using Power Query: remove duplicates, fix formats, standardise names, and flag nulls. Python (Pandas) is used for larger or more complex files.