Enterprise DNA Skills

Advanced Analytics

Use complex and sophisticated analytical techniques to uncover deep insights and make highly accurate predictions or recommendations.

Start Learning for Free
Advanced Analytics Cover

New to Advanced Analytics?

Start here.
DAX Formula Patterns Cover

Paid Course

DAX Formula Patterns

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face everyday

intermediate
intermediate
4 Hours
Learn More chevron_right

Learning

Paths
26 assets
Path
Advanced Visualizations and Dashboarding with Power BI

Advanced Visualizations and Dashboarding with Power BI

This Learning path delves into transformative data visualization techniques. Elevate your presentations, ensuring clarity and swift comprehension for your audience.
Intermediate
8 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
SQL Fundamentals: Getting Started with Database Querying

SQL Fundamentals: Getting Started with Database Querying

This learning path provides a thorough understanding of SQL, emphasizing key commands for data manipulation and querying. 
Intermediate
6 Hours
Path
ChatGPT for Advanced Excel Data Analysis

ChatGPT for Advanced Excel Data Analysis

Welcome to a transformative learning experience that fuses the power of Excel with the capabilities of ChatGPT. Our "ChatGPT for Advanced Excel Data Analysis " path introduces a paradigm shift in data analysis. By integrating the AI-driven insights of ChatGPT into Excel's robust framework, this path promises efficiency, automation, and a heightened proficiency in tackling complex data tasks.
Beginner
4 Hours
Path
Power BI for Data Science: From Data to Insights

Power BI for Data Science: From Data to Insights

This Learning Path delves into data analysis and visualization using both R and Python, covering data cleaning, data frames, and the use of packages like dplyr, tidyverse, skim R, and seaborn. It offers hands-on examples, such as creating various plots, performing group-based operations, and utilizing descriptive statistics for effective data interpretation.
Intermediate
18 Hours
Path
Applied Statistics for Data Analysis

Applied Statistics for Data Analysis

This Learning Path in statistical analysis and inference equips learners with practical skills to conduct tests, estimate sample sizes, and understand test assumptions. 
Intermediate
7 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
10 Hours
Path
Advanced DAX for Power BI

Advanced DAX for Power BI

This Learning Path provides a deep dive into Power BI and DAX, focusing on data analysis techniques and visualization. It equips learners with skills to craft dynamic visualizations.
Intermediate
5 Hours

Learning

Center
26 assets
Course
DAX Formula Patterns

DAX Formula Patterns

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face everyday
Intermediate
4 Hours
Course
Optimizing DAX

Optimizing DAX

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI
Advanced
5 Hours
Course
Artificial Neural Networks 101: Intro to Deep Learning

Artificial Neural Networks 101: Intro to Deep Learning

Unraveling the Mystique: A Beginner's Dive into Neutral Networks.
Intermediate
1 Hours
Course
Mastering DAX Calculations

Mastering DAX Calculations

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI
Intermediate
12 Hours
Course
DP-500 Prep: Data Governance with Synapse & Power BI

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

The second part of the preparation course for the Microsoft's DP-500 Exam Certification
Advanced
11 Hours
Course
Navigating Financial Data with Python

Navigating Financial Data with Python

Elevate your financial analytics skills with Python for Finance, exploring cutting-edge techniques for data retrieval, time series analysis, and predictive modeling.
Intermediate
1 Hours
Course
Excel to Python for Data Analysis

Excel to Python for Data Analysis

Join us on this journey from cells to scripts, and unlock a new realm of possibilities for your data projects.
Beginner
1 Hours
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

Virtual

Events
61 assets
Podcast
Embracing the AI Revolution: Navigating Disruption and Opportunities in Data Analysis

Embracing the AI Revolution: Navigating Disruption and Opportunities in Data Analysis

Join Sam in this thought-provoking episode of ‘The Analytic Mind’, as he delves into the heart of the AI revolution and its transformative impact on data analysis.
Podcast
AI Inflection The Future of Data: Productivity and Opportunity

AI Inflection The Future of Data: Productivity and Opportunity

In this episode of ‘The Analytic Mind’ podcast, join us as we delve deep into the transformative power of AI in the data analytics space and its broader implications across various industries.
Virtual Event
The Excel Features & Skills You Need to Automate a Reporting Procedure

The Excel Features & Skills You Need to Automate a Reporting Procedure

In this session, Celia will reveal her top list of Excel skills and features needed to automate the most common Excel reporting procedures.
00:54:08 Hours
Virtual Event
A Visual Revolution Building a Scorecard Instantly w/ InfoRiver

A Visual Revolution Building a Scorecard Instantly w/ InfoRiver

On-demand replays and resources from all Enterprise DNA Webinar Series events
00:55:17 Hours
Virtual Event
Excel Features that are HOT but Dangerous!

Excel Features that are HOT but Dangerous!

Let's go beyond the thrills and glamour of Excel tricks. This session explores the dark side--the sexy features in Excel that can burn your fingers if you're not careful.
00:56:39 Hours
Virtual Event
Forecasting Analysis in Python

Forecasting Analysis in Python

Master complex data model techniques especially when running forecasting analysis
00:49:56 Hours
Virtual Event
Power BI and Azure Databricks – A Magical Union

Power BI and Azure Databricks – A Magical Union

Power BI and Azure Databricks – A Magical Union with Pragati Jain
01:01:56 Hours
Virtual Event
Calculation Groups Beyond Time Intelligence

Calculation Groups Beyond Time Intelligence

Dynamic data labels at the end of the line
00:46:11 Hours

Project

Center
13 assets
Challenge
Supplier Insights

Supplier Insights

Enhance your development skills by creating a supplier insights report
Challenge
Transport and Shipping Data

Transport and Shipping Data

Challenge your data skills by creating a report on transport and shipping data 
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
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
Challenge
Logistics/Transportation - Profitability Business Routes

Logistics/Transportation - Profitability Business Routes

Create a report which shows most profitable/unprofitable business routes
Challenge
Formula 1 Analysis

Formula 1 Analysis

Deep dive into the world of F1 and create an analysis of the drivers' stats
Challenge
Health & Substance Abuse Report Analysis

Health & Substance Abuse Report Analysis

Challenge your data skills in creating an analysis report on substance
Challenge
Acing Documentation

Acing Documentation

Use the data documenter tool to create an effective report template 
Guides
3 assets
Resource
Overview of Advanced Data Analysis (ADA)

Overview of Advanced Data Analysis (ADA)

An in-depth guide to understanding the methodologies and applications of OpenAI's Advanced Data Analysis (ADA).
Resource
Exploring Expression Functions in Power Query/ M

Exploring Expression Functions in Power Query/ M

Resource
Excel Formulas Cheat Sheet: Advanced Guide

Excel Formulas Cheat Sheet: Advanced Guide

This Excel formulas cheat sheet covers advanced forecasting formulas, statistical analysis, data manipulation functions, error handling, and more.