Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Power Query
- Power Query interface overview
- Understanding queries and applied steps
- Navigating the Power BI and Excel integrations
Connecting to Data Sources
- Importing Excel, CSV, and text files
- Working with folders and structured datasets
- Connecting to online and database sources
Data Cleaning Fundamentals
- Removing errors and duplicates
- Filtering, sorting, and shaping data
- Working with missing values
Transformations and Data Shaping
- Splitting and merging columns
- Pivoting and unpivoting
- Grouping and aggregating data
Combining Queries
- Append vs. merge queries
- Join types and data structure considerations
- Modeling multi-source datasets
Introduction to M Language
- Understanding M formulas
- Editing queries using the Advanced Editor
- Writing custom transformations
Automation and Refresh
- Creating reusable transformation workflows
- Configuring refresh schedules
- Managing dependencies and query performance
Advanced Techniques
- Parameterizing queries
- Using functions in M
- Best practices for scalable transformation pipelines
Summary and Next Steps
Requirements
- An understanding of spreadsheet-based data work
- Experience with basic data analysis tasks
- Familiarity with common file formats such as CSV and Excel
Audience
- Data professionals who need to clean and prepare datasets
- Business analysts responsible for recurring data workflows
- Anyone involved in data reporting and process automation
10 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £3800 online delivery, based on a group of 2 delegates, £1200 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
The manner in which the presenter addressed questions. The method of delivering the course was very beneficial to the students. A very good teacher indeed.
ROSE BALOYI - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
the clear and concise explanations
Georgiana - Everience
Course - Power BI Basic
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
