Workout

Excel

Take on our workout exercises designed to augment your data skills and advanced Power Query expertise.

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

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
Empty image or helper icon

EDNA Team

With Enterprise DNA Workouts, you can refine and develop your data skills through interactive exercises. Learn by doing and receive guidance from the world's best experts. Join other data analysts today and seize this amazing opportunity!

Frequently Asked

Questions

Get full access to unparalleled

training & skill-building Workouts
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More
power-bi-custom-visuals
Latest Workouts

Loading