In this lesson, you will understand how to load data into Excel Power Pivot data model, create relationships between the tables, and define measures. The DAX skills that you have learnt in Power BI are transferable to Excel. The only difference is UI and once you know how to do it in Excel, you can do data modelling in Excel as well.
|Ensuring Power Pivot tab is visible||00:55|
|Legacy loading approach||02:36|
|Loading data using Power Query||04:05|
|Inserting a pivot table using data model||06:30|
|Creating a measure||07:02|
|Editing a measure||07:48|
You can follow along with the examples shown in this lesson with the AdventureWorks Database.