Data Preparation, Transformation & Cleaning with Power Query

سرفصل های دوره

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

1. Introduction

1. Introduction

2.1 PowerQuery Essentials.zip

2. Download the course files.html

3. Getting Data into Power Query

4. Understanding how Power Query works

5. Previewing Empty and Error values with Column Quality

6. Previewing Distinct and Unique with Column Distribution

7. Previewing Columns Statistical Summaries with Column Profile

8. Setting Data Preview checks for entire dataset

9. Chapter 1 Quiz.html

2. Transforming Data with Power Query

1. Introduction to Combining Data Queries

2. Understanding Append Queries

3. What you must know about Append Queries

4. Understanding Merge Queries

5. Using Multiple Columns as Keys for Merging Queries

6. Understanding Join Kinds

7. Using the different Join Kinds in Power Query

8. What you must know about Merge Queries

9. Introduction to Transposing Data

10. Transposing Data when there is Header Row

11. Understanding Unpivot Columns

12. Unpivoting Columns when there are null values

13. Unpivoting Columns without Header Rows

14. Understanding Pivot Columns

15. Understanding Group By

16. Chapter 2 Quiz.html

3. Adding Calculated Columns

1. Adding Duplicate and Index Columns

2. Adding new Columns from a Text Column

3. Adding new Columns from Numbers and Date Columns

4. Adding Conditional Columns (1)

5. Adding Conditional Columns (2)

6. Adding Custom Columns (1)

7. Adding Custom Columns (2)

8. Adding Columns From Examples

9. Chapter 3 Quiz.html

4. Other Transformations and Dealing with Errors

1. Other common Column Transformations

2. Removing Duplicate Records

3. Dealing with Cell Errors in Power Query

4. Checking for Cell Errors reasons in Power Query

5. Data Cleaning

1. Introduction to Data Cleaning

2. Data Cleaning Example 1

3. Data Cleaning Example 2

4. Data Cleaning Example 3

5. Data Cleaning Example 4

6. Data Cleaning Example 5

7. Data Cleaning Example 6

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy