Data Preparation, Transformation & Cleaning With Power Query

Data Preparation, Transformation & Cleaning With Power Query
Published 10/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.92 GB | Duration: 3h 45m

Unlock the full potential of Power BI with a deep dive into Power Query. Perfectly curated by a 4-time Microsoft MVP

What you'll learn

Combining Queries - Master the techniques of appending and merging data to maximize your analytical reach.

Data Preview Tools - Dive deep into Column Quality, Column Distribution, and Column Profile to understand your dataset at a glance.

Data Shaping Techniques - Unleash the power of operations like Transpose, Unpivot, and Group By to shape data as per your requirements.

Calculated Columns - Delve into creating impactful columns with operations like Duplicate, Index, Conditional Columns, Custom Columns, and the revolutionary 'C

Real-World Data Cleaning - Practical hands-on exercises where you'll clean up 6 sets of dirty data, transforming them into pristine, actionable datasets.

Requirements

You should have Power BI Desktop installed on your computer

Power BI beginner level experience

Description

Course Overview:Harness the capabilities of Power BI to its fullest! Power BI is a formidable tool, but its efficiency heavily depends on the quality of data it processes. With Power Query, you can ensure your data is cleaned, optimized, and ready for any visualization or analytics task.This course, crafted by a 4-time Microsoft MVP, a Microsoft Certified Trainer, and Microsoft Certified Educator, is designed to offer you the hands-on skills you need to master data preparation, transformation, and cleaning in Power BI.What You Will Learn:Combining Queries - Master the techniques of appending and merging data to maximize your analytical reach.Data Preview Tools - Dive deep into Column Quality, Column Distribution, and Column Profile to understand your dataset at a glance.Data Shaping Techniques - Unleash the power of operations like Transpose, Unpivot, and Group By to shape data as per your requirements.Calculated Columns - Delve into creating impactful columns with operations like Duplicate, Index, Conditional Column, Custom Column, and the revolutionary 'Column from Example'.Real-World Data Cleaning - Practical hands-on exercises where you'll clean up 6 sets of dirty data, transforming them into pristine, actionable datasets.Who Is This Course For?Power BI enthusiasts who wish to level-up their data processing skills.Data analysts and professionals who deal with large or complex datasets regularly.Anyone aspiring to master the art of data cleaning and transformation in Power BI.Why Choose This Course?Expertise - With a seasoned Microsoft veteran at the helm, you're not just learning Power Query, you're mastering it with an expert.Hands-On Approach - Beyond just theory, engage with practical exercises that give you real-world data cleaning experience.Certified Knowledge - Leverage the insights from a Microsoft Certified Trainer and Educator, ensuring the quality and relevance of the content.Wrap-Up:Step into the world of Power Query with confidence. With each module of this course, you'll be better equipped to transform any dataset into a goldmine of insights. Whether you're just starting out or seeking to hone your Power BI skills, this course is the key to unlocking your data's true potential.Equip yourself with the skills to turn raw data into refined insights. Enroll today and revolutionize your Power BI journey!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Download the course files

Lecture 3 Getting Data into Power Query

Lecture 4 Understanding how Power Query works

Lecture 5 Previewing Empty and Error values with Column Quality

Lecture 6 Previewing Distinct and Unique with Column Distribution

Lecture 7 Previewing Columns Statistical Summaries with Column Profile

Lecture 8 Setting Data Preview checks for entire dataset

Section 2: Transforming Data with Power Query

Lecture 9 Introduction to Combining Data Queries

Lecture 10 Understanding Append Queries

Lecture 11 What you must know about Append Queries

Lecture 12 Understanding Merge Queries

Lecture 13 Using Multiple Columns as Keys for Merging Queries

Lecture 14 Understanding Join Kinds

Lecture 15 Using the different Join Kinds in Power Query

Lecture 16 What you must know about Merge Queries

Lecture 17 Introduction to Transposing Data

Lecture 18 Transposing Data when there is Header Row

Lecture 19 Understanding Unpivot Columns

Lecture 20 Unpivoting Columns when there are null values

Lecture 21 Unpivoting Columns without Header Rows

Lecture 22 Understanding Pivot Columns

Lecture 23 Understanding Group By

Section 3: Adding Calculated Columns

Lecture 24 Adding Duplicate and Index Columns

Lecture 25 Adding new Columns from a Text Column

Lecture 26 Adding new Columns from Numbers and Date Columns

Lecture 27 Adding Conditional Columns (1)

Lecture 28 Adding Conditional Columns (2)

Lecture 29 Adding Custom Columns (1)

Lecture 30 Adding Custom Columns (2)

Lecture 31 Adding Columns From Examples

Section 4: Other Transformations and Dealing with Errors

Lecture 32 Other common Column Transformations

Lecture 33 Removing Duplicate Records

Lecture 34 Dealing with Cell Errors in Power Query

Lecture 35 Checking for Cell Errors reasons in Power Query

Section 5: Data Cleaning

Lecture 36 Introduction to Data Cleaning

Lecture 37 Data Cleaning Example 1

Lecture 38 Data Cleaning Example 2

Lecture 39 Data Cleaning Example 3

Lecture 40 Data Cleaning Example 4

Lecture 41 Data Cleaning Example 5

Lecture 42 Data Cleaning Example 6

Power BI enthusiasts who wish to level-up their data processing skills.,Data analysts and professionals who deal with large or complex datasets regularly.,Anyone aspiring to master the art of data cleaning and transformation in Power BI.