Description

Expand your Power BI knowledge and take your reports to the next level.

Course overview

Duration: 1 day (6.5 hours)

This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures.

Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports.

Objectives

By the end of the course you will be able to:

Import and connect data tables

Create and use date calendars

Create calculated columns

Create and use measures

Use drill down and drill through

Create Tooltip pages

Add and customise slicers

Add action buttons

Streamline your report for use in the Power BI Service

Content

Review of importing and loading data

Importing data

Transforming data

Adding custom columns

Creating data models

Building visuals

Creating date calendars

Building date tables

Creating Financial Year information

Including Month and Day information

Creating calculated columns

Power Query custom columns vs DAX columns

Creating DAX calculated columns

Creating measures

Implicit vs Explicit Measures

Building measures

Using DAX

Common DAX functions

Drill Down vs Drill Through

Review of drill down

Creating drill through pages

Using drill through

Creating ToolTips Pages

Adding pages to use for Tooltips

Linking ToolTip pages to visuals

Using action buttons

Adding images

Adding buttons

Setting actions

Working with slicers

Adding slicers

Changing slicer settings

Syncing slicers between pages

Showing what has been sliced

Setting slicer interactions

Techniques in the Power BI Service

Hiding the navigation bar

Stopping users manually filtering

Course Images

Power BI Advanced Reporting

By Underscore Group

Booking options

Highlights

Description

About The Provider

Tags

Reviews