I will build an advanced excel data model with power pivot and power query


About this gig
Your Excel files shouldn't just store data. They should answer questions.
Before building anything, I identify which metrics actually drive decisions in your business so the system shows exactly what you need to act on, not just data for data's sake.
I build advanced Excel solutions that go beyond basic spreadsheets: Power Query, Power Pivot, DAX, Macros, VBA, and dynamic charts combined into a system your team can actually use.
What you get:
- Automated data cleaning with Power Query.
- Multi-table data models with Power Pivot & DAX.
- Dynamic dashboards with charts, maps & slicers.
- Macros & VBA to eliminate manual repetitive work.
- Clean structure ready to scale or connect to Power BI.
I build decision tools, not just spreadsheets.
Message me first. Tell me what your spreadsheet needs to do. I want to understand your goals before touching a single cell.
Get to know Marco Miranda
Power BI y Excel Specialist, Data that Drives Decisions
- FromPanama
- Member sinceJan 2026
- Avg. response time1 hour
Languages
English
My Portfolio
FAQ
Which version of Excel do you need?
Excel 2019 or Microsoft 365. Power Pivot requires Pro versions or higher.
Can you connect multiple sources?
Yes. Power Query can connect Excel, CSV, SQL, web, and more.
Are the files automated?
Yes. You can update them with a single click using Power Query and Macros.
Can this be connected to Power BI later?
Yes. The data model I build is 100% compatible for migrating to Power BI.
Is my data confidential?
Yes. I can sign a non-disclosure agreement (NDA) before starting.

