iTrain Scotland IT Training Edinburgh image
 
Home > Courses > Microsoft courses > Microsoft Power BI Level 2

Microsoft Power BI Level 2

You will learn how to mine and expose hidden information with the DAX language. Common business scenarios are covered, highlighting useful DAX patterns that can be implemented and adapted to solve a variety of simple and complex calculations. There is an emphasis on practical applications of DAX to enable delegates to be productive right from the word go after attending this course.

You will find that this is a comprehensive course for this level, with plenty of illustrated examples and augmented with practical hands-on exercises.

This course is aimed at existing users of Power BI, or those who have attended our Power BI Desktop Level 1 course and who need to take their data analysis skills to the next level.

No previous knowledge of DAX is assumed.

Upon successful completion of this course, students will be able to:

  • Create and use calculated columns
  • Create and use measures
  • Understand the key concepts of tabular data modelling
  • Understand evaluation contexts
  • Work with the CALCULATE function
  • Work with the FILTER function
  • Work with date functions
  • Understand time intelligence in DAX
  • Make decisions in DAX expressions
  • Understand iterator functions
  • Work with complex table relationships
  • Create and use custom calendars
  • Create and use DAX variables
  • Gracefully handle errors in DAX

Introduction to DAX

  • Course Overview
  • Introducing the DAX Expression Language

Calculated Columns

  • Adding Calculated Columns
  • Properties of Calculated Columns

DAX Measures

  • Adding Measures
  • Formatting DAX Code
  • Measures that Use Other Measures
  • Benefits of Measures

Data Modelling 101

  • Tabular Data Modelling Concepts
  • Table Relationships
  • Filters Across Multiple Tables
  • Active & Inactive Relationships

The CALCULATE Function

  • Using the CALCULATE Function
  • Evaluation Context
  • Filter Operators
  • Modifying the Filter Context

The FILTER Function

  • When Should You Use FILTER?
  • Using the FILTER Function

Working with Dates and Time Intelligence

  • Date Functions in DAX
  • Introduction to Time Intelligence
  • Creating a Date Table
  • Time Intelligence Functions
  • Working with Weeks

Conditional and Branching Logic

  • Using the IF Function
  • Checking for the Existence of Data
  • The VALUES Function

Iterator Functions

  • The Purpose of Iterator Functions
  • The SUMX Function
  • Other Aggregate Iterator Functions
  • Understanding Semi-Additive Calculations

Complex Table Relationships

  • Multiple Relationships Between the Same Two Tables
  • The USERELATIONSHIP Function
  • Disconnected Tables

Custom Date Tables

  • Introducing Custom Date Tables
  • Creating Measures to Work with Custom Calendars

Enhanced DAX Functionality

  • Ranking Data
  • Using DAX Variables
  • Handling Errors in DAX
Prices below are for scheduled courses held in our Edinburgh Training Centre. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.
Group discount
1 place £ 790 n/a
2 places £ 1580 n/a
3 places £ 2370 £ 2170
4 places £ 3160 £ 2670
5 places £ 3950 £ 3170
6 places £ 4740 £ 3670
7 places £ 5530 £ 4170
8 places £ 6320 £ 4670