Formation MS Office Excel - Microsoft OneDrive

 1,338 total views,  2 views today

Formation MS Office Excel - Microsoft OneDrive 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.

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
  • ISTEXT information function to identify whether the returned value is a string

Pedagogical method : A certificate will be awarded to each participant who has attended at least 80% of the training.

Suggested duration (days) : 5

Daily price : 950 CHF
Price per day per trainee without course material, without certificate, without evaluation, without training room or computer

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.