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

YouTube

Aggregation and Composite Model - Power BI Fast and Furious

PASS Data Community Summit via YouTube

Overview

Dive deep into the world of Power BI performance optimization with this 50-minute conference talk from PASS Data Community Summit. Learn how to leverage Aggregations and Composite Models to analyze and visualize terabytes of data in less than a second. Explore the intricacies of combining huge DirectQuery tables with smaller import mode tables, and discover numerous tips, tricks, and internal workings of Aggregations in Power BI. Through live demonstrations, gain practical insights into creating Aggregation Tables, implementing Aggregations in Power Query, setting up Composite Models, managing relationships between tables, configuring storage modes, and establishing layers of aggregation with precedence setup. Uncover effective Aggregation patterns and get answers to frequently asked questions, empowering you to handle massive datasets with lightning-fast performance in Power BI.

Syllabus

Introduction
Power BI
Demo
Aggregation
Aggregation Table
Aggregation in Power Query
Composite Model
Relationship between tables
Storage mode
Aggregations
Layers of aggregation
Precedence setup
Aggregation patterns
Frequently asked questions

Taught by

PASS Data Community Summit

Reviews

Start your review of Aggregation and Composite Model - Power BI Fast and Furious

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.