In this chapter, you will learn how to create data models in Excel containing more than one table, create relationships between tables, and learn about the Power Pivot add-in and the DAX language that can be used to write formulas in this add-in.

After this chapter, you will no longer be afraid of tables containing more than a million rows, you will be able to create one pivot table above the data of several input tables, and the DAX language will provide truly endless possibilities for your calculations.

Last modified: Tuesday, 3 January 2023, 1:56 PM