I will automate your excel reports with power query and dax
UK Excel Expert, 20 Years' Experience, Software Engineering Student
About this Gig
Still copying and pasting data into the same Excel report every week? I'll build a Power Query and DAX workflow that pulls in your data, cleans it and updates your report with a single click on Refresh.
I'm a UK-based data specialist with 20 years of Excel experience and 8 years in Power BI, which runs on the same Power Query and DAX engine as Excel. I build workflows the way a software engineer would: clear steps, sensible names and no fragile manual fixes.
What you get:
- Data imported from files, folders, databases or the web
- Cleaning, merging, unpivoting and de-duplication in Power Query
- A Data Model with relationships and reliable DAX measures
- PivotTables and reports that refresh in one click
- A short guide explaining each step
Why work with me:
- Clear, jargon-free communication from a native English speaker
- Every query step is named and documented
- Your data is handled in confidence
Not sure what you need? Send me a message describing your current process and I'll suggest the best approach before you order.
Technology:
Excel
My Portfolio
Other Data Processing Services I Offer
FAQ
Which versions of Excel does this work with?
Power Query and the Data Model are built into Excel 2016 and later on Windows, including Microsoft 365. Excel for Mac supports Power Query but not the Data Model or DAX, so let me know if you use a Mac.
Will I be able to refresh it myself?
Yes. Add new files or update your sources, click Refresh All and everything updates. I'll include a short guide.
Can you work with my existing workbook?
Yes. I can rebuild your current manual process inside your workbook, so your existing reports keep working, just automated.

