sss

Microsoft 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 Get and Transform to learn how to get the most from your data using Microsoft BI.

Microsoft Power BI Advanced course

1.5 Days

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

Download PDF

What will you learn?

At the end of this Microsoft Power BI Advanced course, delegates will be able to:
  • Use advanced relationships to control data
  • Use advanced DAX functions
  • Work with variables, dates and queries
  • Use Visualisations 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
  • Querying with DAX

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

More on Queries

  • Advanced query techniques
  • Introduction to M

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 and other useful reference materials where applicable.  These may be either paper based or in Adobe pdf format or a combination thereof. 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.
“Initial fears that the course would be too advanced were dispelled by the accommodating trainer.  John, HaskoningDHV”Initial fears were quickly dispelled

Additional Information

NOTE:   We only offer the Microsoft Power BI Advanced course on a private in-house basis.

Contact us to discuss your training needs...

0845 108 5481 0845 108 5481
info@enliten-it.com info@enliten-it.com