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
AI-Driven Data Science: Exploring PandasAI & ChatGPT

AI-Driven Data Science: Exploring PandasAI & ChatGPT

In the modern era of data, the AI-driven approach is rapidly redefining how data science operates. Our learning path, "AI-Driven Data Science: Exploring PandasAI and ChatGPT", is crafted to immerse learners into the realms of PandasAI and ChatGPT. The path focuses on harnessing the potential of these AI tools, enabling learners to analyze, visualize, and interpret data with enhanced proficiency. From the foundational principles of data analysis with PandasAI to the expansive capabilities of ChatGPT in data science, this path offers a comprehensive journey into the world of AI-powered data analytics.
Intermediate
5 Hours
Path
Creating Interactive Apps with Power BI and Power Apps

Creating Interactive Apps with Power BI and Power Apps

This Learning Path dives into SharePoint and Power Apps, focusing on leveraging Power Automate for task automation and improved user interaction. 
Intermediate
14 Hours
Path
Power BI Advanced Analytics Expert

Power BI 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 analyses and gain insight into complex business questions.
Intermediate
10 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
DAX Fundamentals in Power BI

DAX Fundamentals in Power BI

This Learning Path delves into data analysis and modeling, focusing on Filter and Row Contexts for data computations, and the use of functions like SUM, SUMX, and Calculate.
Beginner
12 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
49 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
AI Assisted Data Analytics

AI Assisted Data Analytics

This comprehensive journey introduces you to the transformative capabilities of ChatGPT, seamlessly integrating it with the robust features of Power BI. Discover how artificial intelligence can revolutionize your data workflows, enhance dashboard quality, and provide unparalleled insights. Whether you're a data enthusiast, a Power BI user, or a developer, this path offers a vantage point into the future of AI-driven data analytics.
Beginner
5 Hours

Learning

Center
21 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
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
1 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
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
Data Analysis with PandasAI

Data Analysis with PandasAI

Unlock the power of data analysis and visualization with PandasAI, and transform raw data into actionable insights that drive decision-making and growth.
Intermediate
1 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
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

Virtual

Events
41 assets
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
01:04:38 Hours
Virtual Event
Practical Power Query Solutions - Nested Structured Values (Part 2)

Practical Power Query Solutions - Nested Structured Values (Part 2)

Explore structured columns containing Lists, Records or Tables
01:00:37 Hours
Virtual Event
No-Code Visualisation & Story Telling w/ InfoRiver Charts & InfoRiver Matrix

No-Code Visualisation & Story Telling w/ InfoRiver Charts & InfoRiver Matrix

Why No-Code and Standardized Visualizations are the Future in Data Analytics and Visualizations
00:40:19 Hours
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
00:40:21 Hours
Virtual Event
Create A Dimension Table In A Text File - Intro To Problem Of The Week #2 (Power Query)

Create A Dimension Table In A Text File - Intro To Problem Of The Week #2 (Power Query)

Problem of the Week gives you real-world DAX and Power Query scenarios that will challenge your analytical skills.
00:18:05 Hours
Virtual Event
Getting Started w/ Deployment Pipelines in Power BI

Getting Started w/ Deployment Pipelines in Power BI

Learn the steps that an Enterprise BI team can take to implement application lifecycle management (ALM) in their Power BI environment
00:42:54 Hours
Virtual Event
How To Review, Optimize & Document Your (live connection) Reports w/ Power BI Sidekick

How To Review, Optimize & Document Your (live connection) Reports w/ Power BI Sidekick

Find out how Sidekick can help to review, optimize & cleanup your dataset and reports
00:54:51 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
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
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
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.
Challenge
Environmental Data Reporting

Environmental Data Reporting

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded
Challenge
Hotels Revenue Management

Hotels Revenue Management

Take on the challenge of creating an analysis report on hotels revenue management data.
Challenge
Health & Substance Abuse Report Analysis

Health & Substance Abuse Report Analysis

Challenge your data skills in creating an analysis report on substance
Challenge
Optical Data

Optical Data

Provide a business solution by creating an intelligence tool to use by large opticians
Challenge
Sales and Production Analysis

Sales and Production Analysis

Implement your analytical skills in creating a report of the entire business operation from production to forecasting.
Guides
9 assets
Resource
Common Methods to Conjure Tables in Power Query/ M

Common Methods to Conjure Tables in Power Query/ M

A the comprehensive reference guide that presents a variety of techniques and functions for creating and manipulating tables 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
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
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.
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
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
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.