Notes from the work

Build-along notes on Microsoft Fabric, Power BI, and governance.

Power BI1 Sept 202614 min read

Dimension table structure, sentence by sentence

Kimball Group defines a dimension table in six sentences. I take them one at a time, in plain language, and show what each one means for a Power BI semantic model.

Power BI25 Aug 202615 min read

Fact table structure, sentence by sentence

Kimball Group defines a fact table in five sentences. I take them one at a time, in plain language, and show what each one means for a Power BI semantic model.

Fabric18 Aug 20268 min read

Three ways to organise medallion architecture in Microsoft Fabric

Bronze, Silver and Gold can live in one lakehouse, three lakehouses, or three separate workspaces. Here is how the three layouts compare in Microsoft Fabric, and the one I would choose.