Microsoft Power BI Advanced

The Power BI Advanced Live Online Course focuses on building your knowledge and understanding of the DAX language, as well as the Power Query M language. Gain insight into context, and what is the right context to build the visuals in your reports. Extend your knowledge of available visuals, and how to make them more compelling and meaningful.

1 day course
What you will learn:
  • Advanced Data Refreshing
  • Advanced Report features
  • Advanced Power Query M Language
  • Time Intelligence Functions
  • Advanced DAX
  • Advanced Data Source Relationships
  • Installing Custom Visuals
What you'll get:
Courseware and Handouts
Live Recorded Session copy
Capped class sizes
eCertificate
Post Course Support
Download Info Brochure Download Practice Files
Course Prerequisites:

Participants should have high confidence in the topics covered in the Power BI Intermediate course, as this course builds on those foundation topics.

Before Session:

Please ensure you have downloaded the latest version of the software Power BI Desktop for use within the session.We also require a working computer with a microphone and speaker installed, and an up-to-date web browser for this training. For the best experience we recommend downloading the latest Google Chrome browser.

It is also recommended that you have a second screen attached to your computer.  This will allow you to watch the online training session and complete the course activities at the same time.

Looking for In-House training?

Discover our Microsoft Power BI Advanced In-House training course. Can’t find what you are looking for?  Enquire for  training today!

Topics covered in this training course:
  • Understanding what data can be refreshed
  • Understanding gateways
  • Requirements for setting up a gateway
  • Configuring a gateway
  • Drill-through
  • Custom Tooltip pages
  • Grouping and binning
  • Creating a colour theme/template
  • Advanced Query Editor
  • Create a date table in Power Query
  • When to use M and when to use DAX
  • Dynamic date ranges
  • DATEADD Function
  • SAMEPERIODLASTYEAR Function
  • PARALLELPERIOD Function
  • Measures table
  • Understanding row/filter context
  • COMBINED function
  • RANKX Function
  • FILTER Function
  • CROSSFILTER Function
  • RELATED Function
  • LOOKUP Function
  • DAX Text Functions
  • Using variables in DAX Functions
  • Bridging tables
  • Handling bad data relationships
  • Aster plot
  • Sankey plot
  • Radar chart
  • Requirements to make custom visuals
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
You might be interested in:
Microsoft Excel Advanced
This Live Online Course exposes many advanced features of Excel including protecting your workbooks and restricting data entry, building calculations using advanced functions and how to import, clean up, and analyse data sets.
1 day course
from
$340
Microsoft PowerPoint Advanced
This Live Online Course is ideal for the Microsoft PowerPoint 2016 “power user” who would like to acquire more advanced skills in manipulating data and objects in PowerPoint. 
1 day course
from
$340