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 and layout
- Comprehending queries and the sequence of applied steps
- Exploring the integration points with Power BI and Excel
Establishing Connections to Data Sources
- Importing data from Excel, CSV, and plain text files
- Processing folders and structured dataset collections
- Linking to cloud-based services and database environments
Essentials of Data Cleaning
- Eliminating errors and duplicate entries
- Applying filters, sorting options, and data shaping techniques
- Managing and addressing missing data values
Data Transformation and Shaping Techniques
- Splitting columns and merging fields for better structure
- Utilizing pivoting and unpivoting to reshape data views
- Grouping records and applying aggregation functions
Merging and Appending Queries
- Differentiating between append and merge operations
- Selecting appropriate join types and considering data structures
- Building models that integrate data from multiple sources
Introduction to the M Language
- Interpreting and understanding M formula syntax
- Modifying query logic through the Advanced Editor
- Developing custom transformation rules and logic
Automation and Data Refreshing
- Designing reusable transformation pipelines
- Setting up automated refresh schedules and triggers
- Optimising query performance and managing dependencies
Advanced Power Query Techniques
- Implementing parameters to make queries dynamic
- Leveraging functions within the M language for complex tasks
- Applying best practices for building scalable transformation pipelines
Course Wrap-up and Future Directions
Requirements
- A solid grasp of spreadsheet-based data management
- Prior experience performing fundamental data analysis tasks
- Comfort with standard file formats, including CSV and Excel
Target Audience
- Data specialists responsible for cleansing and preparing datasets for analysis
- Business analysts managing recurring data processing workflows
- Professionals involved in generating data reports and driving 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.
