Excel Power Query and PowerPivot

Lesson 1: Introduction To Power Query

Introduction

Installing Power Query

Lesson 2: Data Loading From Sources

Working with CSV files, Text Files and Excel Files

Working with other file types

Lesson 3: Working With Folders And Multiple Files

Connecting to a Folder of Files

Combining Data from Multiple Files

Lesson 4: Filtering And Managing The Columns

AutoFiltering

Removing Duplicate Values

Moving, Removing, Splitting, Merging Columns

Lesson 5: Working With Tools

Text-Specific Tools

Number-Specific Tools

Date-Specific Tools

Adding index

Lesson 6: Table Transformations

Unpivoting Columns to Rows

Pivoting the values

Transposing a Table

Lesson 7: Modifying Queries

Appending Queries

Workbook Queries

Merging Queries

Day 2: Power Pivot Training Course Outline:

Lesson 1: Getting Started With Power Pivot

Enable and Navigate Power Pivot

Manage Data Relationships

Lesson 2: Visualizing Power Pivot Data

Create a Power Pivot Report

Create Calculations in Power Pivot

Lesson 3: Working With Advanced Functionality In Power Pivot

Create a Key Performance Indicator

Work with Dates and Time in Power Pivot

Appendix A: Commonly Used DAX Functions