Data Preparation, Transformation & Cleaning with Power Query

Focused View

Foresight BI & Analytics,Ahmed Oyelowo

3:44:39

38 View

1. Introduction

1. Introduction.mp4

03:01

2.1 PowerQuery Essentials.zip

2. Download the course files.html

3. Getting Data into Power Query.mp4

06:33

4. Understanding how Power Query works.mp4

08:24

5. Previewing Empty and Error values with Column Quality.mp4

03:37

6. Previewing Distinct and Unique with Column Distribution.mp4

04:15

7. Previewing Columns Statistical Summaries with Column Profile.mp4

03:20

8. Setting Data Preview checks for entire dataset.mp4

01:29

9. Chapter 1 Quiz.html

2. Transforming Data with Power Query

1. Introduction to Combining Data Queries.mp4

01:58

2. Understanding Append Queries.mp4

07:07

3. What you must know about Append Queries.mp4

04:15

4. Understanding Merge Queries.mp4

06:30

5. Using Multiple Columns as Keys for Merging Queries.mp4

08:02

6. Understanding Join Kinds.mp4

04:53

7. Using the different Join Kinds in Power Query.mp4

10:15

8. What you must know about Merge Queries.mp4

04:29

9. Introduction to Transposing Data.mp4

04:12

10. Transposing Data when there is Header Row.mp4

05:15

11. Understanding Unpivot Columns.mp4

06:40

12. Unpivoting Columns when there are null values.mp4

03:25

13. Unpivoting Columns without Header Rows.mp4

03:38

14. Understanding Pivot Columns.mp4

06:31

15. Understanding Group By.mp4

09:21

16. Chapter 2 Quiz.html

3. Adding Calculated Columns

1. Adding Duplicate and Index Columns.mp4

04:39

2. Adding new Columns from a Text Column.mp4

04:00

3. Adding new Columns from Numbers and Date Columns.mp4

05:07

4. Adding Conditional Columns (1).mp4

04:18

5. Adding Conditional Columns (2).mp4

05:59

6. Adding Custom Columns (1).mp4

06:27

7. Adding Custom Columns (2).mp4

04:18

8. Adding Columns From Examples.mp4

02:41

9. Chapter 3 Quiz.html

4. Other Transformations and Dealing with Errors

1. Other common Column Transformations.mp4

07:00

2. Removing Duplicate Records.mp4

02:07

3. Dealing with Cell Errors in Power Query.mp4

08:06

4. Checking for Cell Errors reasons in Power Query.mp4

06:39

5. Data Cleaning

1. Introduction to Data Cleaning.mp4

01:47

2. Data Cleaning Example 1.mp4

08:00

3. Data Cleaning Example 2.mp4

06:13

4. Data Cleaning Example 3.mp4

06:07

5. Data Cleaning Example 4.mp4

04:34

6. Data Cleaning Example 5.mp4

07:41

7. Data Cleaning Example 6.mp4

11:46

Description

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.

Who is this 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.

What You Need to Know?

You should have Power BI Desktop installed on your computer

Power BI beginner level experience

More details

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!
Who this course is 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.

User Reviews

Rating

average 0

Total votes0

Focused display

Power Query

Foresight BI & Analytics

Instructor's Courses

Foresight BI & Analytics Global Solutions (Foresight BI) is a Business Intelligence and Data Analytics firm focused on delivering world-class Training and Consulting Services.Our training objective is to ensure participants, understand technical concepts with ease.Our Trainers are Microsoft Certified, with years of rich Training and Consulting experience.Our Trainers are publishers of Best Seller Courses on Udemy, with reputations for simplifying technical concepts into a lay man's language.

Ahmed Oyelowo

Instructor's Courses

Ahmed is a Microsoft Data Platform MVP, a Microsoft Certified Trainer, Microsoft Certified Educator, Microsoft Certified Power BI Data Analyst, Microsoft Certified Azure Enterprise Data Analyst, Microsoft Office Specialist Excel Expert ?(He needs to stop ?)He has developed cutting edge solutions and trained various corporate clients on Business Intelligence and Financial Modeling. He has been consulting & training on Power BI since it’s early days in 2015.Ahmed has trained courses on:1. Power BI2. Power Query,3. Financial Modelling4. Advanced Data Analysis & Reconciliation and5. Data Presentation.He is the Managing Partner & Lead Trainer at Foresight BI & Analytics.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.