This course equips delegates with essential skills to transform, clean, and prepare data efficiently using Power Query, a critical tool for modern data analysis. By mastering key techniques such as merging datasets, handling complex transformations, and automating data workflows, participants will enhance data quality and accuracy, enabling informed decision-making across industries. In an era where data drives business strategy, this training empowers professionals to streamline data preparation processes, reduce manual effort, and unlock deeper insights from raw data sources. Delegates will leave with a robust foundation to tackle real-world challenges, ensuring their data is reliable, structured, and ready for advanced analytics.
Struggling to make sense of messy data? In just half a day, our Power Query course transforms you into a data master... saving hours weekly. Delegates gain confidence in cleaning, shaping, and merging data effortlessly, turning chaos into clarity. Whether you’re new to Power Query or looking to refine your skills, this dynamic session covers everything you need to unlock your data’s potential. Choose open course, closed group training, or one-to-one coaching—flexible to suit your pace. With three CPD hours, it’s a smart investment in your career. Refresh your skills, streamline workflows, and make data work for you. Ready to boost your efficiency? To find out more, contact us at let’s dash talk at eqv dot co dot uk.
Counts towards 3 CPD HoursHalf DayOpen Public & Closed Group
Please reflect on one or more of the questions below and come prepared to discuss your responses during the session.
Self-Assessment: On a scale of 1–10, how would you rate your current skill level in this subject? What factors influenced your rating?
Development Focus: Identify one specific behaviour, skill, or capability you would like to improve or develop further.
Relevant Examples: If possible, bring one or two relevant examples or scenarios from your experience that you would be willing to share with the group.
What You Will Learn
Power Query Overview
Power Query Editor & Basic Transformation
Refresh Data and Options
Merge Data
Data Types, Formatting and Null Values
Correcting Errors in Data
Working with Query dependencies
Basic Power Query Transformations
Filters
Merge
Remove Duplicates
Advanced Power Query Transformation
Unpivot Columns
Group By
Split columns
Working with date / Time transformation
Custom Columns
Combining / Appending Data
Working with Lists & Table Functions
Power Query Workshop
Your Post-Course Challenge
Complete the further practice workbook
Apply the techniques to your own data
Counts Towards 3 CPD Hours
This course contributes 3 hours of Continuing Professional Development. Delegates can log these hours as evidence of structured learning for professional bodies and employers.
This course is designed for professionals seeking to enhance their data management and analysis capabilities using Power Query. Whether you are new to data transformation or looking to refine your skills, this course provides the foundational knowledge and practical tools needed to streamline data workflows and improve decision-making processes.
This course is ideal for:
Data analysts who want to automate data cleaning and transformation tasks
Business professionals aiming to improve data accuracy and reporting efficiency
IT support staff looking to integrate Power Query into their data management strategies
Finance teams requiring tools to consolidate and analyse complex datasets
Students or graduates building technical skills in data analysis and business intelligence
Project managers seeking to enhance their ability to handle and interpret data-driven insights
No prior experience needed
This course is accessible to all experience levels — no prior knowledge of Power Query or advanced data tools is required. The content is structured to guide delegates from fundamental concepts through to practical applications, ensuring a smooth learning journey for beginners and a valuable refresher for more experienced users.
What you will take away
Delegates will leave with the confidence and skills to efficiently transform, merge, and manage data using Power Query. They will be equipped to handle common data challenges, improve data consistency, and apply best practices for working with complex datasets in real-world scenarios.
For Groups & Teams
We can deliver this training session in several ways to suit your organisation’s needs:
Open Public Course
Join delegates from other organisations on a scheduled date
Closed Group
Exclusively for your team, using your real scenarios
In Person
Face-to-face at your premises or a venue of your choice
Virtual
Live, interactive online delivery via Teams or Zoom
One-to-One Coaching
Personalised sessions tailored entirely to you
Have two or more people to train?
You may want to consider a closed group course. Benefits include:
Cost effective for teams
Choose a date to suit you
Customise content and timings
No minimum delegate numbers
Uses your real-world scenarios
Builds shared language in your team
Contact us on [email protected] to discuss specific dates and delivery requirements.
How Our Tutor-Led Courses Are Delivered
Before the day
Delegates are given pre-work to complete before attending. This ensures everyone arrives with relevant context and real scenarios from their own experience, so learning is immediately relevant and actionable from the first minute.
On the day
Our sessions are participative and highly interactive. We don’t do “death by PowerPoint” — instead, the day includes a variety of engaging activities throughout:
Real-world casework using your scenarios
Practical hands-on exercises
Real Play (not role play) simulations
Peer learning and group discussion
Case studies and scenario work
Facilitated discussion and structured reflection
What you leave with
Participants leave with:
Practical tools — frameworks and models you can use straight away
Clear action plans — specific next steps tailored to your role
Greater confidence — built through intensive, realistic practice
Skills you can apply immediately — not theory, but techniques tested during the day
After the day
Post-session measurements and a 30-day challenge ensure that learning is embedded and behaviour change is sustained.
Key Features
Course Duration is 1/2 Day
Engaging tutor led event
Comprehensive course materials
Certificates of attendance
Access to Customer Portal (course bookers)
Course Guarantee
Priced per delegate per day for an Open Public Course
£295.00 Plus VAT
Can’t see a suitable date? Please request a date here
Payment available via all major credit cards or Invoice. All options available during the online booking process.
