Search our courses

Course Duration: 2 days


It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Introduction, or have equivalent experience.  It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing Data and a basic understanding of PivotTables.

Subject Areas:

  • Implementing Row Based security
  • Using the Power BI service
    • Creating workspaces / Apps / content packs
    • The difference between a workspace and app and when to use
    • Managing permissions
    • Scheduling auto refresh
  • Conditional Formatting (text & numbers)
  • Drill downs (single visual / cross page)
  • Creating dynamic themes / titles
    • Using JSON files & Dax / slicers to create dynamic titles)
  • Using bookmarks
  • Import & Direct query and when to use
  • Time intelligence (4 week calendar)
  • Comparing historical periodical data using Sales data focussing on trends & forecasts
  • Creating effective tooltips
  • Data modelling
    • Setting up a Schema
    • Getting around common problems (e.g. creating a dataset of single values)
  • DAX aggregates
  • DAX logics
  • Measures & new columns
    • Emphasise on when to use a measure / calculated column
  • Creating variables within measures & using Return / return if
  • Working with untidy data
  • Key influencers / decomposition tree analytics tools
  • M query exposure – creating a 4-week calendar in Dax & M