Advanced Get and Transform/PowerQuery: The Mashup Language

Learn the intricacies of writing "M"ashup for the PowerQuery engine within Microsoft Excel and Power BI to supercharge your data acquisition and analysis.

Advanced Get and Transform/PowerQuery: The Mashup Language

Learn the intricacies of writing "M"ashup for the PowerQuery engine within Microsoft Excel and Power BI to supercharge your data acquisition and analysis.
Share this class, get 20% off
Invite your friends to buy this item. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share the link to this page
One-time Purchase
List Price:  $99.99
You save:  $30
List Price:  د.إ367.26
You save:  د.إ110.19
List Price:  A$128.22
You save:  A$38.47
List Price:  ৳8,479.49
You save:  ৳2,544.10
List Price:  CA$126.28
You save:  CA$37.88
CHF 62.03
List Price:  CHF 88.62
You save:  CHF 26.59
List Price:  kr611.38
You save:  kr183.43
List Price:  €82.18
You save:  €24.65
List Price:  £73.04
You save:  £21.91
List Price:  HK$775.32
You save:  HK$232.62
List Price:  ₹7,302.63
You save:  ₹2,191.01
List Price:  RM404.40
You save:  RM121.33
List Price:  ₦37,946.20
You save:  ₦11,385
List Price:  kr844.98
You save:  kr253.52
List Price:  NZ$138.24
You save:  NZ$41.47
List Price:  ₱4,802.06
You save:  ₱1,440.76
List Price:  ₨16,033.39
You save:  ₨4,810.50
List Price:  S$132.35
You save:  S$39.71
List Price:  ฿2,996.70
You save:  ฿899.10
List Price:  ₺735.45
You save:  ₺220.65
List Price:  B$520.01
You save:  B$156.01
List Price:  R1,504.12
You save:  R451.28
List Price:  Лв161.11
You save:  Лв48.33
List Price:  ₩109,494.91
You save:  ₩32,851.75
List Price:  ₪318.70
You save:  ₪95.62

About the Class

Empower your ability to transform data

The Query Editor that supports Get and Transform is powerful and allows even the newest Excel users to create powerful data manipulation queries with only their mouse and, occasionally, a few keyboard inputs. Behind each query is the powerful Mashup language, "M" for short. Picking up even a few tips and tricks with the language itself can allow you to create even more useful and powerful queries far faster than with strictly the editor alone.

In this course, you'll dive behind the Query Editor to learn about the syntax and structure of M Code so that you can build queries with the query editor and make manual adjustments to create results not achievable strictly through the graphical interface.

Save time with reusable query code

Found yourself loving how quickly you can do so many things in the Query Editor but feel like you've been doing the same thing over and over? You probably have been, and there's a solution for that.

With a few extra lines of code, you can turn any of your queries that you've duplicated and re-used over and over again into directly re-usable functions that will save you time, hassle, and dramatically improve your ability to maintain, update, and edit your queries.

In this course, you will learn about how to build reusable functions from existing queries or from scratch to give you the ability to build custom reusable user functions within your Query Editor.

Incorporate complex logic into your transformations

Have you ever found yourself needing the results of an iterative calculation based upon a combination of fields or wanting to compute a compound calculation based upon other rows within the same data set?

These types of problems require complex logic that is generally the realm of true object-oriented languages and other solutions rather than database computations like those generated from SQL.

The "M" language allows for constructing loops, writing recursive functions, and incorporating proper error trapping and management as part of your queries, allowing you to incorporate the detailed logic necessary for your solution.

In this course, you'll learn how to do each of these things within the M language, using the query editor to guide and test your code as you progress.

Apply the concepts together to solve problems

The course has multiple challenges plus full-scale practice exercises to help you learn how to apply and combine the various components together. One large-scale exercise will have you applying everything you know about Get and Transform to build a series of queries and functions that can solve Word Search puzzles.

Each challenge and practice set has guided video explanations for how to arrive at the solution plus the solution files to peruse at your own pace.



Expert authors. Advanced topics. Clear explanations.
Share the instructor profile
Explainly offers online courses on powerful topics centered around the premise of instruction followed up with implementation through practical use. Our founders, Philip Trick and Ahad Amdani, are experts in their respective fields and offer courses designed around their expertise with a history of success building online courses for other...

Class Requirements

You should be familiar with PowerQuery in Excel or Power BI.

Be willing and interested in learning common programming concepts.

Have a desire to problem solve.

Class Contents

What's Included

Level: Intermediate
Duration: 3 hours 56 minutes
28 Videos
29 Documents
This class has not been saved

Sign Up


Share with friends, get 20% off
Invite your friends to TabletWise learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.