Data Modeling for Power BI
Data Mozart
0:00 / 0:00
Data Modeling for Power BI
1 968 просмотров · Трансляция закончилась 1 год назад
Data Mozart
7,79 тыс. подписчиков
1 968 просмотров · Трансляция закончилась 1 год назад
Learn data modeling essential concepts and how to implement these concepts in real-life scenarios using Microsoft Power BI
00:00 Intro
18:00 Conceptual data model
23:25 Logical data model
26:58 Physical data model
31:55 Normalization/Denormalization
47:05 OLTP vs. OLAP
53:45 Dimensional modeling fundamentals
1:04:19 Implementing Star schema
1:23:05 Slowly Changing dimensions
1:29:13 Role-playing dimension
1:40:36 Relationships and filters
1:48:45 Composite models
1:55:00 Working with multiple fact tables.