IT Computer Training Courses Edinburgh, Glasgow, Scotland: Microsoft Power BI Level 2 Computer Training: iTrain Scotland: Microsoft Office 2016 Training, Adobe Training, Windows 10 training, Office 2013 training, Computer Courses, Computer training room equipment hire

Classroom with tutor
or
Live virtual classroom

2 Days

Training Options:

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Classroom with tutor
or
Live virtual classroom

2 Days

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

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.

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

Topics

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

Prices below are for scheduled courses held in our Edinburgh Training Centre or Live Virtual Classroom. 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

		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