Enterprise DNA Skills

Data Modeling

Create a logical and structured representation of data, enabling organizations to better understand and manage their data assets.

Start Learning for Free
Data Modeling Cover

New to Data Modeling?

Start here.
Applied Problem Solving with Power Query/M Cover

Paid Course

Applied Problem Solving with Power Query/M

Deepen your understanding of the Power Query/M concepts through practical application

advanced
advanced
5 Hours
Learn More

Learning

Paths
14 assets
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.
Beginner
10 Hours
Path
Data Modeling in Power BI

Data Modeling in Power BI

This Learning Path offers a comprehensive journey through advanced data analysis and modeling techniques all illustrated through practical scenarios.
Intermediate
6 Hours
Path
Power BI Visualization Expert

Power BI Visualization Expert

This path is designed to help you become an expert in data visualization, data storytelling, and report design. You will learn how to create advanced custom visualizations using bespoke visualization languages.
Beginner
25 Hours
Path
PL-900 Certification

PL-900 Certification

This Learning Path enables individuals to proficiently use Power BI and other Power Platform tools. It prepares business analysts for the PL-900 exam.
Beginner
15 Hours
Path
Visual Storytelling with Power BI

Visual Storytelling with Power BI

This Learning Path offers a comprehensive journey through data visualization and analysis techniques, with a special emphasis on Power BI.
Intermediate
5 Hours
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. 
Intermediate
52 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
16 Hours
Path
DP-500 Certification

DP-500 Certification

This learning path offers a deep dive into data management and analysis, emphasizing the hands-on use of Python and Scala languages for manipulating CSV and JSON files, and the application of SQL for data querying. 
Intermediate
15 Hours

Learning

Center
10 assets
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
Data Transformation with Synapse & Power BI (DP-500 I)

Data Transformation with Synapse & Power BI (DP-500 I)

The first of the two-part preparation course for the Microsoft's DP-500 Exam Certification
Advanced
8 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
Scenario Analysis Deep Dive

Scenario Analysis Deep Dive

Learn how to predict and optimize for results in the future, by utilizing 'what if' parameters and scenario analysis techniques
Intermediate
2 Hours
Course
Financial Reporting With Power BI

Financial Reporting With Power BI

Create comprehensive financial reports in Power BI that represent key insights in a compelling and dynamic way
Advanced
4 Hours
Course
Beginners Guide to Power BI

Beginners Guide to Power BI

Build a solid foundation in using Power BI.
Beginner
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
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

Virtual

Events
21 assets
Virtual Event
From Source to Insights - End to End Presentation of Creating a Power BI Report

From Source to Insights - End to End Presentation of Creating a Power BI Report

Learn the whole process from getting data, creating a data model with a date table, measure table and calculation groups
00:54:08 Hours
Virtual Event
Effective Power BI Reporting for Analysts

Effective Power BI Reporting for Analysts

Produce amazing insights including running custom scenarios on your raw data
00:59:23 Hours
Virtual Event
9 1/2 Tips for Awesome Visualisations in Power BI

9 1/2 Tips for Awesome Visualisations in Power BI

Stop wasting your valuable time in building or deciphering confusing visualizations and increase your insight
00:43:25 Hours
Virtual Event
Power BI Accelerator – Week #2 Solution Q&A Session

Power BI Accelerator – Week #2 Solution Q&A Session

Expert walk-through of week #2 solution with Sam McKay and Brian Julius
01:00:20 Hours
Virtual Event
Advanced Data Modeling & DAX Techniques

Advanced Data Modeling & DAX Techniques

Discover advanced data modeling and DAX techniques to speed up DAX query execution
00:42:58 Hours
Virtual Event
Developing Data Models In The Real World

Developing Data Models In The Real World

Discover the foundations of Data Modelling in Power BI and Power Query
00:46:19 Hours
Virtual Event
Rapid Excel BI Model Development

Rapid Excel BI Model Development

In this session, Ken will show you how he can build a complex Excel BI model leveraging Power Query and Power Pivot very quickly. 
00:51:33 Hours
Virtual Event
Pivot Table Tips and Tricks

Pivot Table Tips and Tricks

Take a deep dive in pivot tables with Bill Jelen from MrExcel. Learn awesome pivot table techniques in both pivot cache pivot tables and data model pivot tables.
01:03:10 Hours

Project

Center
7 assets
Challenge
Executive Sales Report

Executive Sales Report

Create a summary report, a task that for many data analysts will always find its way across the desk every so often
Challenge
Hotels Revenue Management

Hotels Revenue Management

Take on the challenge of creating an analysis report on hotels revenue management data.
Challenge
Call Center Data Reporting

Call Center Data Reporting

Create a report summary of the overall services provided by a Call Centre for its management
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
OEE Manufacturing Report

OEE Manufacturing Report

Work on one of the most significant measures for manufacturing productivity - OEE
Challenge
Health & Substance Abuse Report Analysis

Health & Substance Abuse Report Analysis

Challenge your data skills in creating an analysis report on substance
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.