Advanced Data Modeling Techniques for Power BI - Storage Modes, Composite Models, and Calculation Groups

Advanced Data Modeling Techniques for Power BI - Storage Modes, Composite Models, and Calculation Groups

SQLBits via YouTube Direct link

Intro

1 of 18

1 of 18

Intro

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Advanced Data Modeling Techniques for Power BI - Storage Modes, Composite Models, and Calculation Groups

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 What are we talking about?
  3. 3 AdventureWorks
  4. 4 Different types of storage modes
  5. 5 Understanding Dual mode
  6. 6 Caches and DirectQuery
  7. 7 Behavior of Dual mode
  8. 8 Introducing composite models
  9. 9 Example, sales model with local target sheet
  10. 10 Limited relationships
  11. 11 Security implications
  12. 12 Performance implications
  13. 13 Composite models using Power BI datasets and Analysis Services
  14. 14 Introducing calculation groups
  15. 15 How calculation
  16. 16 Wholesale vs non-wholesale
  17. 17 Calculation groups and measures in a composite model
  18. 18 Key take-aways

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.