Power Query for Excel and Power BI
In this Power Query Online Course, you will learn data cleaning and data transformation techniques.
Enroll in Course
Your Instructor
Rishabh Pugalia | 🔗 Linkedin Profile
⭐ 4.8 Average Rating | 💬 839 Reviews |
🎓 12,589 Classroom Students |💡 40,000 Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)
After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.
Course Curriculum
-
Start1_Introduction to Power Query - What is it? How to access it? (3:05)
-
Start2_Power Query User Interface - A Walkthrough (2:58)
-
Start3_Power BI - Nov 2019 Update (0:53)
-
Start4_M-Query Basics - Reading Commands in Power Query Editor (2:23)
-
Start5_Activate your Applied Steps Panel (0:46)
-
Preview6_Getting the List of all M-Query Commands (2:47)
-
Start7_Importing Data (incl Use First Rows as Header) (2:48)
-
StartCourse Feedback
-
Start1_Combine or Merge Multiple Files from a Folder (6:02)
-
Start2_Importing Data from the Web (7:04)
-
Start3_Merge Queries vs. Append Queries (2:34)
-
Preview4_JOIN Types for Beginners (3:59)
-
Start5_Understanding JOIN Concept and its Types (6:21)
-
Start6_JOIN in Action - Basic Example (5:57)
-
Start7_Quick DOs and DONTs for Merge Queries (3:05)
-
Start8_Merging Queries with more than 1 KeyID Column (6:35)
-
Start9_Fuzzy Lookup (5:37)
-
StartCourse Feedback
-
Start1_Using First Rows as Header (1:43)
-
Start2_Cleaning Up Data with Case Change, TRIM, CLEAN (3:29)
-
Start3_Working with Data Types (2:29)
-
Start4_Fill Down Feature (1:59)
-
Start5_Removing Duplicates and Blank Rows (4:05)
-
Start6_Split Column - Part 1 (Delimiter and By Position) (4:44)
-
Start7_Split Column - Part 2 (Digit vs Non-Digit) (3:24)
-
Start8_Split Column - Part 3 (Split to Rows) (4:53)
-
Start9_Rectify Date Format using Data Type (Locale) (5:12)
-
Preview10_Working with Column From Examples Feature (3:56)
-
Start11_Adding a Conditional Column (3:22)
-
Start12_Merge Columns (Concatenate) (1:48)
-
Start13_Replace Values and Extract Characters (5:46)
-
StartCourse Feedback