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.
Optimizing DAX Cover

Paid Course

Optimizing DAX

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI

advanced
advanced
5 Hours
Learn More

Learning

Paths
12 assets
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
Path
Mastering Visualization with Power BI

Mastering Visualization with Power BI

Gain comprehensive knowledge in key features including data transformation, modeling, DAX calculations, and visualization. Build analytical solutions surpassing traditional reporting!
Intermediate
10 Hours
Path
Statistics & R for Data Analysis

Statistics & R for Data Analysis

Enhance your skills in statistical analysis techniques, including hypothesis testing, regression analysis, and data visualization
Intermediate
11 Hours
Path
Data Analytics Generalist

Data Analytics Generalist

Gain a versatile skill set covering a wide range of data analysis techniques and tools, preparing you for diverse roles in the dynamic field of data analytics!
Beginner
17 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
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
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
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

Learning

Center
61 assets
Course
Optimizing DAX

Optimizing DAX

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI
Advanced
5 Hours
Course
Advanced Visualization and Text Analysis with R in Power BI

Advanced Visualization and Text Analysis with R in Power BI

Enhance your Power BI reports and analysis with R's visualization, text analysis and statistical modeling capabilities.
Intermediate
3 Hours
Course
Report Development Best Practices Checklist

Report Development Best Practices Checklist

Refine your Power BI development skills with expert-reviewed best practices. Elevate your expertise and create impactful insights!
Beginner
4 Hours
Course
Advanced Python for Power BI in Data Cleaning and NLP

Advanced Python for Power BI in Data Cleaning and NLP

Unlock the power of Python for data cleaning and Natural Language Processing. Master essential functions, algorithms, and programming methods to level up your skills!
Intermediate
5 Hours
Course
Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs

Boost your Excel skills with ChatGPT integration! Learn how to use macros and APIs to seamlessly blend ChatGPT into Excel, enhancing both your productivity and learning experience.
Beginner
1 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
3 Hours
Course
Foundations of Microsoft Fabric

Foundations of Microsoft Fabric

Discover the power of Microsoft Fabric and shape your future in data. Learn essential data engineering and analytics, and craft cutting-edge solutions with OneLake and Delta Lake.
Intermediate
1 Hours
Course
SQL For Power BI Users

SQL For Power BI Users

Master SQL fluency from scratch and unlock endless data querying possibilities. Level up your skills and dominate the world of data analysis!
Beginner
3 Hours

Virtual

Events
50 assets
Podcast
AI Is Moving Fast, But It Still Needs You!

AI Is Moving Fast, But It Still Needs You!

AI is fast. But it still needs you. This episode unpacks why orchestration matters more than ever.
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
Unique Data Insights In the Healthcare Space

Unique Data Insights In the Healthcare Space

Discover how data analytics saves lives in healthcare with Sam McKay and Anuj Kapoor. Learn the importance of clear problem statements and quality data.
Podcast
What Could Self Service BI Look Like?

What Could Self Service BI Look Like?

Self-service BI had potential, but never truly worked. This podcast episode explores why and what it could look like today with smarter tools.
Podcast
Gemini, ChatGPT Upgrades, AI Tsunami Reshaping Creativity & Work with Brian Julius

Gemini, ChatGPT Upgrades, AI Tsunami Reshaping Creativity & Work with Brian Julius

From Google’s Gemini 2.5 to OpenAI’s ChatGPT 4.0, we explore how the latest advancements in artificial intelligence are revolutionizing creativity, reshaping the future of work, and challenging our perceptions of trust. What does this mean for artists, professionals, and society at large? Tune in as this conversation will give you insight into the fast-evolving AI landscape.
Podcast
Embracing the AI Revolution: Navigating Disruption and Opportunities in Data Analysis

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

Explore the AI revolution's impact on data analysis with Sam in a thought-provoking episode of ‘The Analytic Mind’. Learn about its transformative effects.
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 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.

Project

Center
35 assets
Challenge
Washington Crimes Dataset

Washington Crimes Dataset

Explore D.C.'s crime trends to uncover hotspots, identify patterns, and turn data into actionable insights for safer communities.
Challenge
Marketing Analytics - Measuring ROI

Marketing Analytics - Measuring ROI

Analyze data from marketing campaigns and initiatives, using visualization tools and statistical analysis techniques to identify trends and patterns, and use these insights to inform marketing strategy and decision-making.
Challenge
Fitness Membership Analytics

Fitness Membership Analytics

Analyze MyGym’s member data to uncover trends, boost retention, and optimize revenue. Your insights will drive smarter pricing, better service offerings, and improved facility planning.
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
Emergency Services Analytics

Emergency Services Analytics

Analyze the data of a medical emergency response service and discover opportunities for improvement on their process
Challenge
Twitter Threads Analysis

Twitter Threads Analysis

Jump into this twitter related dataset and showcase some interesting insights based on the text of the tweet and the stock reference or tagged within the tweet itself.
Challenge
Covid 19 Reporting

Covid 19 Reporting

An excellent opportunity for you to create a one-page data report for Covid-19 analysis
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.
Guides
65 assets
Dataset
Customer Segmentation Data

Customer Segmentation Data

This dataset provides insights into customer behavior and preferences through a loyalty program. The data includes details on customer demographics, purchase history, and feedback.
Resource
Debugging Complex DAX Formula

Debugging Complex DAX Formula

Discover how to simplify your debugging by breaking formulas apart, using variables, and testing each component.
Resource
Data Wrangling and Visualization

Data Wrangling and Visualization

Learn to create dynamic maps, integrate accurate geospatial data, and apply 3D modeling for enhanced visualization and decision-making!
Resource
Batch Processing vs Real-Time Processing

Batch Processing vs Real-Time Processing

Batch processes large data sets periodically, while real-time gives you insights on the spot. Find out which is right for you!
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
Beginners Guide to R for Data Analysis

Beginners Guide to R for Data Analysis

Learn the essentials of R programming, data manipulation, and visual analysis to uncover actionable insights from your data!
Resource
Data Mart vs Data Warehouse

Data Mart vs Data Warehouse

Discover how Data Marts target department-specific needs and Data Warehouses enable enterprise-wide insights. Download to optimize your data strategy!
Resource
ChatGPT in Excel Using Macros & APIs

ChatGPT in Excel Using Macros & APIs

Learn to automate complex functions, enhance macros, and streamline your data workflows using advanced AI capabilities!