Power BI - Beyond the Basics training course

Maximise Power BI's features to create outstanding Visuals and complex Calculations in DAX

Next 30 June (Remote)
3 days £1,750.00 + VAT

JBI training course London UK

  • Learn to apply DAX functions to build formulae and expressions in Power BI
  • Leverage Dax Studio to write, execute and analyse DAX queries in Power BI Designer
  • Explore Power BI's functionality to produce stunning advanced visuals
  • Maximise Power BI's features to create complex calculations in DAX
  • Use advanced visualisation tools to create navigation buttons, bookmarks and presentations 
  • Build an Example Time Intelligence Report
  • Learn how Power Query helps you connect to one or many data sources, and shape and transform the data
  • Code in M language to connect to various different data sources and mash them up
  • Use Power BI Administration to  control and monitor self-service, processes and policies


This advanced training course for Microsoft Power BI is aimed at Power BI users who want to get even more out of this popular tool.

We will show you how to use Power BI's functionality to produce stunning visuals, and how to use DAX to create complex calculations that will allow you flexibility beyond that offered by the standard toolset.

A number of optional topics exist which can be requested for private courses, depending on your organisation's business requirements.

JBI training course London UK
JBI training course London UK

Business Analysts, Financial Analysts, Data Scientists and Staff who already use Power BI or who have attended our introduction course and who need to explore its features in more depth. Developers and Super Users/ Power Users looking to get more out of Power BI

Learn to build Dashboards like this - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...

Note : This course requires delgates to run Power BI Desktop. Mac users must make arrangements to use a PC



Related Courses


  • Commonly Used DAX Functions
  • Sum, Average, Count, DistinctCount
  • Create a measure table
  • Copying and Moving Measures
  • Use Variables in calculation
  • Different granularity: calculate allocated weight
  • Filter context
  • Evaluation Contexts and Relationships
  • Understand the use of CALCULATE
  • Table Functions: ALL, ALLEXCEPT, FILTER
  • Table Functions: DISTINCT, VALUES
  • Advanced Evaluation Context DAX  
  • Context transition
  • Iterator -> nested row context
  • Row context and Totals
  • Row context and cumulative total
  • Time Intelligence prerequisites
  • Time intelligence functions MTD, QTD, YTD, SamePeriodLastYear
  • Rolling totals for different periods
  • IF, HasOneValue
  • Using a Safe Divide Function
  • Using the Blank() Function
  • Build an Example Time Intelligence Report
  • Creating Dynamic titles
  • Using parameter table
  • What is scenarios
  • Dax as a query language
  • Capturing and debugging queries with Dax Studio
  • Power BI referencing

Advanced visualization

  • Moving away from 1 Dimensional Story-telling
  • Adding navigation with Buttons and Bookmarks
  • Create a presentation using bookmarks
  • Using Focus Mode
  • Selection Pane
  • Creating Drill-Through Reports
  • Use of Custom Visuals
  • Custom Themes
  • Building Reports using Q&A

Advanced visual (Cont...)

  • Optimizing Report Slicers
  • Filtering Reports by Relative Dates
  • Multiple pages slicers
  • Types of Slicers and Filters
  • Filter Pane
  • Customizing Report Visual Interactivity
  • Cross Highlighting or Cross Filtering
  • Choosing Visuals Based on Context
  • Using Custom Visuals
  • Creating amazing reports with Layouts
  • Conditional Colour formatting
  • Adding & Optimizing Tool Tips
  • Using the Format Painter
  • Visual Alignment Tips
  • Custom Page Sizing and Tooltip page
  • Using Logos & Custom Icons
  • Making Enhancements with Shapes and Lines
  • Formatting Tips & Tricks
  • Best Practice Guidelines and Development Tips
  • Removing or Hiding Data Model Redundancies
  • Optimizing Waterfall Charts
  • Getting Value from Scatter, Ribbon & Bullet Charts
  • Use R and Python in Power BI visuals

Advanced Modelling

  • Many-to-Many relationship
  • Cross filtering
  • Cross Filtering with CALCULATE
  • Cross Filtering and Time intelligence
  • Role Playing Dimensions
  • Creating  a ordered vs shipped date table
  • UseRelationship function

Advanced Power Query

  • Merge and Append queries
  • Create a blank Query
  • Create a custom table
  • Enter data manually
  • Create a table using M coding
  • Conditional column
  • Multi-condition column
  • Columns from example

M Language

  • The M Syntax
  • M language reference table
  • M Query Basics
  • Variables and Parameters
  • Parametrize data source
  • Create M Query Functions
  • Invoke functions
  • Automate import using M function
  • Create date table using M

Power BI Administration

  • Data Refresh When, Who, What
  • Gateway : overview, installation, when needed
  • Which connection require a Gateway and which do not
  • Scheduling Data Refresh
  • Data refresh and licencing
  • Gateway: personal mode and Enterprise mode
  • Gateway: prerequisites
  • Gateway installation
  • Gateway Configuration
  • Gateway and direct query
  • What Gateway do
  • Security
  • Data at rest
  • Data in Use
  • Data in Transit
  • Security Users access
  • Implementing Row Level Security
  • Implementing Dynamic Security
  • Administration portal
  • Usage metrics
  • Users administration
  • Tenant settings
  • Embedded code
  • Manage custom visuals
  • Global administrator
  • Manage user licence
  • Manage Group and workspaces
  • Audit logs
Course Updates & Newsletter

Receive the latest version of this course by email & subscribe to our Newsletter

+44 (0)20 8446 7555



Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address 1345 High Road, London, N20 9HR