Applied Problem Solving with Power Query/M

Deepen your understanding of the Power Query/M concepts through practical application

schedule5 hours
play_circle7 videos
unfold_more18 exercises
trending_up790 xp

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

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

An outline of this training course

True to our promise of giving you a practical content as follow up to our Power Query/M Masterclass, Melissa de Korte prepared a course that is centered on applying M concepts to solve six different scenarios. She, together with other experts, will guide you through the process of breaking down a practical problem and show you the solution using Power Query/M.

The course is perfect for Power BI users who know the basics and are ready to get some advanced Power BI knowledge through Power Query; have started using Power Query and are hoping to understand the topic better; have started using Power Query and are looking for a different approach; those who are looking for ways to use Power Query in their line of work; and those who are looking for specific scenarios where Power Query could prove useful to them.

To get the full benefit of the course, it is advisable to take the Data Transformations and Modeling course by Sam McKay and the Power Query/M Masterclass by Melissa.


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 can be applied to a wide range of problems
  • Expand - Power Query/M skills, thereby improving your data model, enhancing your report performance and simplifying your DAX

What you get with the course

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

What our

Students Say
Curriculum
1

Applied Problem Solving with Power Query/M


2

Let's Review


3

Feedback


4

Certification


Your

Instructor
Empty image or helper icon

Melissa de Korte

Enterprise DNA Expert

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

Frequently Asked

Questions

Recommended

Courses
Course Cover: Amplify Your Learning With Data Mentor
beginner
Total points: 328 XP clock-blue 3 hours

Amplify Your Learning With Data Mentor

Designed to guide users through the platform's features, including AI tools integration and query management. It aims at enhancing productivity and fostering a daily learning habit, catering to both beginners and experienced users seeking to optimize their data-driven decision-making skills.
Tools
Other Tools
Skills
Process Automation
Business Analytics
Data Analysis
Sam McKay
Sam McKay
See details
Course Cover: Navigating Financial Data with Python
intermediate
Total points: 168 XP clock-blue 1 hours

Navigating Financial Data with Python

Elevate your financial analytics skills with Python for Finance, exploring cutting-edge techniques for data retrieval, time series analysis, and predictive modeling.
Tools
Python
Skills
Data Analysis
Advanced Analytics
Gaelim Holland
Gaelim Holland
See details
Course Cover: Python-Powered Marketing: Strategies and Insights with ChatGPT Integration
intermediate
Total points: 189 XP clock-blue 1 hours

Python-Powered Marketing: Strategies and Insights with ChatGPT Integration

Elevate your marketing capabilities by integrating Python's robust analytical and data visualization tools, enhancing marketing strategies with insights powered by Python.
Tools
Python
ChatGPT
Skills
Data Analysis
Advanced Analytics
Gaelim Holland
Gaelim Holland
See details

Get full access to unparalleled

training & skill-building resources
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 chevron_right

FOR BUSINESS

Enterprise DNA

For Business

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

Learn More chevron_right
power-bi-custom-visuals