Power Up with Power Query Online

Authors: Matt Allington, Ken Puls, Miguel Escobar

This course developed by Matt Allington, Ken Puls, and Miguel Escobar will teach you different techniques to clean, shape, re-shape the data with Power Query. You will get hands-on experience practicing along with the demos in the videos.

Duration:
3h
Tools:
  • Power BI
  • Excel
  • Power Query
Skills:
  • Data Acquisition
  • Data Shaping

What you'll learn?

  • Pivoting Stacked Data
  • Unpivoting Subcategorized Data
  • Pivoting Vertical Pairs
  • Pivoting Horizontal Pairs
  • Numbering Grouped Rows
  • Manual Creation of Custom Functions
  • Debugging Custom Functions
  • UI Assisted Parameters and Functions
  • Advanced Table Append
  • Managing Changes to Columns
  • List of Values to Filter Columns
  • Convert UTC to Local DateTimes
  • Switching Time Zones
  • Optimizing Power Query Settings
  • Leveraging Buffer Functions
  • Reducing Development Lag
Course

Power Up with Power Query Online

$149Renews at $39 per year
(All prices in USD)
  • 3h of training content
  • 4 modules
  • Downloadable files and Handouts
  • Support and Discussion
  • Certificate of Completion

Power Up with Power Query Online

$149

Course Description

Power Up with Power Query Online is a structured, online training course that covers the various techniques with which you can clean, shape, and re-shape your data. 

This course is created and delivered by Matt Allington, Ken Puls, and Miguel Escobar.

Power Up with Power Query Online comprises of:

  • Self-paced viewing of online videos.
  • Hands-on practice following the demos in the videos and solving the practice exercises.

Course Coverage

See the Course Content below for the Lessons covered in this course.

How it Works

 Upon registration, you will receive access to the Online videos and downloadable course materials.

You can choose to complete the course material any time based on your availability and time preferences. And you can view the videos again any time later when you are solving relevant business problems.

How long can videos be accessed?

Power Up with Power Query Online is built on an annual subscription basis. 

Your access is valid initially for one year, and you can choose to renew it annually at your own discretion.

You will have access to online videos and course materials as long as your subscription is active.

(Please see the How Subscription Works section below for more information.)

Reviews

Power Up with Power Query

Average Rating

0 / 5

(based on 0 reviews)

0/5
No Reviews
Read More
There are no reviews of this course

Course Update Log

First release of this course.

Course Formats

On-Demand
This is an online course developed and delivered by Matt Allington, Ken Puls, and Miguel Escobar. You can view the pre-recorded videos at your own pace and practice the exercises following the demos. The course comes with all required sample files, and practice workbooks.

How does the subscription work?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the authors

Matt Allington

Matt Allington

Microsoft MVP
Matt Allington is one of the founding partners of Skillwave.Training, and the founder of Excelerator BI in Australia. He is an expert in Power BI and DAX training, and has 30+ years of experience in using data to deliver business value. Matt is an author, blogger, and eight-time Microsoft MVP that specializes in Power BI, Power Pivot, and Power Query. He brings his business and IT experience to solve general business data problems quickly and efficiently.
Ken Puls

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.
Miguel Escobar

Miguel Escobar

Microsoft MVP
Miguel Escobar is an Excel specialist turned Business Intelligence expert using the latest tools from Microsoft – Power BI and Power Query. He is the co-author of Master your Data with Excel and Power BI (formerly M is for (Data) Monkey), a blogger, and a Youtuber of powerful Excel tricks. Before joining the Power Query team at Microsoft, he helped found Skillwave.Training and was previously recognized as a Microsoft MVP and a Microsoft Certified Trainer (MCT).

FAQs

Why is this course a subscription?

One of the key features of this course is that you get access to the online videos. At the end of the first 12 months you can continue to subscribe and keep these benefits, or you can cancel your subscription and end your participation at that time. You will receive an email about 4 weeks before your subscription is renewed so that you can choose to opt out if you want to.

If I get distracted, can I come back and do it later?

Definitely. This is a subscription based course, and gives you access to the online videos and practice exercises. You can do self-paced learning as per your convenience. You can renew your subscription to continue to have these benefits.

Is there a specific time to join the course?

No, you can register at any time. Your subscription is valid for one year from the purchase date, and you get immediate access to the on-demands videos and downloadable course materials.

How do I access the course materials? Are they downloadable?

The pre-recorded videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for the course are downloadable.

Where are the pre-recorded course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering to the course, to ensure that you will be able to see the videos.

How do I receive my Certificate of Completion?

After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.

How do I renew my subscription?

If you subscription is set to auto-renew, our system will automatically renew your subscription for another year on your renewal date using the billing information on file. If you subscription is set to manual renewal, our system will generate a manual invoice and email it to you on the renewal date. About a month (4 weeks) before your next renewal date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details so your access is uninterrupted.

How do I cancel my subscription?

You may cancel your subscription at any time, and you will continue to have access to all of your course materials until your expiry date. To cancel your subscription, go to the Billing page from your Account Dashboard and select the subscription to cancel from the My Subscriptions area. Once in the Subscription Details page, you can then choose to cancel your subscription from the Actions field. After your subscription expires, you will not longer have access to the course materials, including the downloadable 'Supercharge Power BI' and 'Supercharge Excel' books.

What payment methods do you accept? What currency is used?

We accept credit card payments through our secure online payment portal, Stripe. If you would like to discuss other payment options, please get in touch through our Contact Us page. All transactions are charged in US Dollars. Please note that because Skillwave is registered in Canada, we are required by Canada Revenue Agency to collect the 5% Goods & Services Tax (GST) on registrations made by Canadians.

What is your refund policy for this course?

We think you will love our training; however, if you are unsatisfied with the training for any reason, we offer a 14-day 100% money-back guarantee, as long as you have completed less than 25% of the course. All we ask in return is that you tell us why you were unsatisfied with the training. We do not offer refunds if you have completed over 25% of the course and/or it is more than 14 days after the purchase date.

Can an account be shared with or transferred to another user?

Login credentials, downloads, and other course materials are for the exclusive use of the registered user only. Sharing of credentials is in violation of our site policies and may result in termination of product and/or site access without notice.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

11h 30m
22 Modules
$495
11h 45m
19 Modules
$270