Data Transformation

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

Master JSON integration, Microsoft Analysis Services Tabular API, and UI development challenges for open-source tool development and optimize your data workflow.

Gain comprehensive knowledge in key features including data transformation, modeling, DAX calculations, and visualization. Build analytical solutions surpassing traditional reporting!

Gain expertise in data analysis and modeling, with a focus on Filter and Row Contexts empowering precise and insightful computations.

Develop expert-level skills in data cleaning, transformation, and modeling, mastering both the Power Query UI and M code for comprehensive data manipulation.

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

Gain hands-on skills essential for conquering the DP-500 exam and advancing in your data career!

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!

Master predictive analytics in Power BI: Learn preprocessing to advanced AutoML. Unlock powerful machine learning models and transform your data.

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

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

Learn how to clean, optimize and model data tables to develop effective, insightful and actionable Power BI reports

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.

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

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.

How to create your own custom quick measures - create once, and apply them in every future report you do

Learn how to use Python to accomplish different outputs inside Power BI.

Learn how to use other data sources to filter and/or colorize individual objects of a 3D model in Power BI

Create basic pipelines for data cleaning, visualization and modeling in R

Use PDF conversion tools to disassemble and assemble tables within PDF documents

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

One of the break-out session in our Reporting & Data Visualization Summit, showcasing a variety of beginner to advanced Power BI tips and techniques.

Using visual layering and transparency masks to improve data storytelling Advanced tricks for conditional formatting icons

In this challenge, participants are encouraged to dive deep, explore, and come up with unique insights and visualizations.

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.

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

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

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

In this challenge, participants are encouraged to uncover distinctive shopper segments and present innovative insights.

Produce insights for management level that can highlight any issues and prepare them for the audit

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

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

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 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.

Unlock the ‘Each’ expression in Power Query/M

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

 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. 

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!