Brick and Caleb discuss the importance of data modeling and good DAX in Power BI, highlighting common mistakes that can lead to poor report performance. For fast and efficient reporting, you need a sound data model that contains the right level of detail, dimensions, and relationships, avoids snowflake schemas, and uses simple (and standardized) naming conventions.
Key Sections:
1:34 Signs your data model is summarized.
3:47 What else could be causing your slow-loading report?
6:36 Your model should be built so that other data engineers and architects can understand it.
Blue Margin increases enterprise value for PE-backed, mid-market companies by serving as their fractional data team. We advise on, build, and manage data platforms. Our strategy, proven with over 300 companies to-date, expands multiples through data transformation, as presented in our book, The Dashboard Effect.
For a free, downloadable copy click bit.ly/3RmBGWQ, or buy a hardcopy or Kindle version on Amazon (amzn.to/3UTvTLm).
Get more episodes of The Dashboard Effect podcast on your favorite podcast app or at podcast.thedas...
Visit Blue Margin's library of additional BI resources here: bit.ly/3fwNmcg
12 окт 2024