Power Query

With Power Query, business users who use Excel can immediately begin extracting, transforming, and combining disparate sets of source data into meaningful information and knowledge to help them gain important insights about their businesses. 

Power Query also provides you with the ability to pull data from an online search, an external website, a file, an internal database, or another data source such as Facebook or SharePoint to create powerful data mashups and derive new intelligence from your data. 

Power Query can accommodate most, if not all, of your source data needs.  To put it simply, Power Query is one of the most versatile and user-friendly Self-Service Business Intelligence Extract Transform Load tools on the market today.
This one-day course will show you how Power Query introduces a new level of easy-to-use tools for extracting, transforming and loading data.
Workshop Content
Introduction to Power Query

Benefits of Power Query


Loading data into Power Query
- Microsoft Access Tables
- CSV files
- online data sources
- modifying tables

Merging Data

Appending Data

Unpivoting Data

Using the Group function

Creating Custom Calculations 
Duration
1 day 
Requirements
Completion of Advanced Excel:  PivotTables and Excel PowerPivot. 

Your own laptop with Excel 2013, with Power Query loaded.
(If you do not have your own laptop, we can provide one for you to use for the course)  
Cost
R1 800 per person excluding VAT
Price is for training in Gauteng.
Price is for in-house training for 6 people or more.
Valid until 31 December 2017.

​We are happy to discuss all your training needs and work with you to meet your requirements.