What Is a Data Model?
Scorri per mostrare il 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?
Grazie per i tuoi commenti!
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
