Microsoft Power BI Training Courses

Use Microsoft’s range of BI (Business Intelligence) tools to analyse data sets quickly, provide visual insights via reports and dashboards and to share that data with colleagues.

Choose from Power BI or Power Query to learn how to get the most from your data using Microsoft BI.

Power BI Desktop Advanced course

1 Day

This Power BI Desktop Advanced course is aimed at experienced Power BI users. The course covers the use of advanced DAX formulas, variables, queries, calendars and delves into the M language behind the Query Editor. Delegates will learn how to customise the data model through advanced visualisations and dashboard tiles.

Download PDF

What will you learn?

At the end of this Microsoft Power BI Desktop Advanced course, delegates will be able to:

Use advanced relationships to control data
Use advanced DAX functions
Work with variables and queries
Use advanced Visualisation techniques to convey data efficiently
Design and deploy Dashboards

Audience?

Business/Data analysts or anyone who needs to interpret and communicate large quantities of information clearly.

Course Contents

Basics Review

DAX basics
Evaluation context

Advanced Relationships

Relationships overview
Advanced relationships options
Cross filter directions
Ambiguity in bidirectional filters
CROSSFILTER function
Many-to-Many relationships

Advanced DAX

Table functions – the differences
- ALL; VALUES; DISTINCT; ALLNONBLANKROW; ALLEXCEPT
FILTER
RELATED, RALATEDTABLE
EARLIER
SUMMARIZE
Understanding context transition: CALCULATE and CALCULATETABLE
LOOKUPVALUE
TOPN
Advanced Time intelligence Functions

Variables

Why use variables?
Understanding variables
Variables scope

Paramaters

Dynamic Calendars

Advanced Visualisations

Digital Storytelling
Buttons and Bookmarks
Selection Pane
Drill through
Tooltip Page
Use of Custom Visuals
Multiple pages slicers

Connecting to other sources

Import vs Direct Query and Live connections – a discussion

Publishing and Sharing

Setting User Role in BI Desktop
Publishing a report
Creating Dashboards
Sharing Dashboards
Creating Workspace
Publish App

Course Materials

Enliten IT will provide each delegate with a workbook, in Adobe pdf format, and other useful reference materials where applicable. Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification. The suggested course duration is a guideline. Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

“Gary was able to tailor the course to suit my needs which was very useful. - Adobe InDesign CS6, Nov 2014. Steven, Kier.”Gary was able to tailor the course to suit my needs which was very useful