Platform Access

Data

Transformation
Expert

This path is focused on developing expert level skills in data cleaning, data transformation and data modeling. You will learn to maximize the capabilities of the Power Query UI, and also write M code for both single use solutions and to build custom functions to speed the processing of recurring tasks.

Dashboarding & data Visualization Intensive

About This Path

Within this learning path you will master the data transformation aspect of Power BI development.


By understanding the power within the Power Query engine you can save an incredible amount of time and really scale your development efforts, automating a vast amount of your day-to-day data tasks.


You will learn best practise frameworks for leveraging the Power Query editor when creating and designing Power BI data models.
Through practical learning examples and resources you will learn how to review an existing raw dataset and then transform it into an optimised dataset for Power BI.


This is the foundation of any reporting application in Power BI.


With you work complete in the Power Query editor you will then be able to build a simpler data model for analysis. Following this, your analysis using DAX formulas and report visualizations become more intuitive and easier to implement within Power BI Desktop.

Who Should Take This Path

  • Power BI Users who want to advance their skills with Power Query
  • Data analysts who want to optimize their use of the Power Query/M
  • Students who want to have a strong Power Query skills

What Are The Path Requirements

  • Power BI account for Power BI Desktop

and Power BI Service

Start Your Data Transformation Expert Path Now

Meet 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 analysing business process data. Delivering, deploying and supporting Power BI solutions throughout the organisation.


All-round Power platform enthusiast.

Join other Enterprise DNA Members

View More Testimonials Here

Want to keep exploring?

Check Out These Other Learning Paths

This path is designed to help you become an expert in data visualization, data storytelling, and report design. You will learn how to make the most of native Power BI visuals, skillfully utilize the best AppSource visuals, and create advanced custom visualizations using bespoke visualization languages including Deneb/Vega-lite, HTML/CSS and ggplot2.


Path Info

This path is designed to help you harness the full power of Power BI in combination with R and Python. You will learn how to conduct advanced statistical analyses, text and sentiment analysis, leverage machine learning techniques and other key methods commonly used to gain insight into complex business questions.


Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

On-Demand

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

For Teams

Enterprise DNA

Center of Excellence

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