MS Power BI Training - DAX (Data Analysis eXpressions) Formulas 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.
950.-/d
ID : 1120
Goal : Indeep the PowerPivot and Power BI courses by addressing the 120 (among 347!) most important functions (formulas) of the DAX formula and query language (Data Analysis eXpressions) to create more complex dynamic Pivot tables with statistical measures or elaborated time intelligence measures, or create DAX queries. This training also prepares the attendee for the Power BI 70-778 certification and for the Power BI Desktop training.
Audience : Business analysts needing to make the PowerPivot native possibilities more complex thanks to DAX.
Prerequisites : Have completed the PowerPivot training or have equivalent knowledge.
Goals :
- Introduction
- Number and category of DAX functions
- Overview of current problematic limitations
- DAX in Models (Column) VS DAX in PVT (Measures)
- Difference between DAX context, DAX context line, DAX context filter and DAX queries
- Converting PowerPivot into cube formulas
- TRIM text function to remove unwanted spaces
- SUBSTITUTE text function to replace characters
- LEFT and FIND text functions to extract a text from the left
- UPPER or LOWER text functions to change the case
- RIGHT, FIND and LEN text functions to extract a text to the right
- CONCATENATE text function to merge texts
- FORMAT text function for rendering texts or numbers
- IF, AND, OR Logical functions for logical tests
- SWITCH and TRUE logical functions to condense IF writing
- IFERROR logic function to handle errors
- YEAR date function to extract the year
- MONTH date function to extract month
- DAY date function to extract the day
- HOUR time function to extract time
- ...
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) : 5
Suggested duration for on-line training (days) : 6
Daily price in face-to-face : 950 CHF
Daily price in remote : 456 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 4750 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 : ms power bi dax training, dax training, dax course, powerpivot training, powerpivot course, power bi dax, powerpivot dax, data analysis expressions, time intelligence functions, DAX queries.