Excel 2016 Business Intelligence Tools Course

Are you a Power BI Excel user? Are you forever trying to make sense of ever-growing piles of data? Do you need easy, intuitive tools to allow data discovery, visualisations, and collaboration? Excel, always great for analysing data, is now even more powerful with its suite of Power BI tools.

With the Excel 2016 Business Intelligence tools you can give everyone in your organisation a powerful new way to work with data. On this course, learn the skills you need to provide faster data insights to your organisation, including Power Pivot, Queries, 3D Map and Power BI Visualisations.

You can attend this course as a member of the public on one of our set-date public sessions, or you can contact us to book as a private event for your business. We’re flexible on dates and can host at your offices or in our state of the art training rooms in London.

Our 2-day Excel 2016 Business Intelligence Tools Course includes Power Pivot, Queries, 3D Map & Microsoft Power BI Visualisations.

Microsoft Excel 2016 Business Intelligence Tools course outline - duration: 2 days


  • What is PowerPivot for Excel
  • Importing Your Data
  • Creating a PowerPivot Data Model
  • Creating PivotTables with PowerPivot
  • Creating a Date Table
  • Using Slicers to Filter Data
  • Connecting Slicers to more than one PivotTable
  • Using Charts and Slicers to create interactive Dashboards


  • Importing data from various data sources
  • Creating a Query, the Query Editor Window
  • Load to Worksheet and Load to Data Model
  • Remove Duplicate Data in Columns
  • Split and Merge Columns of Data
  • Group data to create summary Queries
  • Merge and Append Queries

3D Map

  • Create a 3D Map and Plot Geographic Data
  • Creating Visualisation; Column, Bubble, Heatmap, Regions
  • Using the 3-D Environment
  • Using Charts with 3D Maps

Microsoft Power BI Visualisations

  • What are Power BI Visualisations
  • Creating a Microsoft Power BI Account
  • Downloading Power BI Desktop
  • Importing data into Power BI
  • Transforming & Cleaning data in Power BI
  • Creating Calculations in Power BI
  • Using DAX
  • Creating Calculated Columns & Calculated Fields
  • Implicit and Explicit Calculated Fields
  • Using DAX aggregate functions in a PowerPivot PivotTable
  • Using CountRows and DistinctCount Functions
  • The difference between evaluations using Row Context and evaluations using Filter Context
  • Advanced DAX functions: SUMX and CALCULATE
  • Time Intelligence Functions
  • Transpose Data to swap Rows and Columns
  • Filling data Down to populate missing values
  • Unpivot Columns: flatten a “cross tab” table
  • Duplicate Columns
  • Creating Custom Columns and Additional Date Columns
  • Working with Applied Steps
  • Importing Data From a Folder
  • Working with Layers and adding Scenes
  • Adding Annotations
  • Visualising Data over Time
  • Playing the Tour
  • Creating a variety of interactive visualisations
  • Publishing visualisations to PowerBI.com
  • Creating Dashboards
  • Sharing your Dashboards

During the course you will learn how to produce Interactive Dashboards as this example embedded below. Click on any element of the Dashboard to filter the entire dashboard by that element.

Speak to a trainer now

0800 0199 746 for any questions about the courses we offer