Explore the powerful feature of Aggregations in Power BI through this comprehensive conference talk from PASS Data Community Summit. Dive into the implementation of Aggregations for high-performance analysis of large datasets, comparing it with Analysis Services Multidimensional. Learn about architectural approaches, strengths, and weaknesses of different services and components for holistic analytical solutions. Discover the user-friendly nature of Power BI Aggregations, their similarities and differences with other Analysis Services engines, and gain insights into designing effective aggregations. Understand the concepts of composite models, data access issues, and scheduled refreshes. Examine the advantages of aggregations, potential challenges, and architectural considerations, including integration with Azure SQL Data Warehouse.
Overview
Syllabus
Intro
Thomas Martens
Designing Aggregations
Aggregations in tabular
Power BI Desktop
Duck Studio
Data Model
Rewrite Attempt
Attempt Fade
Composite Model
Recap
Advantages of aggregations
The sinking part
Data access issues
Detail table vs aggregation table
Scheduled refresh
Architecture
Azure SQL DW
Taught by
PASS Data Community Summit
