What is Power Query & Power Pivot?
- Power Query
- What is Power Pivot?
- How the tools should be used together
Importing Data into Excel & the Model
- From Text Files
- From CSV Files
- From Web
- From Folder
- From Excel ranges and sheets
Understanding Power Query
- Understanding the Power Query interface
- Renaming and deleting steps
- Cleaning messy data example
- Refreshing a query
- Power Query Options
Common Power Query Features
- Unpivot Columns
- Setting Data Types
- Append Queries
- Merge Queries
- Using the Advanced Editor
Understanding Power Pivot
- How to access Power Pivot
- Understanding the Power Pivot Interface
- Different Power Pivot Views
Creating the Data Model
- Create table relationships
- Edit and delete relationships
- Understand filter context
Getting Started with DAX
- How is DAX different to Excel Formulas
- Calculated Columns vs Measures
- Creating a Calculated Column
- Creating Measures
- Using Common DAX Functions
Getting Started with DAX
Lookup and Filter DAX Functions
- Why these functions are useful?
- RELATED Function
- CALCUALTE Function
- FILTER Function
PivotTables and PivotCharts
- Creating a PivotTable from the model
- Working with the model in a PivotTable
- Filter data using Slicers