Sign in to confirm you’re not a bot
This helps protect our community. Learn more

The Power BI Community Show Ep 5 - The Importance of Data Modeling

Microsoft Power Platform
66.4K subscribers
<__slot-el>
<__slot-el>
422 views Streamed 2 years ago
Welcome to the Power BI Community Show! This is a live show hosted by the Community Program Manager for Power BI, Kelly Kaye. She is passionate about the Power BI Community, co-founder of the Power BI Women Summit, and a Power BI user herself. On this episode, Kelly will speak with Jeroen ter Heerdt who will discuss the importance of Data Modeling. With different segments each episode, you'll want to make sure to check out future episodes as well. Jeroen's Links -Data modeling webinar series: https://docs.microsoft.com/power-bi/f... -Learn module on data modeling: https://docs.microsoft.com/learn/modu... -Connect with J on Twitter:   / jeroenterheerdt   -Connect with J on Linkedin:   / jeroenterheerdt   Follow us on Twitter -   / mspowerbi   More questions? Try asking the Power BI Community @ https://community.powerbi.com/ ...more
...more
These chapters are auto-generated

Intro

0:00

Welcome

2:00

Giveaway

3:00

Power BI Dev Camp

4:00

Power BI Community Show

6:00

Who is Jay

7:00

Community Poll

8:00

Why is data modeling important

10:00

Invest in a good data model

11:00

You dont have to build a data model

12:00

Take a step back

13:00

Skip the model step

14:00

Improve the data model

15:00

Types of data models

16:00

OLTP data models

17:00

Questions

18:00

Building a Data Model

19:00

Flexibility

21:00

Good Data Models

22:00

What is a Fact

23:00

Dimensions

24:00

Relationships

25:00

What is a data model

26:00

Dimensional data models

27:00

Date data models

28:00

Star schema

29:00

Answering business questions

30:00

How many tables will break

31:00

One big fact table

32:00

Multiple stars

34:00

Fact table

35:00

Factless fact

36:00

Fact tables

37:00

Relationships between tables

38:00

Onetomany relationships

39:00

Unique products

40:00

Wrong data model

42:00

Relationship type

43:00

Onetoone

44:00

Manytomany

45:00

Bridge Table

47:00

One to Many

48:00

Different Types of Data Models

49:00

Snowflake

50:00

Star Schema Snowflake

51:00

Reviewing Data Models

52:00

Building a Bridge Table

53:00

synapse analytics

54:00

Build and Power BI

55:00

What is a composite

56:00

Power BI Build Keynote

57:00

Wrap up

58:00

Comment in the community

59:00
The Power BI Community Show Ep 5 - The Importance of Data Modeling
Welcome to the Power BI Community Show! This is a live show hosted by the Community Program Manager for Power BI, Kelly Kaye. She is passionate about the Power BI Community, co-founder of the Power BI Women Summit, and a Power BI user herself. On this episode, Kelly will speak with Jeroen ter Heerdt who will discuss the importance of Data Modeling. With different segments each episode, you'll want to make sure to check out future episodes as well. Jeroen's Links -Data modeling webinar series: https://docs.microsoft.com/power-bi/f... -Learn module on data modeling: https://docs.microsoft.com/learn/modu... -Connect with J on Twitter:   / jeroenterheerdt   -Connect with J on Linkedin:   / jeroenterheerdt   Follow us on Twitter -   / mspowerbi   More questions? Try asking the Power BI Community @ https://community.powerbi.com/

Follow along using the transcript.

Microsoft Power Platform

66.4K subscribers