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 its components.
- Grasping the concepts of queries and their applied steps.
- Exploring the integration capabilities with Power BI and Excel.
Establishing Data Connections
- Importing data from Excel, CSV, and plain text files.
- Handling data from folders and structured datasets.
- Connecting to web-based sources and database systems.
Core Data Cleaning Techniques
- Addressing errors and eliminating duplicate records.
- Applying filters, sorting orders, and reshaping data structures.
- Strategies for managing missing or null values.
Data Transformation and Structuring
- Techniques for splitting columns and merging data fields.
- Utilizing pivot and unpivot operations for analysis.
- Grouping records and calculating aggregate values.
Integrating Multiple Queries
- Understanding the differences between appending and merging queries.
- Selecting appropriate join types and considering data structure impacts.
- Constructing models from diverse data sources.
Fundamentals of the M Language
- Interpreting M formulas and their syntax.
- Modifying query logic through the Advanced Editor.
- Developing custom transformation scripts.
Automation and Data Refresh Strategies
- Designing reusable workflows for consistent transformations.
- Setting up schedules for automated data refreshes.
- Optimizing query performance and managing dependencies.
Advanced Power Query Applications
- Implementing parameters to make queries dynamic.
- Leveraging functions within the M language for complex logic.
- Adhering to best practices for building scalable transformation pipelines.
Conclusion and Future Learning Paths
Requirements
- A foundational understanding of data management using spreadsheets.
- Prior experience with fundamental data analysis activities.
- Familiarity with standard file formats, including CSV and Excel.
Intended Audience
- Data specialists tasked with cleansing and preparing datasets for analysis.
- Business analysts who manage recurring data processing workflows.
- Professionals 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
engagement with the attendees
