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.
Applied Problem Solving with Power Query/M Cover

Paid Course

Applied Problem Solving with Power Query/M

Deepen your Power Query/M understanding through hands-on practice. Master practical applications and excel in data transformation!

advanced
advanced
6 Hours
Learn More

Learning

Paths
10 assets
Path
Build No-Code Applications with Power Apps

Build No-Code Applications with Power Apps

An in-depth path for mastering Power Apps for efficient task automation and engaging user interfaces.
Intermediate
16 Hours
Path
M Code for Power Query

M Code for Power Query

Master the art of creating visually appealing and insightful dashboards and reports using Power BI, leveraging its wide range of visualization options and features.
Intermediate
11 Hours
Path
Python for Data Analysis

Python for Data Analysis

Take your data analysis to the next level with Python. Seamlessly integrate Python and AI for efficient workflows and game-changing insights.
Beginner
12 Hours
Path
No-Code Automation with Power Automate

No-Code Automation with Power Automate

Explore into built-in connectors, mastering basic flows to advanced error handling for seamless workflow efficiency.
Advanced
9 Hours
Path
Microsoft Fabric Fundamentals

Microsoft Fabric Fundamentals

Elevate your expertise in data management, analytics, and system integration. Start your transformative journey with our comprehensive courses!
Intermediate
11 Hours
Path
Power BI Data Analyst

Power BI Data Analyst

Master the skills needed to ace the PL-300 certification exam, blending foundational Power BI knowledge with advanced DAX techniques.
Beginner
19 Hours
Path
DAX for Power BI Analysis

DAX for Power BI Analysis

Master the most in-depth and rigorous path on Power BI, gaining expert-level skills across all key pillars of analysis.
Intermediate
24 Hours
Path
Power BI & Python for Advanced Analytics

Power BI & Python for Advanced Analytics

Dive deep into machine learning with Python, mastering predictive analytics and advanced data manipulations to excel in complex analytical tasks.
Advanced
7 Hours

Learning

Center
32 assets
Course
Applied Problem Solving with Power Query/M

Applied Problem Solving with Power Query/M

Deepen your Power Query/M understanding through hands-on practice. Master practical applications and excel in data transformation!
Advanced
6 Hours
Course
Fundamentals In Power Query And M

Fundamentals In Power Query And M

Fast-track your data expertise with Power Query and M. Discover how to effortlessly merge and mold data from various sources into insightful Power BI reports.
Beginner
3 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
5 Hours
Course
Power Query/M - Nested Structures

Power Query/M - Nested Structures

Master structured values in the M language and unlock new ways to interact with data. Dive deep and elevate your data manipulation skills!
Intermediate
3 Hours
Course
Mastering Data Manipulation with Pandas

Mastering Data Manipulation with Pandas

Dive into data mastery with our comprehensive Pandas course. Learn to manipulate and analyze data effectively, unlocking powerful insights that drive success.
Intermediate
1 Hours
Course
Practical Guide to SQL Queries

Practical Guide to SQL Queries

Master the fundamentals of SQL and take your data analysis skills to the next level. Learn how to efficiently query and manipulate data, transforming raw information into valuable insights through hands-on exercises and real-world scenarios.
Beginner
1 Hours
Course
Beginners Guide to Google Colab

Beginners Guide to Google Colab

Unlock the full potential of Google Colab for your data science and machine learning projects. Learn how to write, run, and share Python code effortlessly in this cloud-based environment, mastering the tools and features that make Colab a go-to resource for data professionals.
Beginner
1 Hours
Course
ChatGPT for Power BI Users

ChatGPT for Power BI Users

Revolutionize your Power BI dashboards with ChatGPT! Learn simple techniques to infuse AI into your data visuals, making them more interactive and insightful.
Beginner
2 Hours

Virtual

Events
13 assets
Podcast
The Potential of Vibe Coding, MCP, and Tool Use With AI

The Potential of Vibe Coding, MCP, and Tool Use With AI

