Enterprise DNA Skills

Data Transformation

Convert raw data into a more usable format, such as aggregating or restructuring data, standardizing data, or merging data from multiple sources.
Start Learning for Free
Data Transformation Cover

New to Data Transformation?

Start here.

Power BI Super Users Workshop Cover

Paid Course

Power BI Super Users Workshop

An in depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights from your own data.

beginner
beginner
6 Hours
Learn More chevron_right

Learning

Center

18 assets
Course
Power BI Super Users Workshop

Power BI Super Users Workshop

An in depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights from your own data.
Beginner
6 Hours
Course
Accessing Data via APIs in Power BI

Accessing Data via APIs in Power BI

Expand Power BI's capabilities in accessing a wide range of data using APIs
Intermediate
2 Hours
Course
Integrating Power BI with Power Platform

Integrating Power BI with Power Platform

Expand your Power BI report by integrating it with Power Platform applications to incorporate capabilities above and beyond just reporting on insights.
Intermediate
3 Hours
Course
DP-500 Certification Part I: Transform and Model Data using Azure Synapse Analytics and Power BI

DP-500 Certification Part I: Transform and Model Data using Azure Synapse Analytics and Power BI

The first of the two-part preparation course for the Microsoft's DP-500 Exam Certification
Advanced
8 Hours
Course
Power Query/M - Nested Structures

Power Query/M - Nested Structures

Get familiar with structured values in the M language and discover how to interact with them.
Intermediate
3 Hours
Course
Fundamentals In Power Query And M

Fundamentals In Power Query And M

Acquire an extensive knowledge and understanding of the Power Query and M language to help you easily transform your data from multiple sources into Power BI
Beginner
2 Hours
Course
Data Transformations And Modeling

Data Transformations And Modeling

Learn how to clean, optimize and model data tables to develop effective, insightful and actionable Power BI reports
Beginner
4 Hours
Course
Ultimate Beginners Guide To Power BI

Ultimate Beginners Guide To Power BI

Premium Power BI training for individuals looking to develop their analytical thinking and capabilities.
Beginner
3 Hours
Course
DP-500 Certification II: Visualizing and Governing Data using Azure Synapse Analytics and Power BI

DP-500 Certification II: Visualizing and Governing Data using Azure Synapse Analytics and Power BI

The second part of the preparation course for the Microsoft's DP-500 Exam Certification
Advanced
6 Hours
Course
Applied Problem Solving with Power Query/M

Applied Problem Solving with Power Query/M

Deepen your understanding of the Power Query/M concepts through practical application
Advanced
5 Hours
Path
Advanced Analytics Expert

Advanced Analytics Expert

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.
13 Courses
Path
MS Certifications

MS Certifications

This path is designed to build the broad range of expert-level knowledge necessary to confidently pass the PL-300 Data Analyst certification exam (replacement for DA-100).
4 Courses
Path
Power BI Data Analyst

Power BI Data Analyst

This path is designed to build the broad range of expert-level knowledge necessary to confidently pass the PL-300 Data Analyst certification exam (replacement for DA-100).
13 Courses
Path
Power BI Mastery

Power BI Mastery

This path is the most in-depth and rigorous on the list, designed to provide you expert-level skills in all of the key pillars of Power BI. You will gain the knowledge necessary to achieve Enterprise DNA Expert Certification and potentially become a member of the Enterprise DNA Expert Team.
8 Courses
Path
Data Transformation Expert

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.
3 Courses
Path
Data Analytics Generalist

Data Analytics Generalist

This path is similar to the Data Analyst learning path above, but is geared to building a strong and broad foundation of data analysis skills, as compared to being more specifically focused on passing the PL 300 exam.
8 Courses
Path
Data Strategy Expert

Data Strategy Expert

This path is designed to help you build expert level skills in the implementation, monitoring and governance of Power BI, including making optimal use of the Service through dataflows, datasets, thin reports, etc.
3 Courses
Path
Power Platform Expert

Power Platform Expert

This path is designed to provide you the necessary skills to build full enterprise apps by integrating Power BI , Power Automate and Power Apps. You will also gain the expert level knowledge to pass the full Microsoft Power Platform certification series
7 Courses

Virtual

Events

10 assets
Accelerator
Power BI Accelerator - April 2023

Power BI Accelerator - April 2023

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI
Virtual Event
Learn to Become a Power BI Super User

Learn to Become a Power BI Super User

Learn the best practices for transforming data in the query editor
Virtual Event
DPLYR & Friends For Power BI Users

DPLYR & Friends For Power BI Users

Create basic pipelines for data cleaning, visualization and modeling in R
Virtual Event
Introducing Enterprise DNA Power Tools

Introducing Enterprise DNA Power Tools

How to create your own custom quick measures - create once, and apply them in every future report you do
Virtual Event
Introduction to Power Portals

Introduction to Power Portals

Discover how to add, view, edit, delete data from Microsoft Dataverse
Virtual Event
Sneak Peak Into Upcoming Versions of HTML Custom Visuals with Pascal Kiefer

Sneak Peak Into Upcoming Versions of HTML Custom Visuals with Pascal Kiefer

Sneak Peak Into Upcoming Versions of HTML Custom Visuals with Pascal Kiefer
Virtual Event
Scenario Modelling for Better Forecasting in Excel

Scenario Modelling for Better Forecasting in Excel

Using in-built standard Excel tools, we will explore how to reduce uncertainty in decision-making with sensitivity and scenario analysis
Virtual Event
Examples of Custom Power BI Visuals using Deneb

Examples of Custom Power BI Visuals using Deneb

See the Deneb custom visual for Power BI in-action with start-to-finish development of a bullet chart, a ring chart, and linked charts in Deneb/Vega-Lite
Virtual Event
Advanced Conditional Formatting with DAX

Advanced Conditional Formatting with DAX

Using visual layering and transparency masks to improve data storytelling Advanced tricks for conditional formatting icons
Summit
Enterprise Analytics Summit - November 2021

Enterprise Analytics Summit - November 2021

Enterprise DNA Analytics Summit are action packed live events showcasing a variety of beginner to advanced Power BI & Power Platform tips and techniques. 

Resources

7 assets
Resource
Disassemble and assemble tables in Power Query/ M

Disassemble and assemble tables in Power Query/ M

Resource
Constructing records in the Power Query M language

Constructing records in the Power Query M language

Resource
Quick Fix to Show All Fields in a Expand Column Operation

Quick Fix to Show All Fields in a Expand Column Operation

Resource
Row Index and Key Match Lookup in Power Query/ M

Row Index and Key Match Lookup in Power Query/ M

Resource
Common Methods to Conjure Tables in Power Query/ M

Common Methods to Conjure Tables in Power Query/ M

Resource
Unlock the ‘Each’ expression in Power Query/M

Unlock the ‘Each’ expression in Power Query/M

Resource
Step by Step Guide to combine tables from files in a folder

Step by Step Guide to combine tables from files in a folder