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.
DP-500 Prep: Data Transformation with Synapse & Power BI Cover

Paid Course

DP-500 Prep: Data Transformation with Synapse & Power BI

The first of the two-part preparation course for the Microsoft's DP-500 Exam Certification

advanced
advanced
11 Hours
Learn More chevron_right

Learning

Paths
23 assets
Path
Power BI Tools and Extensions

Power BI Tools and Extensions

This Learning Path delves into creating external tools for Power BI, emphasizing JSON integration and the Microsoft Analysis Services Tabular API. Participants will explore UI development challenges and gain insights into open-source perspectives in tool development.
Intermediate
8 Hours
Path
Power Platform Integration Expert

Power Platform Integration 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. 
Intermediate
17 Hours
Path
Microsoft Certifications

Microsoft 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).
Intermediate
50 Hours
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.
Beginner
14 Hours
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.
Intermediate
12 Hours
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).
Beginner
10 Hours
Path
SQL for Data Analysis and Business Intelligence

SQL for Data Analysis and Business Intelligence

This Learning Path delves into data manipulation and analysis using SQL and DAX. It covers techniques and practical code examples.
Intermediate
8 Hours
Path
Mastering M Code for Power Query

Mastering M Code for Power Query

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.
Intermediate
11 Hours

Learning

Center
23 assets
Course
DP-500 Prep: Data Transformation with Synapse & Power BI

DP-500 Prep: Data Transformation with Synapse & Power BI

The first of the two-part preparation course for the Microsoft's DP-500 Exam Certification
Advanced
11 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
3 Hours
Course
Machine Learning Models in Power BI

Machine Learning Models in Power BI

From Data Preprocessing to Advanced AutoML: Mastering Predictive Analytics in Power BI
Intermediate
1 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
Introduction to ChatGPT's Advanced Data Analysis (ADA)

Introduction to ChatGPT's Advanced Data Analysis (ADA)

Unlocking Advanced Insights with ChatGPT's Advanced Data Analysis (ADA)
Beginner
2 Hours
Course
ChatGPT for Power BI Users

ChatGPT for Power BI Users

Discover how to utilize ChatGPT within Power BI for enhanced data analysis, reporting, and interactive dashboards. Learn how to integrate ChatGPT into Power BI to create dynamic and conversational visualizations.
Beginner
2 Hours
Course
Python Beyond Excel

Python Beyond Excel

Mastering Data Analysis: Transitioning from Spreadsheets to Scripts
Beginner
2 Hours
Course
Foundations of Data Analytics

Foundations of Data Analytics

Delve deep into the realm of Data Analytics with 'Foundations of Data Analytics', emphasizing the significance and practicality of data-driven insights in contemporary decision-making.
Beginner
2 Hours

Virtual

Events
41 assets
Virtual Event
How To Create External Tool for Power BI (Part 1)

How To Create External Tool for Power BI (Part 1)

Create external tool to generate the Enterprise DNA extended date table (Holidays, Some Date Intelligence Measures, Set Sort By)
00:31:46 Hours
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
00:32:08 Hours
Virtual Event
Move From An Excel To Power BI Super User

Move From An Excel To Power BI Super User

Transfer your Excel skills into Power BI seamlessly.
01:21:14 Hours
Virtual Event
Emailing Data From Power BI Using Power Automate

Emailing Data From Power BI Using Power Automate

Know how to get DAX Query data from Power BI Desktop without having to write it yourself
00:44:35 Hours
Virtual Event
Introduction to Power Portals

Introduction to Power Portals

Discover how to add, view, edit, delete data from Microsoft Dataverse
00:37:02 Hours
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
00:54:11 Hours
Virtual Event
Power BI Report Automation Techniques

Power BI Report Automation Techniques

Get to telling your story faster within power BI with various automation tools and techniques
00:52:21 Hours
Virtual Event
Storytelling and Design in Action

Storytelling and Design in Action

Critical thinking to improve problem solving and decision making
00:54:46 Hours

Project

Center
18 assets
Challenge
OEE Manufacturing Report

OEE Manufacturing Report

Work on one of the most significant measures for manufacturing productivity - OEE
Challenge
Hotels Revenue Management

Hotels Revenue Management

Take on the challenge of creating an analysis report on hotels revenue management data.
Challenge
Jira IT Service Desk Analysis

Jira IT Service Desk Analysis

Produce insights for management level that can highlight any issues and prepare them for the audit
Challenge
EDNA Youtube Channel Data Analysis

EDNA Youtube Channel Data Analysis

Analyze Enterprise DNA's Youtube Channel Data to understand its audience and create a strategy to drive more channel engagement.
Challenge
Optical Data

Optical Data

Provide a business solution by creating an intelligence tool to use by large opticians
Challenge
Insurance Complaints

Insurance Complaints

Analyze the data of a large insurance company who are due to undergo an internal audit with regard to its complaint’s procedure
Challenge
Demo Challenge 4 - Power Automate Workflow

Demo Challenge 4 - Power Automate Workflow

Build a Power Automate workflow that shows how a user can save an excel file into a folder
Challenge
Data Challenge 2: Discovering Shopper Segments

Data Challenge 2: Discovering Shopper Segments

In this challenge, participants are encouraged to uncover distinctive shopper segments and present innovative insights.
Guides
9 assets
Resource
Constructing records in the Power Query M language

Constructing records in the Power Query M language

This resource provides comprehensive instructions on how to build and manipulate record data structures in Power Query M.
Resource
Row Index and Key Match Lookup in Power Query/ M

Row Index and Key Match Lookup in Power Query/ M

This offers techniques to retrieve and manipulate data based on specific row indexes or key matches, enhancing the flexibility and precision of data analysis.
Resource
Python Cheat Sheet: Essential Quick And Easy Guide

Python Cheat Sheet: Essential Quick And Easy Guide

When programming in Python, having a reliable cheat sheet by your side can be a game-changer. Python may be known for its simplicity and readability, but there’s no denying that its extensive range of features and functionalities is too much to memorize!
Resource
Unlock the ‘Each’ expression in Power Query/M

Unlock the ‘Each’ expression in Power Query/M

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

SQL Cheat Sheet

This SQL cheat sheet gives you the most common SQL objects and commands, including data types, DML and DDL statements, aggregate functions, string and date functions, and subqueries.
Resource
Disassemble and assemble tables in Power Query/ M

Disassemble and assemble tables in Power Query/ M

 This resource illustrates how users can manipulate data structures at a granular level, offering insights into how tables can be deconstructed for detailed analysis or data-cleaning purposes. 
Resource
Quick Fix to Show All Fields in a Expand Column Operation

Quick Fix to Show All Fields in a Expand Column Operation

In this guide, we will address a common issue when performing an Expand Column operation in Power Query. 
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

A comprehensive resource that demonstrates how to seamlessly merge tables from multiple files located within a single folder.