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