Description

Power Pivot, the second stage of the data analytics process covered in Power BI, is responsible for modeling the data. This involves managing the tables of data and their relationships, as well as any needed calculations.

Topics include:

• Controlling table and field visibility
• Creating relationships between tables
• Adding calculated columns to the data model
• Writing DAX expressions to add explicit measures