Training Course
Introduction to Power Query
Delve into the depths of Power BI's Power Query Editor with our training course for beginners. You will become adept at Data Cleansing & Preparation with Power BI & learn how to use M Script and R Script to simplify your data challenges.
£1,395.00
2 days
Flexible (PTR | Onsite | Virtual)

Overview
Introduction to Power BI's Power Query - Hands-on Learning
This course will delve into the depths of the Power Query Editor in Power BI and the Data Cleansing & Preparation stage of Power BI development.
Develop Power Query Skills for Power BI:
How to use Power Query Editor for Data Cleansing & Preparation.
How to approach Data Mashup & Transformation using M Script and R Script.
How to use more advanced tools to assist with data preparation.
How to merge data together from multiple sources.
This is a hands-on course and will take you through a variety of realistic lab scenarios and data preparation challenges. By the end of this course you will be fully prepared to solve your own data quality issues and produce high quality report ready data.
Learn to Harness Power Query and Solve Your Data Challenges
If you use Power BI and experience the challenges of data preparation, you'll know why it's so important to understand how to deal with the quagmire of errors, formatting issues and struggles of bringing data together from multiple sources.
If you can't resolve these data issues, you get bad data that leads to flawed insights. The vital foundation for all great reports is well-prepared data, this course will teach you how to get your data report ready for clear and accurate reporting.
Power BI's Power Query Training Tailored to Your Needs
This Power BI training course is offered in a face to face classroom or virtual setting and can be tailored to your needs.
Follow our Power BI Learning Path
Learn Power BI With an Introduction to Power BI
Our Introduction to Power BI Training course will help you get the most out of your Power BI investment, be that a self-contained dataset and dashboard or an enterprise wide business intelligence solution integrating data from across your business.
Learn to Create Semantic Models
With your data preparation complete you'll now need to create your tabular model. Take the next step on your Power BI journey with our Tabular Modelling For Power BI Course.
Create Measures With DAX
Our Introduction to DAX course will reveal to you a whole new world of Power BI. DAX is the native language of Power BI and is used extensively to create a variety of measures, creating powerful insights for your reports.
Focused Workshops - Bring Your Data
Consider some follow-on workshops working with your own data and discover how your new Power BI skills can be applied in your own challenging environments with our blended learning options.
Prerequisites
Ahead of attending this course, it's recommended that you attend the Introduction to Power BI course which will give you a foundation in how to use Power BI. It is recommended that you have practical experience with Power BI and a basic understanding of how to use it.
Details
Introduction to Power Query FAQs
Couldn’t find the answer you were looking for? Feel free to reach out to us! Our team of experts is here to help.
Contact Us