Power BI Class 3 Cleaning Transforming Loading Data by taik18

In this video, taik18 provides a comprehensive class on how to clean, transform, and load data in Power BI. The video takes you through various steps, starting with loading the data into Power BI and cleaning it by removing any unwanted columns, duplicate values, and filling in missing values.

The tutorial goes on to demonstrate how to transform data using Power Query, including splitting columns, grouping, pivoting, and merging tables. Moreover, it delves into advanced operations, such as transforming data using custom functions and using the M language to write custom queries.

The final section of the video deals with loading the transformed data, with particular emphasis on creating relationships between tables in Power BI and configuring the data model.

By the end of this tutorial, you'll be well-equipped to tackle data cleaning and transformations in Power BI, enabling you to extract critical insights from your data with ease.

So, whether you're a beginner or looking for a refresher on data cleaning and transformations in Power BI, taik18's class is an excellent resource to add to your toolkit.

The video can be accessed at: https://www.youtube.com/watch?v=U0K9re7RPxE

Published on:

Learn more

Welcome To TAIK18..I am Mohammed Adnan, Consultant and International Trainer (Microsoft Certified) in Power BI, Paginated Report (SSRS), Power Automate, Powe...

Share post:

Related posts

Power BI Class 4 Design a Data Model by taik18

In this informative tutorial, taik18 takes you through the process of designing a data model in Power BI. This class serves as a part of a com...

1 month ago

Understanding What Data Modeling Is And Creating The Right Relationships

In this tutorial, you'll learn about the concept of data modeling and how to create the right relationships between different data tables in y...

2 months ago

Power BI Introduction Power BI Desktop | Power BI Service | Power Query | Data Modelling Data Visualization | Power BI Mobile Data Connectivity

Microsoft Power BI is a powerful and popular business intelligence and data visualization tool or suite developed by Microsoft. It enables use...

1 year ago

Data Modeling for Mere Mortals – Part 2: Dimensional Modeling Fundamentals

This article is the second installment in the "Data Modeling for Mere Mortals" series, where you'll delve into the fundamentals of dimensional...

1 year ago

Pandas AI: Data Analysis With Artificial Intelligence

Pandas, a popular Python library for data analysis, has just received a boost in the form of Pandas AI. This new addition enables Pandas to di...

1 year ago

What is Data Modeling? How to do Data Modelling? Learn Data Modeling with Power BI in just 60 Min

In this comprehensive tutorial, you'll gain insights into the intricacies of data modelling and learn essential techniques to sharpen your dat...

1 year ago

New On Power BI Showcase – YouTube Data Analysis

Unlocking the power of data can yield incredible insights for data analysts, social media marketers, and YouTube content creators alike. By an...

1 year ago

Optimize Power BI Data Model data type by taik18

In this video by taik18, you'll learn how to optimize the data types in your Power BI data model. With a focus on Power BI shorts, this tutori...

1 year ago

Microsoft Power BI Shifts Focus to Include Data Visualization

In a surprising announcement, Microsoft has decided to include data visualization in Power BI, shifting the tool's focus from being just a dat...

3 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy