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
Overview of Power Query
- Familiarization with the Power Query interface
- Grasping the mechanics of queries and applied steps
- Exploring integrations with Power BI and Excel
Establishing Data Source Connections
- Importing data from Excel, CSV, and text files
- Managing folders and structured datasets
- Linking to online services and database platforms
Basics of Data Cleaning
- Eliminating errors and duplicate entries
- Filtering, sorting, and restructuring data
- Addressing missing values effectively
Data Transformation and Shaping
- Techniques for splitting and combining columns
- Utilizing pivot and unpivot operations
- Grouping data and performing aggregations
Integrating Multiple Queries
- Distinction between appending and merging queries
- Considerations for join types and data architecture
- Building models from diverse data sources
Getting Started with M Language
- Understanding M formulas and syntax
- Modifying queries via the Advanced Editor
- Developing custom transformation logic
Automation and Refresh Cycles
- Building reusable transformation workflows
- Setting up automated refresh schedules
- Optimizing query performance and managing dependencies
Advanced Methodologies
- Implementing parameters in queries
- Leveraging functions within the M language
- Best practices for designing scalable transformation pipelines
Wrap-up and Future Directions
Requirements
- A foundational grasp of spreadsheet-based data management
- Prior experience with basic data analysis activities
- Knowledge of standard file formats, including CSV and Excel
Target Audience
- Data professionals focused on cleaning and preparing datasets for analysis
- Business analysts managing recurring data processing workflows
- Individuals involved in data reporting and the automation of business processes
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.
