Power QueryExercises

About Power Query Exercises

Power Query Exercises is a hands-on practice platform for Power Query and the M language, aimed first at Excel users, since that is where most people meet Power Query, and at Power BI users too. You work with realistic, fictional datasets, build transformation steps, read and edit the M they produce, and check that your solution still works when the source data changes. Today that means 80 lessons, 418 graded exercises, 35 guides, 40 function reference pages and 29 error explanations.

Who runs it

The site is built and operated by UMRATECH LLC, a company based in the United States. You can reach us at support@umratech.com. The terms, privacy policy and refund policy are published by UMRATECH LLC.

Who writes the lessons

Tahir Nas, software engineer, writes and reviews the lessons, guides and exercises. Tahir has 8 years of experience in tech, working across system administration, cloud architecture, QA, scripting and automation, and software engineering in many languages and mainstream databases. Find Tahir on GitHub.

How content is written and tested

An independent practice simulator

Exercises run in an independently implemented educational simulator that supports a documented subset of M. It is not Microsoft's engine and does not replace Power Query in Excel or Power BI. When the simulator doesn't support a function or option, it says so instead of guessing. The goal is that you can repeat what you practised in a real Excel or Power BI host.

Independence

Power Query Exercises is an independent educational platform and is not affiliated with, endorsed by, sponsored by, or approved by Microsoft Corporation. All third-party trademarks belong to their respective owners.