This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     

Introduction to Power BI

29th January 2018 - 31st January 2018

Who is it for?

A three-day course aimed at anyone who is interested in building reports and dashboards in Power BI, including BI developers, existing Power Pivot users, analysts and report writers.

What you will learn

This course will cover building reports and dashboards in Power BI Desktop, Excel 2013/2016 and in the browser at

The agenda is:

Day 1

  • What is Power BI? A high-level description of the service and how you use it
  • Loading data: connecting to data sources using the Query Editor
  • Loading data: using the built-in transformations
  • Loading data: advanced topics including the M language, privacy levels, parameters and functions

Day 2

  • Modelling data: tables and relationships
  • Modelling data: introduction to DAX
  • Modelling data: DAX row context and filter context, and the Calculate() function
  • Modelling data: implementing common calculations in DAX, including date calculations

Day 3

  • Building reports and dashboards in Power BI Desktop and Power
  • Building reports in Excel 2013/2016 using PivotTables, cube formulas and Analyze In Excel
  • Sharing, collaboration using apps and applying security
  • Configuring and scheduling refresh of data
  • Power BI Premium, administration and auditing

The course will include several hands-on labs. Attendees should bring along a laptop with Power BI Desktop and Excel 2013 or 2016 installed and should also have a Power BI subscription.

Key Benefits

The goal of the course is to teach you how to load data from multiple data sources, clean it and model it appropriately, and create simple DAX calculations, so you can build the reports and dashboards you need in Power BI.

Cost: £949 until December 31 2017, £1049 after that +VAT


Chris Webb is the owner of Crossjoin Consulting, and is a consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", and blogs at



CCT Barbican
Aldersgate House, 135-137 Aldersgate Street, EC1A 4JA

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration decoration decoration decoration