Power Query

Formation MS Office Excel - Power Query in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

850.-/d

ID : 1076

Goal : The objective of this training is to acquire the necessary knowledge in Power Query to process, clean or link large amounts of data from different sources for post-analysis in the spreadsheet software as a table or in the PowerPivot model. The trainer will also introduce most common business cases that makes problems to Power Query users in MS Excel or MS Power BI. This training also prepares the attendee for the Power BI 70-778 certification and for the Power BI Desktop and M language training.

Audience : This training is mainly for marketing, advertising, logistics or actuarial analysts or any other profile that has to do simple statistical analysis or controlling in their job and wishing to avoid creating formulas (especially VLOOKUP, XLOOKUP and MATCH/INDEX) or macros with a spreadsheet software.

Prerequisites : Have a good knowledge of relational databases theory and a very strong experience of using formulas in Microsoft Excel.

Goals :

- Introduction

- What is an ETL?

- Recommended Technical Configuration

- Differences Power Query Excel 365 and Power Query Excel Standalone

- Presentation and customization of the user interface (recover the steps pane)

- Version check and update

- Browse the Help register

- Reminders on Leszinsky-Reddick naming convention

- Enter data manually

- Delete authentification data

- Types of data sources for Power Query (text files, spreadsheets, relational database, internet, etc.)

- Importing external Microsoft Excel tables (and related traps)

- Create importation groups

- Choose columns to import

- Load and save a query in a table

- Change Power Query default behavior

- Load and save a query in a connection

- Delete a query

- Import a * .csv or * .xlsx file folder

- Identify and Manage errors

- ...

Pedagogical method : This training is based on exercises mainly imposed by the trainer or on the client files if the data and requests have already been sent at least two days before the training.

Suggested duration for presentiel training (days) : 2

Suggested duration for on-line training (days) : 2.4

Daily price in face-to-face : 850 CHF

Daily price in remote : 408 CHF

Daily price in remote for students : contact us (only if student card!)

Daily price in remote (with recording) : 4250 CHF

Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Tags : microsoft excel power query, power query course, power query training, excel power query, m language.

Contents