What Is a Data Model?
Свайпніть щоб показати меню
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?
Дякуємо за ваш відгук!
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
