Excel as a BI Tool - Power Pivot and Power Query 101 2019 is a webinar that covers topics such as:
- Using the Data Model to Create and Manage Relationships
- Importing Data into Power Pivot - the why and how
- Creating a Pivot Table from Related Excel Tables
- The Benefits of using the Data Model
- An introduction to the DAX Formula Language to create simple Calculated Columns
- Creating a Pivot Table from Related Data Sources (including external sources)
- Using the Query Editor to Clean and Transform Data
Excel as a BI Tool - Power Pivot and Power Query 101 2019 is intended for Anyone who wish to learn about Power Pivot and Power Query.