Main MenuMain Menu
Course Code: IT 191
168 Course Visits
Microsoft Power Query Advanced
Course Sector:
Information Technology
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
No available dates now, will be added soon..
Introduction
Training course introducion / brief
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 Objectives
At the end of the training course, participants will be able to
- 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 Audience
Who is this course for, and can benefit the most
.
Course Outline
The course aims and learning outcomes
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
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
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
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “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.
ENDORSED EDUCATION PROVIDER
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY
Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).
At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.
Since 2001, we have been pioneering the training field in the middle east, we managed to unlock potential and help individuals, teams and organisations to be the best that they can be with our full and integrated solutions.
Quick Links
Our sister companies in Egypt and United Arab Emirates
MOST TRENDING
And Recommended Training Courses
trending
Artificial Intelligence for Leaders
Date: Feb 17, 2025
Location:Abu Dhabi, UAE
trending
ISO 55001 2014 Lead Auditor (Asset Management Systems) – Lead Auditor
Date: Aug 18, 2025
Location:Muscat, Oman
trending
Professional in Business Analysis (PMI-PBA Exam Preparation)
Date: May 18, 2025
Location:Jeddah, KSA
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