Get in Touch
 Duration 14 hours

Course Outline

Introduction to Power Query

  • Overview of the Power Query interface
  • Grasping the concepts of queries and applied steps
  • Navigating integrations with Power BI and Excel

Connecting to Data Sources

  • Importing data from Excel, CSV, and text files
  • Handling folders and structured datasets
  • Establishing connections to online and database sources

Fundamentals of Data Cleaning

  • Eliminating errors and duplicate entries
  • Filtering, sorting, and reshaping data
  • Addressing missing values

Transformations and Data Shaping

  • Splitting and combining columns
  • Performing pivot and unpivot operations
  • Grouping and aggregating information

Combining Queries

  • Differentiating between append and merge queries
  • Considering join types and data structure implications
  • Modelling datasets from multiple sources

Introduction to the M Language

  • Understanding M formulas
  • Editing queries via the Advanced Editor
  • Writing custom transformation logic

Automation and Refresh

  • Creating reusable workflows for transformation
  • Setting up refresh schedules
  • Managing dependencies and optimising query performance

Advanced Techniques

  • Parameterising queries
  • Utilising functions within M
  • Best practices for building scalable transformation pipelines

Summary and Future Steps

Requirements

  • A foundational understanding of data handling in spreadsheet applications
  • Practical experience with basic data analysis tasks
  • Familiarity with standard file formats, including CSV and Excel

Target Audience

  • Data professionals responsible for cleaning and preparing datasets
  • Business analysts managing recurring data workflows
  • Individuals involved in data reporting and process automation

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.
Investment

Price per private group, online live training, starting from 2900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (2)

Upcoming Courses

Related Categories