Power Query Workshop (Live Online)

High Quality Training Created From a Practical Point of View.

No prior knowledge of Excel required!

Online Classes

Online Classes

Take the live classes from anywhere around the world with an internet connection. No need to travel to a classroom, let the classroom come to you.

Video Recordings

Video Recordings

You’ll be able to download the full recordings of the Workshop in order to revisit any topics. (Full HD recordings)

Homework & Samples

Homework & Samples

In order to get you started, we’ll provide you a full set of examples and homework that we’ll revisit during our Q&A Time.

Free eBook

Free eBook

Take home even more tricks and patterns with this free eBook, ‘M is for Data Monkey’. This workshop is based on our upcoming book ‘M is for Data Monkey’

Top Instructors

Top Instructors

You’re not getting one but two top quality instructors, both of whom are Microsoft Excel Most Valuable Professionals and experts in the field.

Q&A Session

Q&A Session

One week after the workshop we’ll provide a full Q&A Session in order to address any questions that may arise during the practice and homework.

Download the Course Brochure

Aimed Towards

Excel Users

Users that employ Excel on a daily basis and want to exploit the full power of the new Excel Business Intelligence tools to improve their reporting and data crunching capabilities.

IT & BI Specialists

Professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from different analytical and relational sources.

large_323_MDataMonkey700[1]

Get a free copy of this book

Sign up for the workshop and get a free copy of the eBook

Note: By registering, you will receive a digital copy of this book.
About the Book

Workshop Content

As business professionals and employers, we understand that the value of a training session is in making sure the participants learn skills that they can apply in their daily jobs.

Our goal with every course is to ensure that all of our students learn real skills that can be applied in the real world. To maximize learning, we provide:

  • Solid instruction
  • Followed by hands on labs
  • Example files, each of which is built from real life scenarios that we’ve experienced
  • Custom Q&A Session to address any questions or special scenarios

Topics Covered

  • Introduction to Power Query and its usefulness to an Excel user
  • Appending multiple files together into a single data set
  • Cleaning imported data for analytical use
  • Sorting and grouping imported data
  • Transforming poorly structured data into useful data sets by un-pivoting, transposing, sorting and grouping
  • Understanding M syntax and how to create custom functions
  • How to import csv, txt and Excel files
  • How to import from databases, web pages and Microsoft Exchange
  • Creating your own data by using custom columns and Power Query formulas
  • Implementing conditional logic in Power Query columns
  • Exploring the benefits of the M coding language and how it will take your Power Query skills to superb levels
  • Creating and implementing calendar and parameter tables
  • Sharing your solutions with others
  • Best practices for landing and organizing queries for use in Excel and Power BI

S2A English Final

We’ve developed the most optimal path to teach Power Query

Meet the Instructors

Two Excel MVPs and Power BI professionals.
KenPuls-5506_5x5_Colour

Ken Puls, CPA, FCMA

Is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.

He has held the Microsoft MVP distinction since 2006, and has been recognized as a Fellow of his accounting organization.

Miguel Escobar

Is an Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks.

He also holds the Microsoft MVP distinction and Microsoft Certified Professional for Excel.

Workshop Schedule

¹ Prep Time

Once you register, you’ll receive a set of files that you can check out before the course. These files include the handouts, sample files, workshops and more

² Live Course

2 Sessions, 4 hours each, delivered in 2 days to cover from the basics of Power Query to the advanced topics of the M Language.

³ Q&A Session

A complete session to address any questions regarding the topics covered in the course, samples, exercises and open questions

Notes

  • All of the online sessions will be delivered through a GoToTraining Session and the recording of such sessions will be made available to the participants no later than 24 hours after the session is finished.
  • You can complete the exercises after each session or, if you prefer, you can do so at any time before the Q&A session. We will address these exercises and any other questions that may arise from the course or the exercises during our Q&A session.

Register For a Live Online Workshop

Price: USD$595

Day 1


May 24, 2017 @ 11AM Eastern (New York)

Day 2


May 25, 2017 @ 11AM Eastern (New York)

Day 3


June 8, 2017 @ 11AM Eastern (New York)

Register


Register

If you are interested in joining our affiliate program then click here to learn more.

Private & OnSite Workshop

Let us bring the Power Query training to you!

Learn

The techniques from the pros

Design

Solutions using YOUR data

Implement

Solutions for YOUR business

Save

Both time and money

Testimonials

What attendees think about the workshop

IT WAS ABSOLUTLY INCREDIBLE! Actually I know already a lot about Power Query, but your examples and cases were absolutely great

Stefan, June 2015

this was one of the absolutely most wonderful excel training classes I’ve ever attended! The assignment guide was awesome! Whoever created that did an absolutely thorough job!

Elizabeth, June 2015

I really enjoyed the class and found it very useful. The content was very strong.

Alex, June 2015

Excellent content and I loved the way the instructor conducted the workshop

Martin, June 2015

I’ve loved this course!! I think it perfectly complements Power Pivot

Juan, June 2015

I really enjoyed it

Samira, June 2015

Join our newsletter now and get a FREE copy of our eBook

'Magic Tricks for Data Wizards: TIps & Tricks for Power Query in Excel & Power BI'

x