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 concept of queries and applied steps
- Navigating integrations with Power BI and Excel
Connecting to Data Sources
- Importing Excel, CSV, and text files
- Managing folders and structured datasets
- Connecting to online and database sources
Data Cleaning Fundamentals
- Eliminating errors and duplicates
- Filtering, sorting, and reshaping data
- Handling missing values
Transformations and Data Shaping
- Splitting and merging columns
- Pivoting and unpivoting data
- Grouping and aggregating information
Combining Queries
- Differences between appending and merging queries
- Join types and considerations for data structure
- Modeling datasets from multiple sources
Introduction to M Language
- Understanding M formulas
- Editing queries via the Advanced Editor
- Creating custom transformations
Automation and Refresh
- Building reusable transformation workflows
- Setting up refresh schedules
- Managing dependencies and query performance
Advanced Techniques
- Parameterizing queries
- Applying functions in M
- Best practices for scalable transformation pipelines
Summary and Next Steps
Requirements
- A foundational understanding of spreadsheet-based data work
- Experience performing basic data analysis tasks
- Familiarity with standard file formats such as 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
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
engagement with the attendees
