This course is designed to equip participants with the skills needed to effectively use Power Query in Power BI. Throughout the course, participants will learn to navigate the Power Query Editor interface, transform and clean data, and apply best practices in data preparation for analysis. The course includes hands-on modules covering topics such as importing data from various sources, using data transformation tools, and performing advanced data transformations like pivoting and unpivoting columns.
By the end of the course, participants will have a solid understanding of the tools available in the Power Query Editor and be able to confidently prepare data for analysis.
Someone who works with data analysis, needs to clean and transform large datasets from various sources regularly, and wants to efficiently prepare data for visualization and reporting within Power BI.
By actively participating in this course, you will learn about the following:
Understand the purpose and benefits of using Power Query in Power BI.
Navigate the Power Query Editor interface with confidence.
Use the available tools to transform and clean data effectively.
Apply best practices in data preparation for analysis.
We recommend that delegates have existing experience with Excel or Databases and should understand basic data concepts. Basic knowledge of Power BI. No prior experience with Power Query required.
Software Requirements for Virtual Classroom
If you are attending our Virtual Classroom training, you will need a laptop or PC with a working microphone and two screens. A webcam is also recommended for the best experience! You will also need to have Power BI Desktop available on your device.
We strongly recommend that delegates also check that their PC meets the Minimum Requirements as outlined on the Microsoft Website and ensure that they are running the latest version of the software so that they can successfully access all student files.
This course is not suitable for MAC users.
Introduction to Power Query
What is Power Query and why use it?
How Power Query fits into Power BI’s ecosystem.
Importing data from various sources (Excel files, CSV, databases, etc).
Launching the Power Query Editor.
Navigating the Power Query Editor
Overview of the Power Query Editor interface.
Understanding applied steps and query dependencies.
Data Transformation Tools
Removing and filtering rows.
Splitting and merging columns.
Changing data types.
Using the "Replace Values" feature.
Sorting and grouping data.
Adding custom columns.
Using "Conditional Column" for logical transformations.
Filling down or up for missing data.
Advanced Data Transformations
Pivoting and unpivoting columns.
Transposing data.
Using the "Merge Queries" and "Append Queries" tools.
Creating and editing parameters.
Working with the "Invoke Custom Function" feature.
Best Practices and Final Q&A
Naming conventions for queries and applied steps.
Organising and documenting queries.