Power Query for Excel and Power BI Online Training

Power Query is a revolutionary tool to help Excel and Power BI Professionals get easy access to the data they need to do their job.  Power Query is easy to learn, and you can super charge your learning experience with this Online Training course specifically targeted to you.

Introduction and Overview


The course has been (and continues to be) developed by Matt Allington (Microsoft MVP and Author of the book “Learn to Write DAX”).  The course is approximately 2/3rds complete and hence is now available for purchase.  The rest of the course will be built out over the coming weeks with much of this new content likely to be available before you even get to it (depending on how fast you go of course).

Free Preview – Tips for Watching Videos

Free Preview – When to Use Power Query?

Why Should I Purchase?

  • It has been designed and created Matt Allington (Microsoft MVP).
  • Matt is a true Power BI/Power Pivot/Power Query professional who understands business users AND the technology that can solve these problems. ie he understands you and your problems.
  • The training is all “example based” using relevant real live scenarios to teach you the tricks.
  • All the examples in the course are available to download so you can do the exercises too.  This will greatly assist your learning.
  • It is great value at US$250 for 12 months access to the online materials

Course Content Code

Course Content

Course Duration – 4 hrs. 50 min. (to date – additional modules coming up)

Module 1: Introduction to Power Query - 42 minutes
Lesson Key Topics Covered
Tips for Watching Videos
5 minutes
Structure of each lesson
Watching the video on the website
Pausing and doing some practice
Finding the section a second time
Watching the videos faster
Welcome to Power Query for Excel and Power BI
3 minutes
Intro to training and trainer
Power Query UI Walk Through
13 minutes
Versions of Power Query
Where to download
Ribbon and button overview
Formula bar
Advanced editor
Loading data from Query Editor
Re-editing workbook queries
When to Use Power Query?
21 minutes
Power BI Desktop
Shape your data
Cleanse your data
Eliminate repetitive processes
Auditing information
Module 2: Loading From Data Sources - 89 minutes
Lesson Key Topics Covered
Data Sources Overview
4 minutes
Get & Transform commands in Excel 2016
Various data sources for importing data
Office 365 user options
Data Source Settings
Query Options
Creating a New Query – From Table
Close & Load from Query Editor
Show Queries Recent Sources
Importing Data from the Web
12 minutes
Finding the data you need
Split Columns
Copying Queries to Power BI Desktop
Refresh the data
Load Data From File
19 minutes
Importing data from a single CSV file
Importing data from an Excel file
Unpivoting columns
Importing multiple sheets from an Excel workbook
Combining multiple CSV files
Load From SharePoint
21 minutes
Connecting to SharePoint
Differences between Excel and Power BI Desktop
Managing Credentials
Importing from lists
Importing from document libraries
Nested tables of content
Data formatting in Power Query
Load From A Database
16 minutes
Connecting to a DB (SQL Server)
Select Related Tables
Naming Conventions
Joining Tables
Query Folding
Native SQL Queries
Using Your Queries
17 minutes
Do not Load – reuse in other queries
Power Pivot/Power BI
Power Pivot for Excel 2010
Excel Tables
Direct load to Pivot Tables
Module 3: Transforming Data - 66 minutes
Lesson Key Topics Covered
Power Transformations
16 minutes
Unpivot data
Pivot data
Temporary unpivoting
Pivot text data
Working with Rows
12 minutes
Use First Row as Header
Removing Top and Bottom Rows
Filtering Rows
Working with Duplicates
Pause to Check your Satisfaction You must be happy with the course and ready to proceed with other lessons.Just in case you are not you can stop here and ask for your money back.
Working with Columns
22 minutes
Removing
Splitting
Extracting
Merging
Duplicating
Numerical Manipulation
Index Columns
Conditional Columns
Changing Data
16 minutes
Transpose your data
Reordering columns
Removing columns
Changing row order
Reverse ordering
Module 4: Foundation Concepts - 33 minutes
Lesson Key Topics Covered
Reusing Queries
10 minutes
Disabling load
New query from reference
Copying queries
New queries from merge
Managing Queries
8 minutes
Reusing standard queries
Copying queries between applications
Using query folders
Query dependency view
Joining Queries
15 minutes
Append
Merge
Join Types
Grouping and Summarizing
Module 5: Power Query Patterns - 50 minutes (Course Development in Progress)
Lesson Key Topics Covered
Appending Multiple Files
19 minutes
Combining .CSV files
Combining Excel Files
Converting Queries to Functions
Differences between Power BI and Excel
Appending Multiple Tabs
13 minutes
Importing multiple sheets
Combining multiple sheets
Special trick to rename columns with a relative reference
Creating a Calendar Table
27 minutes
Used for Power Pivot and Power BI
Start from a blank query
Create a list of dates
Set the following editable fields
– Start
– Today
– Duration
Build out the Calendar
Copy and paste for reuse
Module 6: Tips & Tricks - (Course Development in Progress)
Lesson Key Topics Covered
Module 7: Advanced Concepts - (Course Development in Progress)
Lesson Key Topics Covered
Module 8: Tricky Examples - (Course Development in Progress)
Lesson Key Topics Covered

Additional Goodies

  • Course Material at the end of each lesson to follow through the examples given in the lesson.
  • Quiz at the end of each lesson to reinforce the concepts covered in the lesson.
  • Self-paced training with timestamps provided for all the topics to go through any specific section anytime.

Money Back Guarantee

Watch the first 12 lessons in the first 30 days. If you are not totally happy, simply contact Matt via the “contact the teacher” form to receive your money back. Any feedback is greatly appreciated but not required.

Ready to purchase? You can see the purchase online from my shop here and start learning immediately.

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!

x