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_more16 exercises
trending_up734 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

Feedback


3

Certification


Your

Instructor

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

add

What’s the difference between a free account and a paid plan?

add

Do I need to know anything about data science or data analytics to get started with Enterprise DNA?

add

How will I be charged?

add

Can I get an invoice for my company?

add

Are refunds available?

add

Will AI take over the world and make data skills worthless?

Recommended

Courses

Course Cover: ChatGPT to Improve Productivity in Excel
beginner
Total points: 178 XP clock-blue 1 hours

ChatGPT to Improve Productivity in Excel

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!
Tools
ChatGPT
Excel
Skills
Data Analysis
Process Automation
Henry Habib
Henry Habib
See details
Course Cover: Beginners Guide to ChatGPT
beginner
Total points: 167 XP clock-blue 1 hours

Beginners Guide to ChatGPT

Unlock the full potential of ChatGPT and take your language processing skills to the next level.
Tools
ChatGPT
Skills
Process Automation
Sam McKay
Sam McKay
See details
Course Cover: Beginners Guide to Power BI
beginner
Total points: 330 XP clock-blue 2 hours

Beginners Guide to Power BI

Build a solid foundation in using Power BI.
Tools
Power BI
Skills
Data Analysis
Data Modeling
Data Visualization
Sam McKay
Sam McKay
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