What Is a Data Model?
Stryg for at vise menuen
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?
Var alt klart?
Tak for dine kommentarer!
Sektion 3. Kapitel 1
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Sektion 3. Kapitel 1
