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.
Course Outline
Introduction to Power Query
- Overview of the Power Query interface.
- Understanding queries and applied steps.
- Navigating integrations with Power BI and Excel.
Connecting to Data Sources
- Importing Excel, CSV, and text files.
- Working with folders and structured datasets.
- Connecting to online and database sources.
Data Cleaning Fundamentals
- Removing errors and duplicates.
- Filtering, sorting, and shaping data.
- Handling missing values.
Transformations and Data Shaping
- Splitting and merging columns.
- Pivoting and unpivoting.
- Grouping and aggregating data.
Combining Queries
- Append vs. merge queries.
- Join types and data structure considerations.
- Modeling multi-source datasets.
Introduction to M Language
- Understanding M formulas.
- Editing queries using the Advanced Editor.
- Writing custom transformations.
Automation and Refresh
- Creating reusable transformation workflows.
- Configuring refresh schedules.
- Managing dependencies and query performance.
Advanced Techniques
- Parameterizing queries.
- Using functions in M.
- Best practices for scalable transformation pipelines.
Summary and Next Steps
Requirements
- A foundational understanding of spreadsheet-based data work.
- Experience with basic data analysis tasks.
- Familiarity with common file formats such as CSV and Excel.
Audience
- Data professionals tasked with cleaning and preparing datasets.
- Business analysts responsible for recurring data workflows.
- Any individual involved in data reporting and process automation.
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -
