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.
Foundations of Data Analytics Cover

Paid Course

Foundations of Data Analytics

Dive deep into Data Analytics! Gain a profound understanding of the practicality and significance of data-driven insights in today's decision-making landscape

beginner
beginner
2 Hours
Learn More chevron_right

Learning

Paths
21 assets
Path
Geospatial Insights in Power BI

Geospatial Insights in Power BI

This Learning Path delves into advanced data visualization techniques using Power BI, emphasizing environmental data storytelling, map integrations, and flight data representation. Participants will learn to transform static reports into interactive dashboards, ensuring accessibility and effective communication for diverse audiences.
Intermediate
7 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 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 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
DAX for Power BI Analysis

DAX for Power BI Analysis

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. 
Intermediate
20 Hours
Path
Data Science w/Python & ChatGPT

Data Science w/Python & ChatGPT

Embark on a journey where traditional data science meets advanced AI in our "Data Science w/Python & ChatGPT " learning path. This curriculum offers a blend of foundational Python-driven data science techniques, coupled with the power of ChatGPT to revolutionize data analysis workflows. From mastering data wrangling to leveraging ChatGPT for enhanced coding support, this path promises a transformative learning experience for data analysts.
Beginner
7 Hours
Path
Enterprise-Level Reporting with Power BI

Enterprise-Level Reporting with Power BI

This Learning Path delves into the transformative potential of Power BI, emphasizing strategic deployment, planning, and governance. It offers actionable insights to foster a sustainable data culture, leveraging Power BI's comprehensive capabilities
Intermediate
10 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

Learning

Center
14 assets
Course
Foundations of Data Analytics

Foundations of Data Analytics

Dive deep into Data Analytics! Gain a profound understanding of the practicality and significance of data-driven insights in today's decision-making landscape
Beginner
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
6 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
4 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
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
Data Science Overview with Python

Data Science Overview with Python

Dive into data with Python! Transform raw data into actionable insights, mastering data preparation, wrangling, and modeling. Start your data science journey today.
Beginner
3 Hours
Course
Beginners Guide to Power BI

Beginners Guide to Power BI

Kickstart your journey with our specialized training! Turn raw data into stunning visuals and master Power BI essentials through interactive lessons. Begin your path to data expertise!
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

Virtual

Events
26 assets
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
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
Data Model Development Best Practices In Power BI

Data Model Development Best Practices In Power BI

We'll be reviewing a number of techniques specifically around reporting dashboards in Power BI.
01:07:07 Hours
Virtual Event
Challenge Submission Reviews - Learn From The Best

Challenge Submission Reviews - Learn From The Best

Review the best reports we've seen from historic Enterprise DNA Challenges
01:19:43 Hours
Virtual Event
My Greatest Hits Of Power Query Compilation

My Greatest Hits Of Power Query Compilation

My Greatest Hits Of Power Query Compilation
01:01:13 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
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
Connecting The Military Community w/ Data Jobs: A Power BI & Power Automate Walkthrough

Connecting The Military Community w/ Data Jobs: A Power BI & Power Automate Walkthrough

Discover specific cleaning and modeling techniques to ensure data accuracy and reliability
00:46:14 Hours

Project

Center
7 assets
Challenge
Hotels Revenue Management

Hotels Revenue Management

Take on the challenge of creating an analysis report on hotels revenue management data.
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
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
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
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
Guides
2 assets
Resource
Introducing Group By or Table Group in Power Query/M

Introducing Group By or Table Group in Power Query/M

This is focused on one of the key functionalities of Power Query M – the 'Group By' or 'Table Group' operation.
Resource
Dynamic start and end dates for date tables in Power Query

Dynamic start and end dates for date tables in Power Query

Creating dynamic start and end dates in Power Query allows for versatile date tables that automatically adjust according to the data's time frame, enhancing data analysis efficiency and accuracy.