Catalog
details
Ajoutez votre titre ici
Ajoutez votre titre ici
POWER BI – LEVEL 2 – DEVELOPMENT
Category
INFORMATION TECHNOLOGY
Subcategory
Data
Code
DAT005
Training Objectives
Model and link multiple data tables. Calculate KPIs using advanced DAX formulas Know and use the most common DAX functions, operators and syntaxes to calculate values
Training Program
Module 1: Introduction to Modelling
Basic concepts of the star model
Basic snowflake model concepts
Basic concepts of the table of facts and the table of dimensions
Modelling
Module 2: Introduction to DAX
Basic DAX concepts
Creating columns calculated via DAX
Establishment of basic measures
Table creation via DAX
Module 3: Advanced calculations with DAX
Line context concept
Iterative functions
Implicit filter context concept and explicit filter
Module 4: Discovery of the usual DAX functions
Optimization of DAX formulas
The most used DAX functions (time DAX, aggregations, filter, logic, etc.)
