YoVDO

Aggregations in Power BI

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Business Intelligence Courses Data Analysis Courses Data Modeling Courses Azure SQL Data Warehouse Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

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

Related Courses

Delivering a Data Warehouse in the Cloud
Microsoft via edX
Databases in Azure
Microsoft via edX
Optimizing Microsoft Azure Data Solutions
Pluralsight
Building Batch Data Processing Solutions in Microsoft Azure
Pluralsight
Implementing a Data Warehouse SQL Server 2019
LinkedIn Learning