Workout
Excel
Take on our workout exercises designed to augment your data skills and advanced Power Query expertise.
Note: This workout is a bit different from the others.
Why Participate
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.
What our Students Say
Your Instructor
EDNA Team
Frequently Asked
Questions
What’s the difference between a free account and a paid plan?
Do I need to know anything about data science or data analytics to get started with Enterprise DNA?
How will I be charged?
Can I get an invoice for my company?
Are refunds available?
Will AI take over the world and make data skills worthless?
Get full access to unparalleled
training & skill-building Workouts
FOR INDIVIDUALS
Enterprise DNA
For Individuals
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.
Learn MoreFOR BUSINESS
Enterprise DNA
For Business
Training, tools, and guidance to unify and upskill the data analysts in your workplace.
Learn MoreLatest Workouts
Loading