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 |
🎓 30,000+ Classroom Students |💡 160,000+ Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12,000+ participants across PwC, EY and Deloitte over last the 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit), 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, Flipkart, Uber, Tata Group etc. use these video courses to excel at work - Automation & Analytics.
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)
-
StartFeedback
-
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