course | Microsoft Power Query Advanced
We turn your development needs and aspirations into powerful digital solutions that drive growth
IT-1365 | Microsoft Power Query Advanced
Course Sector : Information Technology
| Duration | Date from | Date to | Course Venue | Course fees | Book a course |
|---|---|---|---|---|---|
| 5 Days | 2025-12-08 | 2025-12-12 | Dubai | $4,250 | Book now |
Course Introduction
Power Query is one of the most effective tools in Excel use for data discovery, transformation, and enrichment. It allows you to combine data quickly and easily from one or more structured or semi-structured sources (Excel, CSV, relational databases, SAP, online services, etc.) as well as to clean, reshape, and combine data with ease, no matter where it comes from. This training course is designed to help participants gain the necessary skills and knowledge in utilizing Power Query in mastering mastering data, and advance techniques.
Course objective
- Import data from external sources (ex: Access, SQL, Web, etc.).
- Utilize advanced transformation techniques and patterns to solve various data challenges
- Apply techniques in optimizing existing queries and future proof new queries
- Obtain an in-depth understanding of the M language, and advanced M Language techniques.
- Aggregate and extrapolate information from incomplete data.
- Edit query scripts using the M programming language.
Course Outline | Day 01
What is Power Query?
- Versions of Power Query
- Power Query UI Walk Through
- When to Use Power Query
Importing Data
- Connecting to Delimited Flat Files
- Connecting to Data in Excel Workbooks
- Connecting to Data in the Current Excel Workbook
- Connecting to Non-Delimited Flat Files
- Importing from Databases
- Importing from Web Data
Formulas and Logic
- Creating Power Query Formulas
- Creating Conditional Logic
Power Query Objects
- Automating Query Refreshes
Course Outline | Day 02
The M Language
- Understanding the Power Query “Mashup”
- Language (“M” Language)
- Advanced M Techniques
- Dynamically Creating a List of Headers
- Techniques to Rename Columns
- Advanced Table Append
- Managing Changes to Columns
- Creating Audit Queries and Alerts
Advanced Transformation Techniques
- Unpivoting Columns
- Pivoting Columns
- Splitting Columns into Other Columns
- Splitting Columns into Rows
- Filtering Data
- Sorting Data
- Working with Existing Columns
- Adding a Column Based on a Cell Value
- Working with Random Numbers
- Grouping and Summarizing Data
- Converting a Flat Table into Dimensions
- Ranking Data
Course Outline | Day 03
Advanced Data Reshaping
- Time to Change Gears
- Pivoting Stacked Data
- Pivoting Stacked Data Revisited
- Unpivoting Subcategorized Data
- Pivoting Vertical Pairs
- Pivoting Horizontal Pairs
- Numbering Grouped Rows
- A Hacker’s Approach to Numbering Group Rows
- Adding Comments to Tables
Advanced Web Techniques
- Parsing an HTML Web Page
- Parsing HTML as Text
- Basic Web Scraping
- Advanced Web Scraping
- Combining Multiple Web Pages
- Pagination and DO/WHILE
Query Optimization
- Optimizing Power Query Settings
- Leveraging Buffer Functions
- Reducing Development Lag
BOOST’s Professional Attendance Certificate “BPAC”
BPAC is always given to the delegates after completing the training course,and depends on their attendance of the program at a rate of no less than 80%,besides their active participation and engagement during the program sessions.
Since 2001, we have been pioneering the training field in the Middle East, helping individuals, teams, and organizations reach their full potential with integrated solutions.
🔗 Quick Links
Sister Companies to Boost Consulting and Training
most trending
And Recommended Training Courses
We believe in progress for everyone.
We helped more than 10,000 clients over 20 countries on 4 continents in boosting their knowledge, skills, and careers.
Boost Training And Consulting All Copyrights Reserved 2025