Course Description

This course begins by describing the Power BI Desktop model structure and how it can be used in loading and modelling data. It then describes how you can write DAX formulas and the different types of model calculations, including calculated tables, calculated columns, and measures.

Objective

• Explore Data Analysis Expressions (DAX) for Power BI Desktop
• Analyse and apply data modelling in Power BI at work
• Learn the Power BI reporting functions
• Learn the same tools used by top analytics & business intelligence professionals
• Test your skills with hands-on demos & assignments (with step-by-step solutions)

Prerequisites

Participants must already have experience working with Power BI.

Course Outline

Module 1: Loading Data

• Enable Load
• Querying and Aggregating Data
• Advanced Editor
• Close and Apply

Module 2: Data Modelling

• The Importance of a Good Data Model
• Manage Relationships
• Working with Relationships and Cardinality
• Cross-Filter Direction
• Typical Cardinality and Cross Filtering

Module 3: DAX

• Creating Tables Using Formulas
• Applying Conditional Functions
• Working with Disconnected Tables
• Handling Errors
• Working with Variables
• Mathematical Functions
• Relational Functions

Module 4: Report Features

• Bin Data
• Group Data
• Drill Through
• Custom Report Tooltips
• Manually Setting a Report Tooltip
• Add Navigation
• Page Navigator
• Page Navigation Buttons
• Drill-Through Buttons