The Power Query training introduces you to the ETL tool integrated in Excel that automates data collection, cleaning and transformation. Over a full day, you master the Power Query editor, common transformations, source combinations and automatic refresh. A strategic skill for data analysts and management controllers in French speaking Switzerland.
Automate data preparation and save hours on each refresh
For data analysts in French speaking Switzerland, Power Query has become a pivotal tool in daily work. This Power Query training focuses on hands on cases: multi-source import, automated cleaning, table merging, parameterizable queries.
Module 1: Theory – relational databases
Module 2: PowerQuery
Power Query is probably the most powerful Excel feature of the last ten years, yet the least known. Natively integrated in Excel since 2016, it turns the tool into a true ETL platform: connection to external sources, transformations recorded as a replayable pipeline, automatic refresh.
The training starts with hands on use of the Power Query editor integrated in Excel. You discover its logic: import a source, apply a sequence of recorded transformations, load the result in an Excel sheet or data model.
Power Query connects Excel to a multitude of sources: CSV and Excel files, entire folders, SQL databases, web services, SharePoint, JSON. The training details the most common imports.
The heart of the training is mastering Power Query transformations. Filter rows, remove duplicates, split or merge columns, change data types, handle errors, unpivot or pivot.
Merge and append are key operations: merge two tables on a common key (XLOOKUP equivalent on steroids), concatenate multiple similar tables (e.g. monthly sales of all branches) into one.
The training ends with creating parameterizable Power Query queries. You learn to expose a parameter that can be changed without touching the query logic.
The Power Query training is designed for management controllers, analysts, data analysts, reporting managers and self employed professionals.
In ITTA premises in Carouge and Le Flon, this Power Query training runs over one day led by an expert instructor in a reduced group for personalized support.
What is Power Query?
Power Query is an ETL tool integrated in Excel that automates import, transformation and loading of data.
Is Power Query included in Microsoft 365?
Yes, Power Query is included in Excel 365 and all Excel 2016+ versions.
Do I need to know SQL to use Power Query?
No, the graphical Power Query interface allows everything without coding.
What is the difference between Power Query and VBA?
VBA is a programming language to automate Excel. Power Query is a graphical ETL tool.
Is this training accessible from Lausanne?
Yes, at the ITTA center in Carouge in Geneva, at Le Flon in Lausanne and in a virtual classroom.
How long to be comfortable with Power Query?
The basics are acquired in a structured day.
Which course should follow this Power Query training?
The Mastering M Language course to go far beyond the graphical interface.
Analyst, controlling, BI, operations profiles needing to consolidate and prepare data from multiple sources (files, databases, web) for analysis. In Geneva and Lausanne, the course welcomes participants from international organizations, banking, consulting and growing SMEs. No specific prerequisite is required other than a concrete willingness to progress on the subject.
You leave with an operational mastery of the fundamentals, reusable canvases on your concrete cases, a structured action plan for the weeks that follow. Many participants report a visible effect from the first week back, with sustainable anchoring over four to six weeks of regular practice. The course combines short theory inputs, practical exercises on your real situations and personalized trainer debrief.
An analyst automatically consolidating 30 monthly Excel files into a clean dataset. A controller connecting Excel to a database and refreshing analyses in one click. An operational person transforming web data into exploitable dataset without code. The course adapts exercises to your context with personalized trainer feedback, and each participant leaves with an action plan calibrated to their own situation.
This training combines well with Excel Pivot tables for analysis, Excel Dashboards for reporting, and M language to go further. Many participants enroll in one of these courses in the following trimester, according to their current priority and professional context.
PowerQuery has transformed Excel into a real data preparation platform, applicable in almost all analytical functions. Connection (200+ sources), transformation (300+ operations) and automation features rival specialized ETL tools. This training targets profiles wanting to professionalize their data preparation.
Most participants report a noticeable effect from the first week of return, with deeper anchoring over four to six weeks of regular practice on real files. The course closes with a personalized practice plan calibrated on your professional context, including milestones and review prompts to ensure the techniques become permanent rather than fading after a few weeks.
At ITTA centers in Geneva and Lausanne, this course runs in a small group with an expert trainer and a format alternating concise theory, practical exercises and personalized debrief. Group confidentiality is explicit and held. Each participant arrives with a real case and leaves with an action plan calibrated to their context. The course integrates recent evolutions of the domain (digital tools, hybrid formats, 2025-2026 practices) without losing focus on fundamentals.
Does PowerQuery replace Power BI?
No, complementary: PowerQuery prepares data, Power BI visualizes and shares.
Need to know M to use PowerQuery?
No, graphical interface covers 80% of cases.
Suitable for beginner analysts?
Yes, the course lays PowerQuery fundamentals.
Where do sessions take place?
ITTA has three centers in French speaking Switzerland: in Geneva (Carouge, Route des Jeunes 35), in Lausanne at the Flon (Rue des Cotes de Montbenon 16) and at Lausanne Mon-Repos (Avenue de Mon-repos 24). The training is also available in virtual classroom.
Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00
ITTA
Route des jeunes 35
1227 Carouge, Suisse
Monday to Friday, from 8:30 am to 06:00 pm.