Vibe coding, Model Context Protocol (MCP), and AI-powered tool use represent a transformative shift in how developers interact with technology. These innovations bridge the gap between learning and implementation, enhance productivity, and redefine how we work with AI—making development more intuitive, accessible, and dynamic.
Podcast
Real World MCP Applications & AI Learning

Real World MCP Applications & AI Learning

Model Context Protocol (MCP) is transforming how AI tools operate in real-world settings. By improving the way context is carried and recalled, MCP unlocks smarter automation and learning. As AI systems evolve, MCP will play a key role in how we bridge learning, memory, and adaptive functionality across tools and workflows.
Podcast
How AI Is Revolutionizing Data Analysis and App Development

How AI Is Revolutionizing Data Analysis and App Development

Discover how AI Agents are accelerating software creation, reducing the need for traditional coding skills, and enabling seamless integration of data from multiple sources.
Podcast
Is Copilot Finally on Track & New AI Innovations Coming Out Soon

Is Copilot Finally on Track & New AI Innovations Coming Out Soon

Is Copilot finally finding its stride? With new AI innovations on the horizon, the way we work might be about to change—again. Are we prepared for what’s coming, or just getting comfortable with the current wave? The future isn’t slowing down.
Virtual Event
Live Q&A with Sam on Wednesday

Live Q&A with Sam on Wednesday

A real-time Q&A segment, and live demonstrations based on participant queries.
Beginner
01:21:25 Hours
Virtual Event
Building Data Agents Part 4

Building Data Agents Part 4

Master the steps to cleaner SQL, better data flow, and more consistent outputs.
Beginner
01:16:35 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
DAX Counterculture: Alternative Prospectives On DAX

DAX Counterculture: Alternative Prospectives On DAX

Know the techniques in creating indexes and how to loop efficiently using DAX
00:42:41 Hours

Project

Center
18 assets
Challenge
Optical Data

Optical Data

Provide a business solution by creating an intelligence tool to use by large opticians
Challenge
Currency Conversion and More

Currency Conversion and More

Challenge your data skills by producing a report that gives the user the ability to select a currency and see the associated sales and cost
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
Transport and Shipping Data

Transport and Shipping Data

Challenge your data skills by creating a report on transport and shipping data 
Challenge
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
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.
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
Mobile Phone Sales Dataset

Mobile Phone Sales Dataset

Explore 2024 mobile phone sales data to uncover product trends, customer insights, and regional performance to support smarter business decisions.
Guides
27 assets
Resource
Power Query And M Basics

Power Query And M Basics

Learn to effectively transform and prepare data in Power BI, mastering both basic and advanced techniques for a comprehensive understanding of data operations!
Resource
Big Data with Pandas, Polars & PySpark

Big Data with Pandas, Polars & PySpark

Learn to handle vast datasets, perform complex data transformations, and optimize your big data analytics workflow efficiently!
Resource
Practical Guide to SQL Queries

Practical Guide to SQL Queries

Master the art of creating and optimizing SQL queries to enhance your data analysis capabilities.
Resource
Python Beyond Excel

Python Beyond Excel

Move from Excel to Python to utilize advanced features in Google Colab and powerful Python libraries for deeper insights and more dynamic data handling!
Resource
Power BI Super Users Workshop

Power BI Super Users Workshop

Learn advanced DAX, data modeling, and interactive dashboards, providing you with the skills to build sophisticated reports and analyses!
Resource
Excel, Power BI, Python and AI in One Powerful Flow

Excel, Power BI, Python and AI in One Powerful Flow

Combine Excel, Power BI, Python, and AI to automate your data tasks, speed up reporting, and unlock smarter, seamless insights, all in one powerful workflow.
Resource
R Stats and Graphics - Detailed Guide

R Stats and Graphics - Detailed Guide

An in-depth exploration of how R can be integrated with Power BI to enhance data analytics and visualization capabilities. Covering essential topics such as R setup, basic scripting, custom visualizations with ggplot2, and advanced statistical analyses, enabling users to leverage R's powerful features within Power BI for more insightful and actionable reporting.
Resource
Data Model and Transformation

Data Model and Transformation

Learn to master data transformations, efficient modeling techniques, and DAX calculations for deeper insights!