Excel as a BI Tool - Power Pivot and Power Query 101 2019

Topics

• 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

Who should Attend

Anyone who wish to learn about Power Pivot and Power Query.