In this Power Query Course, learn everything you need to know to about:
- Importing data
- Merging data
- Shaping data
- Cleaning data
Here is a list of concepts that you will learn in this course:
- Activate “Applied Steps” panel
- Import data from external data sources
- Combine multiple files in a common folder
- Import data from the Web
- Apply JOIN and its types
- Merge data – A VLOOKUP Alternative
- Append (Combine) data with Power Query
- Remove duplicates, blanks rows, and special characters present in your data
- Split column using different options
- Duplicate and rename queries
- Record your steps and automate processes – Applied Steps
- Master unique tips, tools, and case studies
If you are planning to implement Data Analytics or Business Intelligence solutions using tools like Power BI, Tableau, Python, R, etc. then Power Query fluency is a must.
Note: Power Query techniques taught in this course apply to both versions i.e. Excel 2010+ and Power BI. However, we have used Power BI’s user-interface (UI) to teach those techniques. The same UI exists in Excel’s Power Query.
Check out the Course Curriculum for the complete list of videos in this course.
COURSE AUTHOR: Rishabh Pugalia
- 🎓 40,000+ Classroom Students | 💡 200,000+ Students Online
- ex-KPMG, ex-J.P. Morgan | Chartered Accountant
- Taught 16,000+ participants across PwC, EY, and Deloitte over the last 10 years
- After a decade of corporate training and winning multiple accolades in Office Productivity, Automation & Analytics, I set on a mission to help 1 mn people by 2025
- 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
