Power Query

A one day deep– dive training on Power Query.

DURATION:  1 DAY (8 HOURS)

DIFFICULTY LEVEL: INTERMEDIATE

OUTLINE

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.  Working with Table

Excel tables

New features of Tables

 3.  Excel 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