Enterprise DNA Skills

Data Analysis

Apply statistical and analytical techniques to raw data to uncover insights and make informed decisions.

Start Learning for Free
Data Analysis Cover

New to Data Analysis?

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
3 Hours
Learn More

Learning

Paths
20 assets
Path
Mastering M Code for Power Query

Mastering M Code for Power Query

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.
Intermediate
10 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
16 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
47 Hours
Path
Power BI Mastery

Power BI Mastery

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
31 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
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
7 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
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
6 Hours

Learning

Center
33 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
3 Hours
Course
R for Power BI Users II

R for Power BI Users II

Enhance your Power BI reports and analysis with R's visualization, text analysis and statistical modeling capabilities.
Intermediate
2 Hours
Course
Tabular Editor 3: Beginner To Advanced

Tabular Editor 3: Beginner To Advanced

Master the most powerful tool for data modeling and DAX calculations in Power BI and Analysis Services
Advanced
3 Hours
Course
Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.
Beginner
1 Hours
Course
Report Development Best Practices Checklist

Report Development Best Practices Checklist

Review some of the best practices to refine your Power BI development skills
Beginner
3 Hours
Course
Beginners Guide to Power BI

Beginners Guide to Power BI

Build a solid foundation in using Power BI.
Beginner
2 Hours
Course
Intermediate Excel

Intermediate Excel

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.
Intermediate
4 Hours
Course
Python I for Power BI Users

Python I for Power BI Users

Dramatically enhance Power BI's capabilities by incorporating Python's flexible and powerful data wrangling, data analysis and data visualization functionality
Beginner
4 Hours

Virtual

Events
93 assets
Podcast
Unique Data Insights In the Healthcare Space

Unique Data Insights In the Healthcare Space

Join Sam McKay and Anuj Kapoor as they talk about how data analytics is helping the healthcare industry save lives. Anuj also discusses the importance of establishing a problem statement and having quality data to work with
Podcast
Imagine The Possibilities Of Data Products With Power BI

Imagine The Possibilities Of Data Products With Power BI

Listen as Jarrett Moore talks to Sam McKay on how he scaled a data analytics system for his own company and built a separate data product on top of it
Podcast
How Data Analytics Make Companies More Resilient

How Data Analytics Make Companies More Resilient

Listen as Sam McKay talks to Shiv Misra on why companies need to have an appetite for change and embrace data analytics
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
Communicating Research with R Notebooks

Communicating Research with R Notebooks

Creating basic tables and figures with R to check assumptions and communicate findings
00:38:36 Hours
Virtual Event
Introduction to Usability Testing

Introduction to Usability Testing

Learn how usability testing can reveal crucial usability information not revealed by A/B testing, focus groups, or surveys
00:46:28 Hours
Virtual Event
Geospatial Analytics

Geospatial Analytics

Introducing Power BI Geospatial Analysis for building compelling and dynamic maps in reports.
01:37:27 Hours
Virtual Event
Cross Selling Analytics

Cross Selling Analytics

Learn what sells well together and analyze product sales for upsell opportunities and
00:40:48 Hours

Project

Center
27 assets
Challenge
Financial Report Showcase

Financial Report Showcase

Show off your impressive financial report! We are confident that your financial report is a testament to your skills and expertise. We would love to see how you've structured it and how you've made it visually appealing.
Challenge
Emergency Services Analytics

Emergency Services Analytics

Analyze the data of a medical emergency response service and discover opportunities for improvement on their process
Challenge
Covid 19 Reporting

Covid 19 Reporting

An excellent opportunity for you to create a one-page data report for Covid-19 analysis
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
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
Environmental Data Reporting

Environmental Data Reporting

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded
Challenge
User Experience Focus - Design Creative Navigations

User Experience Focus - Design Creative Navigations

Create a navigation experience that showcases your brand and keeps users coming back for more by prioritizing the user experience and considering the needs and preferences of your target audience.
Challenge
Sport - Football/Soccer Players Summer Transfers Season 2022-23

Sport - Football/Soccer Players Summer Transfers Season 2022-23

Develop an analysis report about the Football/Soccer Players Summer Transfers Season 2022-23
Guides
4 assets
Resource
Numpy Cheat Sheet

Numpy Cheat Sheet

A NumPy cheat sheet can be an excellent resource to help guide your journey into this Python library. A comprehensive cheat sheet will help you navigate NumPy’s features and quickly become proficient in using it for various tasks!
Resource
Microsoft DP-500 Certification Study Guide

Microsoft DP-500 Certification Study Guide

The Microsoft DP-500 exam, formally titled “Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI,” is designed to test your knowledge and skills in using the Azure environment and Power BI for advanced data analytics tasks.
Resource
Excel Formulas Cheat Sheet: Intermediate Guide

Excel Formulas Cheat Sheet: Intermediate Guide

This Microsoft Excel intermediate cheat sheet covers a wide range of topics that will level up your skills in numerical analysis, text processing, and complex date and time logic
Resource
Excel Cheat Sheet: A Beginners Guide With Time-Saving Tips

Excel Cheat Sheet: A Beginners Guide With Time-Saving Tips

This guide is here to simplify your journey with Excel, offering you the key tools, shortcuts, and techniques at your fingertips, so make sure to save it for future reference.