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