Microsoft Excel Power Query

---

Course Overview

This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel.  The course uses Excel 2016, however Power Query works with Excel 2010 and above.  

Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.

Duration: 1 day course

---

Course Content

Course topics include-

INTRODUCTION TO POWER QUERY
Power Query Interface
Understanding Data Types

WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Importing Data
Transforming Data
Loading Data
Using Ranges in Excel
Understanding and Handling Special Situations
Appending Operations
Working with Folders and Files
Combining Worksheets
Using PivotTables

CONNECTING TO DATABASES
Understand working with relational data.
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understand and perform importing from SQL Server Analysis Services Tabular.

PERFORMING MERGES
Understanding the Issues
Performing Merges
Understand and utilize merges.

LOADING YOUR DATA
Loading into Excel
Loading into Power Pivot
Loading into Power BI Desktop
Importing, Transforming, and Loading Data into Excel and Power Pivot
Introduction to Power BI Desktop
Data Sources

GROUPING AND SUMMARISING WITH POWER QUERY
Grouping Options
Summarising

WORKING WITH THE POWER QUERY LANGUAGE “M”
Understand the M interface.
Understand Power Query formulas.

Email us about this courses


Telephone on 01952 938014