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
Introduction to Power Query
- Overview of the Power Query user interface
- Concepts of queries and applied steps
- Exploring integrations with Power BI and Excel
Establishing Connections to Data Sources
- Importing data from Excel, CSV, and text files
- Handling folders and structured data collections
- Connecting to web-based and database sources
Fundamentals of Data Cleaning
- Eliminating errors and duplicate entries
- Techniques for filtering, sorting, and reshaping data
- Strategies for managing missing values
Advanced Transformations and Data Shaping
- Techniques for splitting and merging columns
- Processes for pivoting and unpivoting data
- Grouping records and applying aggregations
Integrating Multiple Queries
- Differentiating between appending and merging queries
- Considerations regarding join types and data structures
- Building models from multiple data sources
Getting Started with the M Language
- Understanding the syntax of M formulas
- Utilizing the Advanced Editor to modify queries
- Creating custom transformation logic
Automation and Data Refreshing
- 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 scalable transformation pipelines
Conclusion and Future Directions
Requirements
- A foundational understanding of spreadsheet-based data management.
- Practical experience with fundamental data analysis operations.
- Familiarity with standard file formats, including CSV and Excel.
Target Audience
- Data specialists tasked with cleansing and preparing datasets.
- Business analysts managing routine data workflows.
- Professionals engaged in data reporting and process automation initiatives.
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
