Data Modelling in Power BI & Data Analysis Expressions (DAX)
- Adquirir conhecimentos da linguagem/sintaxe DAX;
- Escrever fórmulas DAX.
- Definir tabelas e colunas calculadas;
- Definir medidas;
- Utilizar funções de iterador DAX;
- Modificar o contexto do filtro;
- Utilizar funções de inteligência de tempo DAX.
Data Modeling in Power BI – Overview
- Data modeling overview
- Normalization and denormalization
- Star schemas
- Why data modeling is useful
- Data modeling scenarios
Introduction to DAX
- What is DAX?
- Calculated Columns
- Measures
- Aggregation Functions
- Using Variables
Table Functions
- Table Functions
- Calculated Tables
- Filtering a Table
- Removing Filters
- Mixing Filters
- DISTINCT
- RELATEDTABLE
Evaluation Contexts
- What is an Evaluation Context?
- Example of a Filter Context
- Row Context
- There are Always Two Contexts
CALCULATE
- What is CALCULATE?
- Filters are Tables
Evaluation Contexts and Relationships
- Filters and Relationships
- Row Context – Many Tables
- Filter Context – Many Tables
- Context Transition
Time Intelligence in DAX
- Date Table
- What is Time Intelligence?
12h
Quer saber mais informações?
