"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Power BI Introduction DURATION 2 Days

Course Overview

This 2-day course is intended for anyone who is new to designing and implementing self-service Business Intelligence (BI) solutions using Microsoft Power BI Desktop and the Power BI Service. It is ideal for anyone who needs to quickly get up to speed with analysing and reporting on data in Power BI.

Power BI Introduction


2 days



The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.

With the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.

Full course breakdown available – training@jcstraining.com


There are no specific technical prerequisites for this course, but a familiarity with Excel may prove beneficial. The main consideration is to have a basic understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.


Upon successful completion of this course, students will be able to:

  • Understand Key Components of Power BI
  • Load Data from Commonly Used Sources
  • Shape and Transform Datasets
  • Merge and Append Data
  • Parameterise Queries
  • Implement a Data Model
  • Create and Manage Relationships
  • Gain an Understanding of DAX
  • Implement Calculated Columns
  • Implement Measures
  • Implement Time Intelligence
  • Create Reports with Text-Based Visuals
  • Implement Conditional Formatting
  • Create and Implement Charts
  • Implement Gauges and KPIs
  • Implement Maps
  • Implement Slicers
  • Understand the Power BI Web Service
  • Manage Content in Workspaces
  • Publish Reports and Create Dashboards


Part 1: Introduction and Power Query

1. Introducing Power BI

Introducing Power BI Products and Services

Introducing Power BI Desktop

2. Loading Data

Load Data from Text Files

Load Data from Excel Files

Load Data from OneDrive and SharePoint

Review Other Supported Data Sources

3. Transforming Data

Cleanse Data

Shape Datasets

Transform Datasets

Merge and Append Data

Power Query Parameters

Power BI Template Files

Part 2: Data Modelling and DAX

4. Data Modelling

Data Modelling Concepts

Configure Table and Column Properties

Categorise Data

Sorting Columns

Create and Manage Relationships

Understand Filter Propagation

5. The DAX Expression Language

Introducing DAX

Create Calculated Columns

Add Measures to the Data Model

Implicit v Explicit Measures

Quick Measures

Manipulate the Filter Context with CALCULATE

Analyse Data over Time (Time Intelligence)

Part 3: Reports and Visuals

6. Visualising Data

Implement and Format Table and Matrix Visuals

Rename Fields in Visuals

Show Items with no Data

Conditionally Format Visual Content

Use Card Visuals

Implement and Format Charts

Use Tooltips

Implement and Use Hierarchies

Group and Bin Data

Automatically Find Clusters of Data

Animate Scatter Charts

Gauges and KPIs

Implement Maps

Implement Slicers

Cross-Filtering and Cross-Highlighting

Implement Bookmarks

Implement Buttons

Text Boxes, Shapes, and Images

Control the Display of Content

Part 4: Publishing Reports

7. The Power BI Web Service

Introducing the Power BI Web Service

Publish Reports to the Power BI Web Service

Manage and Organise Content in Workspaces

Create and Manage Dashboards

Dashboard Themes