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
Getting Started with Power Query
- Overview of the Power Query interface
- Comprehending queries and the sequence of applied steps
- Exploring integrations with Power BI and Excel
Establishing Data Connections
- Ingesting data from Excel, CSV, and text files
- Managing folders and structured dataset collections
- Linking to online services and database sources
Core Data Cleaning Techniques
- Eliminating errors and duplicate entries
- Applying filters, sorting, and structural shaping to data
- Handling and addressing missing values
Advanced Transformations and Reshaping
- Splitting and merging column contents
- Utilizing pivot and unpivot operations
- Grouping records and calculating aggregates
Integrating Multiple Queries
- Distinguishing between append and merge query strategies
- Selecting appropriate join types and structural considerations
- Constructing models from multi-source datasets
Introduction to the M Language
- Understanding M formula syntax and logic
- Modifying queries through the Advanced Editor
- Developing custom transformation rules
Automation and Data Refresh
- Building reusable transformation workflows
- Setting up automated refresh schedules
- Optimizing query performance and managing dependencies
Advanced Methodologies
- Implementing parameterized queries for flexibility
- Leveraging functions within M for complex logic
- Adopting best practices for scalable data pipelines
Conclusions and Future Directions
Requirements
- A foundational grasp of spreadsheet-based data operations
- Hands-on experience with fundamental data analysis activities
- Basic familiarity with standard file formats, including CSV and Excel
Target Audience
- Data specialists tasked with cleaning and preparing datasets
- Business analysts managing recurring data workflows
- Professionals engaged 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
Method of training.
