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
- Grasping the concept of queries and applied steps
- Exploring integration features within Power BI and Excel
Linking to Various Data Sources
- Importing data from Excel, CSV, and text files
- Managing folder structures and organized datasets
- Establishing connections to online services and database repositories
Basics of Data Cleansing
- Eliminating errors and redundant entries
- Applying filters, sorting, and structural adjustments
- Handling null or missing data points
Data Transformation and Reshaping
- Dividing and combining column contents
- Executing pivot and unpivot operations
- Performing grouping and aggregation tasks
Merging Multiple Queries
- Distinguishing between append and merge operations
- Selecting appropriate join types and considering data structures
- Constructing models from multi-source data
Intro to the M Language
- Decoding M formulas and syntax
- Modifying queries via the Advanced Editor
- Developing bespoke transformation rules
Automating Processes and Refreshes
- Building scalable, reusable transformation pipelines
- Setting up automated refresh schedules
- Overseeing query dependencies and optimizing performance
Advanced Methodologies
- Implementing parameters in queries
- Leveraging M functions for complex logic
- Applying best practices for scalable data transformation
Conclusion and Future Directions
Requirements
- A foundational grasp of data management within spreadsheets
- Prior exposure to fundamental data analysis activities
- Knowledge of standard file structures, including CSV and Excel formats
Target Audience
- Data specialists tasked with cleansing and structuring datasets
- Business analysts managing periodic data processes
- Professionals engaged in data reporting and operational automation
Testimonials (2)
The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.
Marcel Tansae - DB Technology
Course - Microsoft Power Automate
How to use relationships in Power BIand the differences between columns and measurements
