Enterprise DNA Skills

Data Transformation

Convert raw data into a more usable format, such as aggregating or restructuring data, standardizing data, or merging data from multiple sources.

Start Learning for Free
Data Transformation Cover

New to Data Transformation?

Start here.
Handling Big Data with Pandas, Polars, and PySpark Cover

Paid Course

Handling Big Data with Pandas, Polars, and PySpark

PySpark made easy! Learn Pandas and Polars to navigate any dataset, uncover valuable insights, and become a data analysis powerhouse.

beginner
beginner
1 Hours
Learn More

Learning

Paths
10 assets
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
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
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
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
Path
Querying & SQL Fundamentals

Querying & SQL Fundamentals

Gain a thorough understanding of SQL fundamentals for seamless data manipulation and querying, setting the foundation for advanced database management.
Intermediate
6 Hours
Path
Power BI Data Analyst

Power BI Data Analyst

Master the skills needed to ace the PL-300 certification exam, blending foundational Power BI knowledge with advanced DAX techniques.
Beginner
19 Hours
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
Build No-Code Applications with Power Apps

Build No-Code Applications with Power Apps

An in-depth path for mastering Power Apps for efficient task automation and engaging user interfaces.
Intermediate
14 Hours

Learning

Center
32 assets
Course
Handling Big Data with Pandas, Polars, and PySpark

Handling Big Data with Pandas, Polars, and PySpark

PySpark made easy! Learn Pandas and Polars to navigate any dataset, uncover valuable insights, and become a data analysis powerhouse.
Beginner
1 Hours
Course
Excel to Python for Data Analysis

Excel to Python for Data Analysis

Transform your data approach with Python expertise! Transition from Excel and open the door to limitless possibilities for your projects, seamlessly moving from cells to scripts.
Beginner
1 Hours
Course
Accessing Data via APIs in Power BI

Accessing Data via APIs in Power BI

Unlock the full potential of Power BI by mastering API integration to access a broader range of data. Enhance your analytics with our focused training!
Intermediate
2 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
9 Hours
Course
Integration, Analytics, and Governance for MS Fabric

Integration, Analytics, and Governance for MS Fabric

Advance your data strategy with Microsoft Fabric and Azure. Discover how to optimize workspaces, develop effective pipelines, and manage data flows for enhanced security and governance.
Intermediate
6 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
5 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
Introduction to Deep Learning with Artificial Neural Networks

Introduction to Deep Learning with Artificial Neural Networks

Transform your proficiency with our exclusive neural network course! Uncover the intricacies of deep learning and position yourself as a pioneer in the realm of AI evolution!
Intermediate
1 Hours

Virtual

Events
8 assets
Virtual Event
How good is OpenAI's o1 models at DAX and Power BI?

How good is OpenAI's o1 models at DAX and Power BI?

Examine the effectiveness of OpenAI's o1 models in working with DAX (Data Analysis Expressions) and Power BI. Let's see how well these AI models can assist in writing DAX formulas and performing data analysis within Power BI.
Beginner
00:26:29 Hours
Virtual Event
How To Review, Optimize & Document Your (live connection) Reports w/ Power BI Sidekick

How To Review, Optimize & Document Your (live connection) Reports w/ Power BI Sidekick

Find out how Sidekick can help to review, optimize & cleanup your dataset and reports
00:54:51 Hours
Virtual Event
DAX Counterculture: Alternative Prospectives On DAX

DAX Counterculture: Alternative Prospectives On DAX

Know the techniques in creating indexes and how to loop efficiently using DAX
00:42:41 Hours
Virtual Event
DAX Is Easy, CALCULATE Makes It Hard

DAX Is Easy, CALCULATE Makes It Hard

Understand the overview of the new DAX functions – OFFSET, INDEX, WINDOW, EVALUATEANDLOG, TOJSON and TOCSV
00:47:18 Hours
Virtual Event
Live Q&A with Sam on Wednesday

Live Q&A with Sam on Wednesday

A real-time Q&A segment, and live demonstrations based on participant queries.
Beginner
01:21:25 Hours
Virtual Event
Emailing Data From Power BI Using Power Automate

Emailing Data From Power BI Using Power Automate

Know how to get DAX Query data from Power BI Desktop without having to write it yourself
00:44:35 Hours
Virtual Event
Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI

Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI

Learn how to use other data sources to filter and/or colorize individual objects of a 3D model in Power BI
01:03:51 Hours
Virtual Event
Extract Data From PDF’s

Extract Data From PDF’s

Use PDF conversion tools to disassemble and assemble tables within PDF documents
00:31:29 Hours

Project

Center
15 assets
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
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
Formula 1 Analysis

Formula 1 Analysis

Deep dive into the world of F1 and create an analysis of the drivers' stats
Challenge
Optical Data

Optical Data

Provide a business solution by creating an intelligence tool to use by large opticians
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
Jira IT Service Desk Analysis

Jira IT Service Desk Analysis

Produce insights for management level that can highlight any issues and prepare them for the audit
Challenge
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
Challenge
OEE Manufacturing Report

OEE Manufacturing Report

Work on one of the most significant measures for manufacturing productivity - OEE
Guides
22 assets
Resource
Beginners Guide to Power BI

Beginners Guide to Power BI

Master Power BI with our comprehensive guide! From basic setup to advanced DAX techniques, streamline your data processes and improve decision-making.
Resource
Excel to Python for Data Analysis

Excel to Python for Data Analysis

Leverage Python's powerful libraries for advanced data manipulation and analysis!
Resource
Fundamentals In Power Query And M - a detailed guide

Fundamentals In Power Query And M - a detailed guide

This detailed guide by Enterprise DNA provides a comprehensive overview of the core concepts and functionalities of Power Query and the M language. The guide covers 21 key topics, starting with an introduction to Power Query and its integration with Power BI and Excel.
Resource
Advanced Data Analysis (ADA) with ChatGPT

Advanced Data Analysis (ADA) with ChatGPT

Learn to harness ADA's powerful analytics to generate, manipulate, and visualize data effectively, making your data tasks more efficient and insightful!
Resource
Beginners Guide To Getting Started With Python For Data Analysis

Beginners Guide To Getting Started With Python For Data Analysis

This guide introduces beginners to Python for data analysis, covering essential steps from installation to performing exploratory data analysis and writing custom functions.
Resource
Python Beyond Excel - a comprehensive guide

Python Beyond Excel - a comprehensive guide

This comprehensive guide is designed to help data professionals transition smoothly from Excel to Python, unlocking new possibilities in data analysis, automation, and visualization.
Resource
Practical Guide to SQL Queries

Practical Guide to SQL Queries

Master the art of creating and optimizing SQL queries to enhance your data analysis capabilities.
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!