Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn What Is a Data Model? | Data Modeling and DAX Fundamentals
Power BI for Beginners

What Is a Data Model?

Swipe to show menu

Before you can write calculations or build visuals that answer real business questions, your tables need to be connected. This chapter introduces the data model: the structure that defines how your tables relate to each other and why that structure matters.

You'll learn the star schema pattern, the most common approach to organizing data in Power BI, and see how it separates transaction data (the fact table) from descriptive data (dimension tables). You'll also get your first look at Model View in Power BI Desktop, where you can see and manage the connections between all your tables.

1. In a star schema, the Sales table sits in the center surrounded by Products, Customers, and other tables. What is the correct term for the Sales table in this pattern?

2. Why is it better to store a CustomerID in the Sales table rather than repeating the customer's full name and address on every row?

question mark

In a star schema, the Sales table sits in the center surrounded by Products, Customers, and other tables. What is the correct term for the Sales table in this pattern?

Select the correct answer

question mark

Why is it better to store a CustomerID in the Sales table rather than repeating the customer's full name and address on every row?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 1

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Section 3. Chapter 1
some-alt