MS Power BI Advanced – Create Performance Measures with DAX

Course Times

• 9am to 4pm

Course Content

Learning Outcomes

• Understand some of the options for data model schemas and table structures.
• Understand how to work with different relationship types, including active and inactive, and how filter propagation works.
• Understand and gain skills in incorporating disconnected table at higher levels (like budgets) and additional data tables into the model.
• Understand DAX, the types of calculations available and its contexts, as well as gaining experience in writing DAX and formatting for easier readability and future modification.
• Practical skills in using core DAX functions to create a range of typical, real-world performance measures.
• Understanding of the main DAX ‘time intelligence’ functions and gaining skills in writing typical and custom time intelligence functions.

Course Prerequisites

This is a technical course and requires extensive use of excel-like functions. You will require the following prerequisite knowledge and experience to successfully understand and apply the concepts:

• Have experience in creating visualisations in Power BI.
• Have experience in using Power Query to transform data into models.
• Understand the basic database theory of One-to-Many relationships.
• Have experience in using basic DAX in Power BI to create tables and add columns to tables.
• Have competency in using Excel formulas and functions similar to the level of  Excel Formulas & Functions
  Here’s an example of a formula that you would need to be able to understand:
  IF(A1 > TODAY(), VLOOKUP(A2, SalaryTable, 2, FALSE), IF( A1 = TODAY(), VLOOKUP(A2, SalaryTable, 3, FALSE),  VLOOKUP(A2, SalaryTable, 4, FALSE)))

If you are unsure whether your level of skill is sufficient please contact ATI-Mirage on hello@ati-mirage.com.au or call 9218 9059.