I will automate your manual excel and CSV reporting with power query
BI Expert and Data Analyst in Excel Google Sheets Power BI Dashboards
Level 2
Has met high performance criteria and has a proven track record for meeting client expectations.
About this Gig
Spending hours every week copying, cleaning and merging Excel or CSV files? I automate it with Power Query, so you refresh once and the report is ready.
I am a BI consultant with 10+ years in telecom analytics, working with clients in the US, UK, Canada and Denmark. I work with large operational files and make the process repeatable.
What I automate:
- Merging many files or sheets into one table
- Cleaning, formatting and fixing messy data
- Repeating monthly or weekly reports
- Feeding the result into Excel or Power BI
How it works:
- You send sample files and describe the manual steps today.
- I build the automated process and test it on new data.
- I hand over the file with a short guide, so you can refresh it yourself.
Message me first with a short description of your current process so I can confirm the right package.
Analysis type:
Descriptive Analysis
Expertise:
Business Insights
Technology:
Excel
•
Power BI
•
Power Query
Programming language:
DAX
My Portfolio
Other Data Analytics Services I Offer
FAQ
Will it work when new files arrive?
Yes. I build it to take new data without edits. You drop in the new files, press Refresh, and the report updates.
Do I need Power BI for this?
No. Power Query works inside Excel too, so you can stay in Excel. If you later want Power BI, the same steps carry across.
Can you keep my current report layout?
Yes. I can match your existing layout and formulas, or improve them if you want. Share your current file and tell me what must stay the same.
