Data Transformation

In the modern era of data, the AI-driven approach is rapidly redefining how data science operates. Our learning path, "AI-Driven Data Science: Exploring PandasAI and ChatGPT", is crafted to immerse learners into the realms of PandasAI and ChatGPT. The path focuses on harnessing the potential of these AI tools, enabling learners to analyze, visualize, and interpret data with enhanced proficiency. From the foundational principles of data analysis with PandasAI to the expansive capabilities of ChatGPT in data science, this path offers a comprehensive journey into the world of AI-powered data analytics.

This Learning Path dives into SharePoint and Power Apps, focusing on leveraging Power Automate for task automation and improved user interaction. 

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.

This path is focused on developing expert level skills in data cleaning, data transformation and data modeling. You will learn to maximize the capabilities of the Power Query UI, and also write M code.

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.

This path is designed to build the broad range of expert-level knowledge necessary to confidently pass the PL-300 Data Analyst certification exam (replacement for DA-100).

This path is designed to build the broad range of expert-level knowledge necessary to confidently pass the PL-300 Data Analyst certification exam (replacement for DA-100).

This comprehensive journey introduces you to the transformative capabilities of ChatGPT, seamlessly integrating it with the robust features of Power BI. Discover how artificial intelligence can revolutionize your data workflows, enhance dashboard quality, and provide unparalleled insights. Whether you're a data enthusiast, a Power BI user, or a developer, this path offers a vantage point into the future of AI-driven data analytics.

The first of the two-part preparation course for the Microsoft's DP-500 Exam Certification

Unlocking Advanced Insights with ChatGPT's Advanced Data Analysis (ADA)

Deepen your understanding of the Power Query/M concepts through practical application

Expand Power BI's capabilities in accessing a wide range of data using APIs

Unlock the power of data analysis and visualization with PandasAI, and transform raw data into actionable insights that drive decision-making and growth.

Delve deep into the realm of Data Analytics with 'Foundations of Data Analytics', emphasizing the significance and practicality of data-driven insights in contemporary decision-making.

From Data Preprocessing to Advanced AutoML: Mastering Predictive Analytics in Power BI

Get familiar with structured values in the M language and discover how to interact with them.

Learn the best practices for transforming data in the query editor

Explore structured columns containing Lists, Records or Tables

Why No-Code and Standardized Visualizations are the Future in Data Analytics and Visualizations

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

Problem of the Week gives you real-world DAX and Power Query scenarios that will challenge your analytical skills.

Learn the steps that an Enterprise BI team can take to implement application lifecycle management (ALM) in their Power BI environment

Find out how Sidekick can help to review, optimize & cleanup your dataset and reports

Critical thinking to improve problem solving and decision making

Build a Power Automate workflow that shows how a user can save an excel file into a folder

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

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

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded

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

Challenge your data skills in creating an analysis report on substance

Provide a business solution by creating an intelligence tool to use by large opticians

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

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.

Unlock the ‘Each’ expression in Power Query/M

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

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