Data Transformation

Harness the combined power of ChatGPT and Power BI to streamline workflows, enhance dashboard quality, and unlock game-changing insights effortlessly.

Discover the secrets of SQL and DAX mastery, with practical code examples for advanced data analysis. Revolutionize your data analysis approach and achieve actionable insights.

Master the skills needed to ace the PL-300 certification exam, blending foundational Power BI knowledge with advanced DAX techniques.

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!

Explore Power BI's advanced analytics features, integrating R and Python to unlock actionable insights and elevate your data expertise to expert levels.

Dive deep into machine learning with Python, mastering predictive analytics and advanced data manipulations to excel in complex analytical tasks.

Craft interactive experiences with SharePoint and Power Apps, mastering Power Automate for efficient task automation and engaging user interfaces.

Master Power BI implementation, monitoring, and governance with our Data Strategy Expert path. Optimize Power BI Service with dataflows, datasets, and thin reports for maximum impact.

Uncover Microsoft Fabric's power! Secure OneLake data, optimize with Apache Spark, and master lakehouse vs. warehouse structures. Elevate your data game today!

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.

Dive into data mastery with our comprehensive Pandas course. Learn to manipulate and analyze data effectively, unlocking powerful insights that drive success.

Kickstart your journey to Microsoft's DP-500 Exam Certification with our comprehensive two-part preparation course. Get the edge you need to succeed!

Fast-track your data expertise with Power Query and M. Discover how to effortlessly merge and mold data from various sources into insightful Power BI reports.

Master structured values in the M language and unlock new ways to interact with data. Dive deep and elevate your data manipulation skills!

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!

Advance your analytics capabilities: Transition from basic spreadsheets to Python and explore powerful data analysis techniques with our expert-led course.

Know the techniques in creating indexes and how to loop efficiently using DAX

Using in-built standard Excel tools, we will explore how to reduce uncertainty in decision-making with sensitivity and scenario analysis

This session will cover which Python and R packages and examples can facilitate functionalities found in Power BI

Explore structured columns containing Lists, Records or Tables

Learning how to use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Enterprise DNA Analytics Summit are action packed live events showcasing a variety of beginner to advanced Power BI & Power Platform tips and techniques. 

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI

Understand the overview of the new DAX functions – OFFSET, INDEX, WINDOW, EVALUATEANDLOG, TOJSON and TOCSV

Challenge your data skills by creating a report on transport and shipping data 

Analyze the data of a large insurance company who are due to undergo an internal audit with regard to its complaint’s procedure

Take a deep dive into the world of utilisation and timesheet data

Implement your analytical skills in creating a report of the entire business operation from production to forecasting.

Work on one of the most significant measures for manufacturing productivity - OEE

Challenge your data skills in creating an analysis report on substance

Take on the challenge of creating an analysis report on hotels revenue management data.

Create a report summary of the overall services provided by a Call Centre for its management

A the comprehensive reference guide that presents a variety of techniques and functions for creating and manipulating tables in Power Query/M

In this guide, we will address a common issue when performing an Expand Column operation in Power Query. 

This resource provides comprehensive instructions on how to build and manipulate record data structures in Power Query M.

When programming in Python, having a reliable cheat sheet by your side can be a game-changer. Python may be known for its simplicity and readability, but there’s no denying that its extensive range of features and functionalities is too much to memorize!

This SQL cheat sheet gives you the most common SQL objects and commands, including data types, DML and DDL statements, aggregate functions, string and date functions, and subqueries.

A comprehensive resource that demonstrates how to seamlessly merge tables from multiple files located within a single folder.

This offers techniques to retrieve and manipulate data based on specific row indexes or key matches, enhancing the flexibility and precision of data analysis.

 This resource illustrates how users can manipulate data structures at a granular level, offering insights into how tables can be deconstructed for detailed analysis or data-cleaning purposes.