Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate excel reports and consolidate data with power query
Specialist in Strategic Analysis and Business Intelligence
I am a Data & Analytics and Enterprise Transformation professional with 9+ years of experience leading data-driven strategies and scalable technology solutions. I specialize in building modern data pl...
About this Gig
Spend less time preparing spreadsheets and more time using your data.
I'm a Senior BI & Finance Consultant with 9+ years of experience, including work with US companies. I build practical Excel reporting solutions using Power Query.
Depending on your package, I can help you:
Clean duplicates, blanks and inconsistent formats
Combine Excel/CSV files into a consolidated dataset
Create reusable data transformation steps
Build summary reports for financial or operational analysis
Replace repetitive manual preparation with a refreshable workflow
Basic: clean 1 table.
Standard: combine up to 3 files with similar structures and create 1 summary report.
Premium: consolidate up to 5 files and build 1 report with up to 3 tabs, including refresh instructions.
You'll receive an editable Excel workbook. Updates run when you select Refresh; scheduled automation is not included.
Please message me before ordering to confirm your files, Excel version and scope. Revisions cover the agreed requirements.
API integrations, VBA/macros and scheduled automation are quoted separately after review.
Available in English and Spanish.
Technology:
Apache Spark
•
Excel
•
Google Sheets
•
Python
•
VBA
•
Alteryx
FAQ
What do you need to get started?
Please send your Excel/CSV files or representative samples, explain the desired result, and tell me your Excel version and whether you use Windows or Mac.
Will my report update automatically?
Your workbook will use Power Query so you can update the report by selecting Refresh after replacing or adding source data in the agreed format. Scheduled or unattended updates are not included.
Can you connect Excel to an API or create macros?
These requests are reviewed separately and are not included in the listed packages. Please message me with your requirements so I can assess feasibility and provide a custom offer.
What is included in a revision?
Revisions cover adjustments to the agreed report, formatting and transformation rules. New data sources, additional report tabs or changes to the original requirements may require a custom offer.
