Formation MS Office Excel - DAX (Data Analysis Expression) 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 : 1075
Goal : Indeep the PowerPivot and Power BI courses by addressing the 120 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 to 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 excel dax training, dax training, dax course, powerpivot training, powerpivot course, power bi dax, powerpivot dax, data analysis expressions, time intelligence functions, DAX queries.