01
Semantic models
A clean model with one definition of every number. Revenue means the same thing on every page and in every report that uses it.
- star schema
- single source of truth
- Direct Lake
I build semantic models, DAX, and reports on Microsoft Fabric and Power BI, so the next developer can actually pick them up.
All of it runs on the Microsoft data stack you may already own.
A clean model with one definition of every number. Revenue means the same thing on every page and in every report that uses it.
Measures written to be read by the next developer, then checked against your source data so the totals reconcile.
Pages built around the questions the readers actually ask, not around every column that happens to exist.
Scheduled refresh set up to run on its own, so the 6am numbers are there at 6am.
If you only need a quick one-off chart, Power BI Desktop alone will do. You do not need me for that.
No 80-page statement of work to start. We scope tight, ship something real, then expand.
30 minutes to understand your data, your stakeholders, and what "done" looks like. You leave with a clear recommendation.
A real dashboard on your actual data within the first couple of weeks, so we react to something live instead of a slide deck.
Numbers checked, refresh automated, documented. It keeps running whether or not I'm in the room.
It is the layer between your data and your reports. It holds the tables, the relationships, and the measures, so every report calculates each number the same way.
A Power BI storage mode in Microsoft Fabric that reads data from your lakehouse directly, without importing a second copy. I choose between Direct Lake, Import, and DirectQuery based on your data size and how fresh the numbers need to be.
Not always. Direct Lake needs a Fabric capacity. Import mode, the classic Power BI approach, does not. If your data is small and simple, you may not need Fabric, and I will tell you so.
That is the goal. I document the model and the measures and walk your team through them, so the next developer can pick it up.
You do. The models, the reports, and the documentation are handed over to your team.
You see a real dashboard on your own data within the first couple of weeks after kickoff.
Tell me what you're working with and who needs to see it. If I can help, I'll tell you how. If I can't, I'll tell you that straight.
Book a 30-minute call