- Power Query Introduction

- Import Data into Power Query
- Import Data from Excel File
- Import data from other files / folder

- Loading and Refreshing
- Load data and refresh query when source data changes

- Data Transformation
- Column Transformation
- Row Transformation

- InBuilt Transformations in power query
- Text Transformation
- Numbers transformation
- Date transformation
- Conditional Column transformation

- Consolidate and Append Data
- Append data from Excel tables within same Excel file
- Append / Duplicate / Reference multiple Queries
- Import data from files in a folder
- Import data from multiple excel files in a folder
- Changing file path for source data

- Merge Quires/Multiple joins in power query
- Multiple JOINS in power query (Merge Queries)

- Building Blocks of M Language
- Introduction to building blocks in M
- Text functions in Power Query
- Date functions in Power Query
- Conditional Functions in Power Query

M Language
============================================================

1. Date functions
2. DateTime functions
3. Duration functions
4. Number functions
- Information
- Conversion and formatting
- Rounding
5. Replacer functions
6. Splitter functions
7. Text functions
- Information
- Extraction
- Modification
- Transformations
8. Time functions

Dax Functions
==============================================================

1. Filter DAX Functions
2. Table Manipulation DAX Functions
3. Logical DAX Functions
4. Text DAX Functions
5. Aggregations DAX Functions
6. Time Intelligence DAX Functions
7. DATE & TIME DAX Functions