MS Power BI Training - M (Munging) Language 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.
750.-/d
ID : 1144
Goal : The purpose of this short training is to learn the specific M-language elements most requested by practitioners (among the 950 functions) and that can not be done at this date through the classic actions available in the Power Query tabs (both in Microsoft Excel or Microsoft Power PI).
Audience : Anyone who has reached the limits of the capabilities of the classic Power Query interface and the standard actions that are available in it.
Prerequisites : Having completed Microsoft Power Query training for Microsoft Excel or Microsoft Power BI (or equivalent knowledge).
Goals :
- Introduction
- M vs SQL vs DAX (vs dplyr et panda)
- Official documentation
- Number of functions and self-generated percentage
- Discover and customize the editor
- Case sensitive language
- Syntax and grammar of the language
- The six types of classical structures (scalar, table, record, list, parameter, function)
- Structure déclarative
- Define normalized or non-normalized variables
- Create tables with static or dynamic content
- Create tables using sequences
- Create lists
- Access atomic values of attributes
- Use indexes to read lagged data
- Use parameters
- Create functions with optional parameters or not, typed or not
- Create recursive functions
- Create dynamic filters
- Write loops and get to know their pits and falls
- ...
Pedagogical method : This training is based on exercises mainly imposed by the trainer or client files if the data and requests related to it 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 : 750 CHF
Daily price in remote : 360 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 3750 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).
Book
- Title : Notes de cours Power BI
- Author(s) : Vincent Isoz, Daname Kolani
- Pages : 350
- ISBN :
Tags : M language training, training M language, Power Query M language training, Power Query M language course, Power Query training, Power Query course.