Getting Started with Power Query in Power BI
Power BI 2.12
| Beginner
- 14 videos | 1h 56m 51s
- Includes Assessment
- Earns a Badge
Power Query is a powerful data transformation and preparation tool, seamlessly integrated into Microsoft Power BI and other Microsoft products such as Excel. It enables users to effortlessly extract, transform, and load data from various sources, ensuring data consistency and quality. Begin this course by exploring how to transform and clean data using Power Query. You will learn to delete, rename, and move columns, remove duplicates, and perform a host of other data cleaning and processing operations. Next, you will discover how to create query duplicates and references and how to perform basic and advanced filtering on your data. Then you will find out how to add columns with calculated and conditional values and how you can use merge queries to create a new column in your data. Finally, you will perform grouping and aggregation operations, create parameterized queries, and combine query data using the append operation. This course will provide you with a solid understanding of how Power Query can be used for data transformation.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Recall key concepts of power query
Perform operations using power query
Perform column deletion and rename operations
Perform data cleaning and transformations
Split columns and remove duplicates
Create query duplicates and query references -
Perform basic and advanced filtering
Add calculated and conditional columns
Create columns using merge queries
Perform grouping and summarization operations
Create parameterized queries
Combine queries using append
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 39sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
7m 47sAfter completing this video, you will be able to recall key concepts of Power Query. FREE ACCESS
-
3. Getting Started with Power Query10m 28sIn this video, find out how to perform operations using Power Query. FREE ACCESS
-
4. Performing Column Deletion and Renaming Operations8m 39sLearn how to perform column deletion and rename operations. FREE ACCESS
-
5. Cleaning Data and Performing Basic Transformations7m 36sDuring this video, discover how to perform data cleaning and transformations. FREE ACCESS
-
6. Splitting Columns and Removing Duplicate Rows9m 24sFind out how to split columns and remove duplicates. FREE ACCESS
-
7. Duplicating and Referencing Queries10m 41sIn this video, you will learn how to create query duplicates and query references. FREE ACCESS
-
8. Creating Basic and Advanced Filters11m 47sDiscover how to perform basic and advanced filtering. FREE ACCESS
-
9. Adding Custom and Conditional Columns10m 1sDuring this video, you will learn how to add calculated and conditional columns. FREE ACCESS
-
10. Creating Columns Using Merge Queries11m 21sFind out how to create columns using merge queries. FREE ACCESS
-
11. Grouping and Summarizing Operations10m 49sIn this video, discover how to perform grouping and summarization operations. FREE ACCESS
-
12. Using Parameterized Queries4m 29sLearn how to create parameterized queries. FREE ACCESS
-
13. Combining Queries Using Append10m 2sIn this video, find out how to combine queries using append. FREE ACCESS
-
14. Course Summary2m 8sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
