Everything in Power BI is more complicated if you don’t build a good data model. Business Intelligence consultants spend an entire career learning how to build data models, but NOT you! Understanding the fundamentals of dimensional modeling (Star Schema) can get you very far in Power BI. During this session, you will learn what a Star Schema is, building facts and dimensions, understanding relationships, role-playing tables and calculation groups.
Curriculum
11 Sections
0 Lessons
3 Hours
Expand all sectionsCollapse all sections
01. What you need to get started
0
02. Introduction to SQL Server Window Functions
0
03. Window Functions (Introduction)
0
04. Window Aggregates (Introduction)
0
05. Window Aggregates (Running Totals)
0
06. Window Ranking Functions (Row_number)
0
07. Window Ranking Functions (Rank and Dense Rank)'