“Doing Power BI the Right Way: 6. Data Modeling Essentials & Best Practices (1 of 2)” - Ilgar Zarbaliyev 🇦🇿's Nuzzel Newsletter for Sun, Dec 27

Part of the the series: Doing Power BI the Right Way Data Modeling 101: part 1 (more advanced techniques coming in part 2) A data model is the foundation of analytic reporting. It provides structure and order over information that might otherwise…

Shared by…

2

More info…

Okay, I think this is not a topic for Power BI, because normally I build a SCD in a Data Mart with T-SQL and not with M/PowerQuery for an Self Service Environment. But in some cases it should be very useful like an PoC. Another reason in an self…

Shared by…

2

More info…

When we published our first Income Statement in Power BI, it didn't take long for someone to ask if we would also include subtotal lines such as Gross Margin [Sales – Cost of Goods] in the matrix visual. The reporting challenge became how to…

Shared by…

2

More info…

Google cloud has bought recently Dataform and made it available for free, although I play it with it before, Now I thought it is a good time to use it more seriously, this is not a review but my own experience as a data analyst who is more…

Shared by…

2

More info…