Note: This workout is a bit different from the others.
Power Query is one of the best tools available for data cleaning, preparation and transformation. It has a very well-designed UI that can tackle a large number of data problems, as well as in incredibly powerful language (M code, short for “Mash-up”) to handle more advanced transformations and the development of custom functions.
The Excel BI Excel/Power Query Challenge is an enormously popular practice exercise run by Excel BI founder and Enterprise DNA partner Vijay Verma. These exercises run daily, giving you the opportunity to rapidly level up you Excel and Power Query skills by solving intermediate to advanced problems (solutions typically involve writing some level of custom M code) in community with some of the top experts from around the world, including multiple Microsoft MVPs who regularly participate.
We currently have over 90 exercises posted and are working to get the remainder posted ASAP. Once we have those posted, we will also work on capturing the incredible archive of creative solutions submitted by the participating community.
How to submit your solution
When you have completed the workout, just post your code (in whatever tool you choose – in addition to Excel and Power Query, some participants submit solutions in SQL, Python and/or R). Please blur or hide the details of your code using the forum features.