Power query sale2019-02-26T19:16:31+00:00

POWER QUERY COURSE

If you have been wasting vast amounts of time at work trying to gather, fix and combine your Excel data before you’ve even done any analysis and reporting, then let our resident Data expert show you how Power Query can transform the way you work!

SIGN UP

HOW POWER QUERY CAN PREVENT TIME WASTING

Power Query is the No.1 Excel feature added in the last decade because it can help you get data from various sources, no matter what format it is and clean it all up for you with nothing more than a few clicks! Specifically, there are two ways Power Query saves you vast amounts of time:

  • If you have reports that are frequently updated, then you just create a ‘Query’ from a source of data then all you need to do is press refresh every time you need to update, and Power Query will carry out all the little steps needed to clean up your data
  • If you work with messy or unstructured data that consumes a lot of your time to clean up, then Power Query has some functions that instantly fix your data such as unpivoting, appending, joining and transposing to name a few

Power Query’s magic is in saving you from all the usual ways to clean up your Excel data that are far too time consuming. But it’s not just Excel data you clean up, it’s any data from most Databases, SAP, Salesforce, SharePoint and so on.
This is great for Data Analysts, Business Intelligence Analysts, MI Analysts, PMOs and even Accountants who deal with lots of complex data

ABOUT THIS COURSE

This video course is taught by our in-house Data expert Ross Hughes who has over 30 years of experience working with Data in senior technical roles within major companies. In a few short hours of self-paced training, Ross will have you going through the full cycle of ‘Getting, Transforming and Refreshing’ your data, after which it will be ready for a quick analysis and report.
Ross’ experience is priceless, he shows you how to harness Power Query like few can and having him, teaching you ‘over his shoulder’ is more than worth the price of the course.

WHAT YOU WILL LEARN

Ross will teach you all you need to know about Power Query to help you deal with difficult data challenges

  • Introduction to getting data from various sources and cleaning it up
  • Rapidly transpose, pivot and un-pivot your data to make it useful
  • How you can quickly combine multiple data sets by appending and joining
  • Speed up your data queries with duplication and tweaking parameters
  • Troubleshoot your queries and set up auto refreshing of your data

Details below

WHAT YOU GET IN THIS TRAINING COURSE

  • 5.5 Hours Training Material Split Over 40 Video Lessons
  • Compatible with Excel Office 365, Excel 2019/2016/2013/2010/2007
  • *Download videos to your device and watch offline (See FAQ for more details)
  • Excel files with exercises that help you to learn the lessons with ease
  • 6 months of support from Excel experts with a corporate background
  • Track your progress and take your own notes
  • 30-day money back guarantee
  • Get a certificate of completion that you can display on LinkedIn

COURSE CONTENT

1.1 Introduction to Power Query03:16
1.2 Getting Familiar with the Power Query Editor09:24
1.3 First Data Clean Up for a Pivot Table07:06
1.4 Tweaking our Query until the data is correct 09:25
1.5 Rounding data 04:28
1.6 Altering Data Types02:19
1.7 Filtering out data before we load it01:09
1.8 Advanced Calculated Columns09:00
1.9 Grouping Columns 07:03
1.10 Using Columns From Examples08:40

2.1 Introduction to Transpose, Pivot and Un-Pivot09:43
2.2 Pre-preparing messy data07:30
2.3 Appropriating our data with Transpose06:24
2.4 Un-Pivoting Data06:24
2.5 Pivoting Data09:25
2.6 Creating a Pivot Chart 02:34
3.1 Appending data08:39
3.2 Introduction to Merging data01:33
3.3 Left Outer Join06:37
3.4 Right Outer Join04:19
3.5 Full Outer Join06:19
3.6 Inner Join03:30
3.7 Left Anti Join02:19
3.8 Right Anti Join02:58
3.9 More appending with bigger data sets13:29
3.10 Going deeper with Merging data23:13
4.1 Duplicating Queries06:43
4.2 Speeding up query editing with duplication08:15
4.3 Filtering duplicated queries04:17
4.4 Working with References04:34
4.5 Parameters25:04
5.1 Functions14:58
5.2 Dealing with Errors13:12
5.3 Steps Part 1: Troubleshooting Queries17:20
5.4 Steps Part 2 09:34
5.5 Queries and Groups 12:55
5.6 Advanced Query Editor13:36
5.7 Query Refresh 07:29
5.8 Dependencies07:46
5.9 Revisiting Combining Queries06:37

SAMPLE LESSON