Deep Dive into Data Modeling using Power BI and SSAS

The presentation below from  Kasper de Jonge, Senior Program Manager at Microsoft, was streamed earlier today and covers several core data modeling topics including:

  • Bi-Directional Cross-filtering and Many to Many Relationships
  • DAX Variables
  • Query Editor/ M vs. DAX
  • DirectQuery Performance Tips

Two high level takeaways could be A) using M and DAX together (appropriately) and B) thinking through the details of the trade-offs of DirectQuery with In-Memory. Prior to SSAS 2016+ and Power BI Desktop, model design and development was almost exclusive to In-Memory mode and DAX. Now and going forward with SSAS vNext it’s important to be familiar with M language and DirectQuery mode too.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s