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 user interface
- Grasping the concept of queries and applied steps
- Understanding integrations within Power BI and Excel
Linking to Data Sources
- Importing data from Excel, CSV, and text files
- Handling folders and structured data collections
- Establishing connections to online services and databases
Core Data Cleaning Principles
- Eliminating errors and duplicate records
- Filtering, sorting, and reshaping data structures
- Managing instances of missing values
Data Transformation and Shaping
- Techniques for splitting and combining columns
- Utilizing pivot and unpivot functions
- Grouping data and performing aggregations
Integrating Multiple Queries
- Differentiating between appending and merging queries
- Selecting appropriate join types and considering data structures
- Building models from multiple data sources
Fundamentals of the M Language
- Interpreting M language formulas
- Modifying queries via the Advanced Editor
- Crafting custom transformation logic
Automation and Data Refresh
- Designing reusable transformation workflows
- Setting up automated refresh schedules
- Optimizing query dependencies and performance
Advanced Methodologies
- Implementing query parameters for flexibility
- Employing functions within M language code
- Applying best practices for scalable transformation pipelines
Recap and Path Forward
Requirements
- Foundational knowledge of spreadsheet-based data management
- Practical experience with fundamental data analysis activities
- Familiarity with standard file formats, including CSV and Excel workbooks
Target Audience
- Data professionals tasked with cleaning and preparing complex datasets
- Business analysts managing recurring data processing workflows
- Individuals involved 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
