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.
Duration 14 hours
Course Outline
Introduction to Power Query
- Overview of the Power Query interface
- Grasping the concepts of queries and applied steps
- Navigating integrations with Power BI and Excel
Connecting to Data Sources
- Importing data from Excel, CSV, and text files
- Handling folders and structured datasets
- Establishing connections to online and database sources
Fundamentals of Data Cleaning
- Eliminating errors and duplicate entries
- Filtering, sorting, and reshaping data
- Addressing missing values
Transformations and Data Shaping
- Splitting and combining columns
- Performing pivot and unpivot operations
- Grouping and aggregating information
Combining Queries
- Differentiating between append and merge queries
- Considering join types and data structure implications
- Modelling datasets from multiple sources
Introduction to the M Language
- Understanding M formulas
- Editing queries via the Advanced Editor
- Writing custom transformation logic
Automation and Refresh
- Creating reusable workflows for transformation
- Setting up refresh schedules
- Managing dependencies and optimising query performance
Advanced Techniques
- Parameterising queries
- Utilising functions within M
- Best practices for building scalable transformation pipelines
Summary and Future Steps
Requirements
- A foundational understanding of data handling in spreadsheet applications
- Practical experience with basic data analysis tasks
- Familiarity with standard file formats, including CSV and Excel
Target Audience
- Data professionals responsible for cleaning and preparing datasets
- Business analysts managing recurring data workflows
- Individuals involved in data reporting and process automation
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.