What Is a Data Model?
Veeg om het menu te tonen
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?
Was alles duidelijk?
Bedankt voor je feedback!
Sectie 3. Hoofdstuk 1
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Sectie 3. Hoofdstuk 1
