Platform Access

Applied Problem Solving with Power Query/M

Deepen your understanding of the Power Query/M concepts through practical application. A course that is centered on applying M concepts to solve different scenarios and perfect for Power BI users who know the basics and are ready to get some advanced Power BI knowledge through Power Query.

Enroll Now
Applied problem solving Hero, Applied problem solving with power query and M code course

Here's What You'll Get

With The Course

Over 5 hours of discussion on problem-solving using Power Query/M

R For Power BI Users

Resource pack

Applied Problem Solving

Solve practical problems with Power Query/M

  • Centered on applying M concepts to solve six different scenarios
  • Process of breaking down a practical problem and showing you the solution using Power Query/M

Details Of What You Will Learn

During This Course

  • Gain - a better understanding of how to apply the fundamental building blocks (table, lists, functions, etc.) of Power Query/M to solve practical problems
  • Better understand - the expert mindset in how to break complex problems down into manageable pieces, and then use those pieces to construct a full solution
  • Learn - new techniques and reusable patterns that
  • Expand - Power Query/M skills, thereby improving your data model, enhancing your report performance, and simplifying your DAX
Applied Problem Solving

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Perfect for Power BI users who know the basics and are ready to get some advanced Power BI knowledge through Power Query

LEARN HOW TO

Utilize the key features within the Applied Problem Solving with Power Query/M

Applied problem solving
  • Advanced Power BI knowledge through Power Query
  • Understand Power Query better
  • Looking for a different approach
  • Looking for ways to use Power Query in their line of work
  • Specific scenarios where Power Query could prove useful to them

Course Curriculum

1. Applied Problem with Power Query/M

  • Course Intro
  • Refer to the Previous Row with Subgroups - Goodly PQ Challenge
  • Access Analytic Challenge, 3 solutions
  • Bulk Find and Replace
  • Extract All Hierarchy Levels, Recursive Transformation
  • Recursive Calculation, List.Generate
  • Convert a PDF to a Tabular Format

What our Students Say

Your Instructor

Melissa de Korte - Power Bi

Melissa de Korte

  • Skilled in ETL and Modelling. Delivered practical Power Query solutions in both Excel and Power BI.
  • Expertise in analyzing business process data. Delivering, deploying, and supporting Power BI solutions throughout the organization.
  • All-round Power platform enthusiast.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA Membership Subscription.

  • Can I purchase a single course instead of the full Enterprise DNA membership? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

Membership

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

membership enterprise dna

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace