Browse categories
Explore
Fiverr Pro
English
$
USD
I will clean messy excel data, combine files, and automate reporting using power query
Expert Excel and Financial Data Analyst with over 25 Years Experience
Welcome! I am Pathma, a qualified Finance & Accounting professional (ACMA, HNDA) with over 15 years of corporate financial experience and 25+ years of expertise in Microsoft Excel and Data Analytics.
...
About this Gig
Are you struggling with disorganized, messy data, misaligned columns, or dozens of separate monthly sheets that take hours to manually copy-paste? Let me transform your raw, unorganized data into structured, ready-to-use business reports using automated Power Query workflows.
What I Can Do For You:
- Data Cleaning & Sanitation: Remove duplicates, unpivot messy rows/columns, fix extra spaces, missing values, and misaligned formats.
- Multi-Source Consolidation: Combine multiple Excel workbooks, CSVs, TXT files, or PDF tables into one consolidated master sheet.
- Automated Data Transformation: Build reusable Power Query (ETL) routines so you can update your entire dashboard with a single click.
- Formula & Schema Corrections: Re-arrange, standardize, and format headers, dates, and currency types across large datasets.
Supported File Types: Excel (.xlsx, .xls, .xlsm), CSV, TXT, and PDF tables.
Why Choose DPM Analytics?
- 100% Data Accuracy & Integrity: Clean structures ready for pivot tables or Power BI.
- Scalable Workflows: Solutions designed to handle multi-thousand row databases easily.
Please contact me before placing an order so we can discuss your dataset requirements and structure!
My Portfolio
FAQ
What file formats can you work with?
I work with Excel (.XLSX, .XLS, .XLSM, .XLSB), .CSV, .TXT, .TSV, and tabular .PDF files. If your data is in another format, feel free to contact me before ordering!
Will the Power Query workflow automatically update when I add new data?
Yes! For automated pipeline orders, I build the Power Query model so that you can simply add new raw files into your source folder and click Refresh All in Excel to update your entire dataset instantly.
Can you extract data tables from messy or PDF files?
Yes, I can extract and structure embedded data tables from PDF documents into clean, editable Excel sheets. Please send a sample PDF first so I can verify table quality.
Is my business and financial data safe with you?
Absolute confidentiality is guaranteed. Your raw data and business information will never be shared with third parties or used for any other purpose. I am happy to sign an NDA if required.
What do I need to send you to get started?
Simply send your raw source file(s) (.XLSX, .CSV, .PDF, etc.) and a brief explanation (or quick sketch/sample) of how you want the final cleaned output or report structured.
What if my file has millions of rows or very large datasets?
Power Query is built to handle massive datasets efficiently beyond regular Excel row limits. For datasets over 100,000+ rows, please message me first so I can tailor the setup to your specific data structure.
