MODULE 1: GETTING STARTED WITH DAX

LESSON 1: INTRODUCTION TO DAX

• What is DAX?
• Basics of DAX syntax
• Syntax Best Practices
• Common DAX Syntax Best Practices

LESSON 2: CREATING OBJECTS WITH DAX

• Creating a calculated column
• Creating a calculated measure
• Creating a calculated table
• Differences in evaluation context:

LESSON 3: CONTEXT AND RULES OF EVALUATION

• Rules of evaluation

LESSON 4: VARIABLES, COMMENTS, AND TESTING

• Working with variables
• Commenting your code
• Testing your code
• Where to look for help

MODULE 2: PERFORMING BASIC CALCULATIONS

LESSON 1: GETTING STARTED

• Implicit measures
• Adding quick measures
• Working with DAX data types

LESSON 2: WORKING WITH NUMBERS

• Doing basic math

LESSON 3: LOGICAL FUNCTIONS AND OPERATORS

• Using logic in your calculations
• Using the IF() function
• Nested IF()
• Using the SWITCH() function
• Advanced SWITCH()
• Logical operators & functions: ||, OR(), &&, AND(), NOT()

LESSON 4: AGGREGATING AND SUMMARIZING DATA

• Aggregating and summarizing data
• The SUM() function

MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL

LESSON 1: EVALUATION CONTEXT

• Context defined
• A Row Context Example
•  A Filter Context Example

LESSON 2: DIMENSIONAL MODELING

• Data modeling basics
• Introduction to dimensional modeling

LESSON 3: WORKING WITH RELATIONSHIPS

• Relationships and their effect on the evaluation context
• Getting data from other tables using RELATED() and RELATEDTABLE()
• Looking up data without using relationships

LESSON 4: MANIPULATING THE CONTEXT

• Modifying the context using CALCULATE()
• Using CALCULATE() with a filter
• Using more than one CALCULATE() in a single measure
• Using CALCULATE() with ALL() & REMOVEFILTERS()
• Using CALCULATE() with ALLEXCEPT()

MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS

LESSON 1: HANDLING ERRORS

• Types of errors
• Conversion errors
• Arithmetic errors
• Empty or missing values
• Handling errors gracefully
• ISERROR() and IFERROR()

LESSON 2: USING DAX ITERATOR FUNCTIONS

• The DAX Iterator Functions

LESSON 3: USING TABLE MANIPULATION FUNCTIONS

• Table manipulation functions

LESSON 4: TROUBLESHOOTING YOUR CALCULATIONS USING THE PERFORMANCE ANALYZER AND DAX STUDIO

MODULE 5: WORKING WITH TIME

LESSON 1: PERFORMING CALCULATIONS WITH DATE AND TIME DATA

• Performing date calculations
• Date and Time Functions
• Time Intelligence Functions

LESSON 2: USING DATE TABLES IN YOUR DATA MODEL

• Working with date tables
• Generating a date table with the CALENDAR() function

LESSON 3: ADAPTING YOUR MODEL TO TIME-BASED BUSINESS RULES

• Defining custom operating periods

LESSON 4: WORKING WITH TIME INTELLIGENCE

• YTD, QTD, and MTD calculations
• Custom to-date calculations
• Finding year-over-year change
• Finding moving averages

MODULE 6: ENHANCING THE USER EXPERIENCE

LESSON 1: USING DAX TO CUSTOMIZE WHAT THE USER SEES

• Controlling visibility of your measures

LESSON 2: CREATING INTERACTIVE MEASURES WITH WHAT-IF PARAMETERS

• Using What-if parameters

LESSON 3: CONVERTING CONTINUOUS DATA TO CATEGORICAL DATA

• Adding banding

LESSON 4: ADDING ROW-LEVEL SECURITY

• Using DAX to provide row-level security
• Standard Row-Level Security
• Dynamic Row-level Security

Questo corso 55310 – Introduzione a DAX per Power BI è principalmente rivolto ad analisti dati che operano quotidianamente con Power BI.

Al termine di questo corso 55310 – Introduzione a DAX per Power BI, gli allievi saranno in grado di:

• Descrivere la sintassi DAX, i tipi di dati e gli errori;
• Utilizzare DAX per creare colonne calcolate, misure e tabelle;
• Spiegare come i calcoli DAX vengono valutati;
• Configuare e utilizzare la Time Intelligence per eseguire calcoli su orari e date;
• Creare colonne calcolate e misure;
• Utilizzare DAX per migliorare l’esperienza di utilizzo di Power BI;
• Utilizzare DAX Studio per connettersi a un data model di Power BI ed eseguire semplici query.

Sebbene l’esperienza con Power BI Desktop non sia strettamente necessaria per questo corso 55310 – INtroduzione a DAX per Power BI, gli studenti che hanno almeno una certa familiarità con il programma saranno in grado di trarre il massimo vantaggio dalle esercitazioni pratiche.

Lingua utilizzata nel corso/dal docente: Italiano

Il materiale didattico è in lingua inglese

Il corso include:

• documentazione didattica;
• un attestato di frequenza inviato via e-mail una settimana dopo il termine del corso.