Name: Power Query Fundamentals
Rating: 5 (3 reviews)

Module 1: Getting Started 1. Introduction to Power Query Free Preview 2. Course Outline Free Preview 3. Download Power Query 4. Overview of Course FilesModule 2: Basic Transformations 1. Basic Transformations Objectives 2. What is a CSV File 3. Database Normalization Free Preview 4. Basic CSV Unpivot 5. Import CSV File 6. The Power Query Editor Free Preview 7. Manipulating Column Headers 8. The Query Steps Pane 9. Deleting Columns 10. Unpivoting Columns 11. Filtering Blanks 12. Defining Data Types 13. Loading Query 1a to the Worksheet 14. Exercise 1b - CSV Import N Columns 15. Duplicating Queries 16. Modifying the Source 17. Importing an Unknown Number of Columns 18. Futureproofing Queries 19. Exercise 1c - Filter Non Dates 20. Import CSV File 1c 21. Identify Correct Column Headers 22. Remove Unwanted Columns 23. Unpivot and Rename 24. Date Settings 25. Interpreting and Filtering Dates 26. Loading as Connection Only 27. Exercise 1d - Grouped Row Headers 28. Fill Values Down 29. Thinking about the Order of Steps 30. Pivot Grouped Headers 31. Adding a Duplicate Column 32. Finishing up Exercise 1d 33. Exercise 1z - Student Exercise 34. Exercise 1z - Clues 35. Exercise 1z ReviewModule 3: Extracting Information 1. Extracting Information Objectives 2. A Closer Look at Filters 3. Creating Query Folders 4. Exercise 2a - Better Filters 5. Extracting Characters from Text 6. Checking Filter Logic 7. Exercise 2b - Import Basic Excel Files 8. Dealing with Ghost Columns 9. Exercise 2c - Splitting Columns 10. Referenced Queries 11. Splitting by Delimiter 12. Splitting by Character Number 13. An Introduction to M Code 14. Commenting Code 15. Exercise 2d - Splitting columns into rows 16. Import an Excel Table 17. Split a Column into Rows 18. Exercise 2z - Student Exercise 19. Exercise 2z - Clues 20. Exercise 2z - Review 21. What if the Dataset Grows 22. Learning Experience SurveyModule 4: Consolidating Data 1. Consolidating Information Objectives 2. Exercise 3a - Grouping Data 3. Setting Up Our Query 4. Aggregating Multiple Columns 5. Identifying a Specific Month 6. Grouping Rows 7. Exercise 3b - Merging Tables 8. Two Queries from the Same File 9. Merging Queries 10. Expanding Merged Columns 11. Exercise 3c - Combining Identical Files 12. Create Query from Folder 13. Modifications Required before Combining 14. The Combined Query 15. Extracting Data from Each Filename 16. Using Filters for Investigation 17. Exercise 3z - Student Exercise 18. Exercise 3z - Clues and Challenges 19. Exercise 3z - ReviewModule 5: Dealing with Errors 1. Dealing with Errors Objectives 2. Exercise 4a - Basic Errors 3. Tracking Down Errors 4. Managing Errors in the Power Query Editor 5. Using Find Replace to Fix a Character Error 6. Exercise 4b - Errors with Date Locales 7. Changing a Column Date Locale 8. Exercise 4c - Dealing with Exceptions 9. Creating a Conditional Column with a Columnar Output 10. Creating a Conditional Column with a Text Output 11. Exercise 4d - Errors with File Locations 12. Creating a Parameter 13. Using a File Location Parameter 14. Opening the All Queries File 15. Exercise 4z - Student Exercise 16. Exercise 4z - Clues 17. Exercise 4z - ReviewModule 6: Course Summary 1. ConclusionModule 7: Qualified Assessment 1. Qualified Assessment 2. Share Your Feedback 3. Course Completion

Get flat 10% off  on CFI's all-access subscription plans

English

United States dollar

Power Query is a vital skill for Excel-focused analysts. It is also a valuable asset to Business Intelligence analysts. These skills will allow you to spend less time manipulating data and more time working on analysis projects.


 This online Power Query Fundamentals course will teach you about data transformation and automation. Learn how to extract data from different sources and convert it into more suitable layouts for analysis. You will learn how to automate data connections, transformations, and how to extract and consolidate multiple files. We'll also discuss common mistakes.


 Stop. Power Query will revolutionize your work.


 You've probably worked with Excel data extracts and regular reports. If so, you know how tedious it can be to modify the layout, extract data, or lookup values from other tables. These tasks are repeated every week or monthly, depending on whether you receive a new report.


 Stop wasting time manipulating data

Learn "Power Query Fundamentals" "Certification" by "Corporate Finance Institute (CFI)" and upskill your career by acquiring skills like Database Management etc with Careervira.

Power Query Fundamentals

Power Query Fundamentals

Description

Features

Duration

Skills

Learning Goals

Course Content

Prerequisites/Requirements

Target Audience

Reviews

Sort by

FAQs

Do you have the Excel files and financial modeling templates that I need to download?

What is the time commitment to complete the courses?

Is CFI officially accredited?

Are there additional costs or fees?

Which currency are your courses listed in?

How can I earn my certificates?

These courses will help me to advance my career?

Do you allow me to email the instructor with any questions?

How much is the subscription price?

What's included in the subscription?

Have more questions?

₹3,018