Microsoft-Power BI Desktop-Level 2

Level - Advanced
This course builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions. 

New program!
Location
Date
Duration

1 Day

Time (AWST)
Address
Participants
Total

Overview

This course introduces more advanced DAX (Data Analysis Expressions) concepts including variables, takes a deeper look at how functions are evaluated, analyses data over time using Time-Intelligence Functions and introduces more advanced visualisations concepts.

Skill level

This course is designed for those who are ready to explore more of the advanced functions of Power BI. While there are no prerequisites the course assumes an intermediate level understanding of Power BI, gained through formal training or hands-on experience.

Content

  • Learn how to build complex DAX formulas using variable and advanced functions
  • Gain an understanding of how functions are evaluated
  • Create formulas to analyse data over period of time using Time-Intelligence Functions 
  • Learn how to create dynamic visualisations using report themes, conditional formatting and KPI's.

Learning Outcomes

Participants should be able to:

  • Build complex DAX formulas using variable and advanced functions
  • Explain how functions are evaluated
  • Create formulas to analyse data over a period of time using Time-Intelligence functions
  • Build dynamic, striking visualisations.
Related Results

Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.

Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.

Level - Advanced
Working with long documents in Microsoft Word can be a challenge. We will show you how to format documents quickly and consistently, how to add numbered headings, create a table of contents, an index, table or figure captions and cross-references. 

Level - Intermediate
Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs