Coursera Bets $100 Million That Andrew Ng Can Do What Coursera Can’t

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

SQLBits via YouTube

Start learning Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Level up Power BI data modeling skills in this 51-minute conference talk from SQLBits. Learn to handle different source groups, storage modes, and composite models in Power BI. Discover how to avoid redundant measures by implementing calculation groups and tackle the challenges of combining them with remote and local Power BI models. Explore topics such as Dual mode, DirectQuery, security implications, and performance considerations. Gain insights from speakers Jeroen ter Heerdt and Marc Lelijveld as they cover AdventureWorks examples, composite models using Power BI datasets and Analysis Services, and key takeaways for expert-level data modeling in Power BI.

Syllabus

Intro
What are we talking about?
AdventureWorks
Different types of storage modes
Understanding Dual mode
Caches and DirectQuery
Behavior of Dual mode
Introducing composite models
Example, sales model with local target sheet
Limited relationships
Security implications
Performance implications
Composite models using Power BI datasets and Analysis Services
Introducing calculation groups
How calculation
Wholesale vs non-wholesale
Calculation groups and measures in a composite model
Key take-aways

Taught by

SQLBits

Reviews

5.0 rating, based on 1 Class Central review

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

  • Profile image for Ruchira Chowdary
    Ruchira Chowdary
    The Advanced Data Modeling Techniques for Power BI course was very informative and practical. It provided a clear understanding of Storage Modes, Composite Models, and Calculation Groups, which are important for building efficient and scalable Power BI solutions. The practical examples made the advanced concepts easier to understand. Overall, it is a useful course for anyone looking to strengthen their Power BI and data modeling skills.
Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.