ENROLL NOW
Course Name
Course Code : RBW34
Venue Details
Postal Code : Z05H9K3
Session Dates
Duration: 2 days (14 hours)
This course provides a comprehensive introduction to Power Query, a data transformation and preparation engine built into Excel and Power BI. Participants will learn how to connect to various data sources, clean and shape data, automate repetitive tasks, and prepare datasets for analysis without complex coding. Ideal for analysts, Excel users, and BI professionals.
Course Agenda
What is Power Query and where it fits (Excel, Power BI)
Power Query interface and navigation
Connecting to data sources: Excel, CSV, Web, SQL Server
Overview of applied steps and query refresh
Column management: splitting, merging, renaming
Filtering, sorting, and removing rows
Changing data types and replacing values
Grouping and summarizing data
Appending and merging queries
Pivoting and unpivoting data
Creating parameters and custom columns
Introduction to M language and formula bar
Hands-on Exercises
Mode of Delivery : The event can be attended both online and at nearby ProgNXT classroom by Individual Professionals and Corporate Employees as per the seat availability. Please Contact Us at [email protected] for checking the seat availability
Audience : We have a global audience that logs in to using their own computers to work hand in hand with our world-class instructors.
Assessment : Each training course will have ProgNXT Assessment at the end.
Certification : After successful passing of ProgNXT Assessment, ProgNXT Certification will be provided, which has got acceptance in 55+ Countries.
| Global Region | Location | Start Date | End Date | Action |
|---|---|---|---|---|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |