Power Query & Power Pivot

A 2-day intensive training in Power Query & Power Pivot

DURATION:  2 DAYS (16 HOURS)

DIFFICULTY LEVEL: INTERMEDIATE

OUTLINE

1. 1.  Introduction

Big data components

Big data and small data

Sources of big data

Big data structure

Big data analysis

Tools and technology

The Microsoft Data Platform

2.  An introduction to Table

Function of the Table

Creating the Table

Slicers

3.  Extracting, Transforming and Loading with Power Query

What is Power Query?

Connecting to data source & importing data

Creating a new query

Merging & appending queries

Automating consolidation of files

Creating an index

Changing data types, data format & replacing values

Merging columns

Unpivoting & pivoting columns

Replacing values in columns

4.  Excel Power Pivot

Getting started with Power Pivot

Importing data into Power Pivot

Understanding Power Pivot & Relationships

Creating Relationships between Tables

KPIs

Hierarchies

Data Analysis Expressions (DAX) language- SUM, SUMX, CALCULATE, RELATED, &&, FILTER

Power Pivot and OLAP Pivot Tables