Loading Data to the Data Model

Hello everyone! 🎉 Having mastered Power Query, we're now progressing to our next exciting phase: Power Pivot.

Power Pivot is a data analysis and modeling technology that allows you to create data models, establish relationships, and add simple or complex calculations.

First up, we need to incorporate some tables into the Data Model. Here’s what we’ll be adding:

1. Address;
2. Product Base;
3. Calendar;
4. Sales 2024;
5. Sales 2023.

The first three tables are Dimension tables, and the last two are Fact tables. What does this mean?

Fact tables contain numerical data that are central to our analysis—think of things like customer orders or time-series financial data. On the other hand, Dimension tables provide the necessary context and background information, often representing physical entities like 'customer' or 'product.' Both types of tables are crucial for effective data analysis and informed decision-making.

If you would like to review or revisit the information covered in the video, here's an e-book with step-by-step explanations for you.

In the next video, we’ll focus on creating relationships between the data. See you then!