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
- Comprehending queries and applied steps
- Exploring integrations with Power BI and Excel
Data Source Connectivity
- Importing data from Excel, CSV, and text files
- Handling folders and structured datasets
- Connecting to online services and database sources
Foundations of Data Cleaning
- Eliminating errors and duplicate entries
- Filtering, sorting, and restructuring data
- Addressing missing values
Data Transformation and Shaping
- Splitting and merging columns
- Pivoting and unpivoting data
- Grouping and aggregating information
Query Integration
- Comparing appending versus merging queries
- Join types and considerations for data structure
- Modeling datasets from multiple sources
Introduction to the M Language
- Grasping M formulas
- Modifying queries via the Advanced Editor
- Creating custom transformation logic
Automation and Refresh Mechanisms
- Building reusable transformation workflows
- Setting up refresh schedules
- Managing dependencies and query performance
Advanced Methods
- Parameterizing queries
- Utilizing functions within M
- Best practices for scalable transformation pipelines
Recap and Future Steps
Requirements
- A foundational understanding of spreadsheet-based data handling
- Experience with basic data analysis operations
- Familiarity with common 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
Select an available course date
- Format Online
- Language Polish
- Course Public course, guaranteed date
- Start Date 2026-11-16
- Duration 2 days (14 hours)
BOOK - 650 EUR
Net price per participant
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.
