I will data cleaning work in power query
Data Cleaning Specialist Excel, Power Query
Over deze dienst
Are broken spreadsheets, messy CSV exports, or manual copying-and-pasting costing you hours of lost time? I can help you fix it.
I specialize in turning disorganized, error-filled, and raw datasets into clean, structured, and dashboard-ready files using Advanced Excel & Power Query. Whether you need a quick one-time sheet cleanup or a fully automated ETL refresh pipeline, I ensure 100% accuracy and efficiency.
- Data Cleaning & Standardization: Deduplication, fixing text casing, parsing dates, splitting/merging columns, and handling missing values.
- Power Query ETL Automation: Consolidating multiple CSV/Excel files from a folder into a single, automatically refreshable master table.
- Data Transformation: Unpivoting cross-tabs, reshaping schemas, and preparing datasets specifically for Power BI, Tableau, or Excel dashboards.
- Error Auditing & Fixes: Resolving formula errors (#N/A, #VALUE!), broken lookup links, and mismatched column formats.
Why Choose Me?
- Automation First: I build reusable Power Query M-code scripts so future data cleans automatically in 1 click.
- Clear Communication: I provide step-by-step documentation explaining the exact steps performed on your dataset.
Financiële software:
Oracle EBS
•
QuickBooks
•
SAP s/4HANA
Branche:
Gegevensanalyse
•
E-commerce
•
Juridisch
Doelland:
Australië
•
India
•
Verenigde Staten
Diensten worden niet gescreend
Let erop dat er voor deze dienst geen screeningsproces is. We raden je aan om de freelancer een berichtje te sturen en om, voordat je bestelt, alle benodigde informatie te controleren. Lees meer over financiële diensten op Fiverr.
Mijn portfolio
Veelgestelde vragen
Can you set up an automated refresh so I don't have to clean new files manually?
Yes! Using Power Query, I can set up an automated pipeline connected to a folder or file. When you add new raw data in the future, you simply click "Refresh All" in Excel, and your cleaned dataset updates instantly.
What file formats do you work with?
A: I work with Microsoft Excel (.xlsx, .xlsb, .xlsm), CSV, TSV, JSON, and Google Sheets exports.
Is my company or personal data safe with you?
Absolutely. I maintain strict data privacy and confidentiality standards. Once the order is completed and accepted, local working files are deleted.
