Microsoft Power BI Training Course Outline

Audience: Microsoft Power BI is a powerful collection of software, apps, and services will help you analyse your organisation’s data and uncover insights and trends. This course will show you how to link and model data in Power BI and create visual reports that reveal data insights. Although the Power BI desktop client will be the primary focus, an introduction to the Power BI web app will also be provided.

Course Duration: 1 Day

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Power BI training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Getting Started

  • What is Power BI?
  • The Building Blocks of Power BI
  • The Power BI Desktop Interface
  • Important Information About Power BI Updates

Working with Power BI Desktop Files

  • Opening Files
  • Saving Files
  • Creating a New File
  • Publishing to the Power BI Web App

Connecting to Data Sources with Power BI Desktop

  • Connecting to an Excel Workbook
  • Connecting to an Access Database
  • Viewing All Connection Options
  • Creating a Manual Dataset
  • Managing Data Sources

Creating a Report with Visualizations

  • Using the Visualizations Pane
  • Using the Fields Pane
  • Creating a Visualization
  • Interacting with Visualizations
  • Changing the Visualization Type
  • Moving and Resizing Visualizations

Doing More with Visualizations

  • Formatting Visualizations
  • Viewing Visualization Data
  • Using Focus Mode and Spotlight 86
  • Removing a Visualization

Working with Data

  • • Transforming and Sanitizing Data
  • • Using Data View
  • • Cleaning Irregularly Formatted Data
  • • Managing Columns
  • • Sorting Table Data

Using the Query Editor

  • Opening the Query Editor
  • The Query Editor Interface
  • Using the Query Settings Pane
  • Using Merge Queries
  • Using Append Queries

 Data Modeling

  • What is DAX?
  • Creating a New Table
  • Creating a New Calculated Column
  • Creating a New Measure

Managing Relationships

  • Using the Relationships View
  • Creating Relationships
  • Editing Relationships
  • Deleting Relationships
  • Using the Manage Relationships Dialog

Working with Reports and Visualizations

  • Managing Report Pages
  • Navigating Through Pages
  • Showing and Hiding Pages
  • Adding Pages
  • Deleting Pages
  • Renaming Pages
  • Changing Page Order

Changing Report View Options

  • Setting Page View Options
  • Customising Your View
  • Using Phone vs. Desktop Layout

Working with Visualizations

  • Understanding Drillthrough Options
  • Changing Category and Summarisation Options
  • Arranging Visualizations
  • Editing Interactions
  • About Custom Visualizations

Adding Static Objects to a Report

  • Inserting Pictures
  • Inserting Text Boxes
  • Inserting Shapes
  • Working with Static Objects
  • A Closer Look at Visualizations

Matrixes, Tables, and Charts

  • Creating a Table
  • Creating a Matrix
  • Overview of Chart Types
  • Creating Charts

Maps

  • Creating a Treemap
  • Creating a Bubble Map
  • Creating a Filled Map

Cards, Gauges, and KPIs

  • Creating a Card
  • Creating a Gauge
  • Creating a KPI

SlicersCreating a Slicer

  • Using Slicers
  • Customising Slicer Display
  • Changing Slicer Mode
  • Changing Slicer Orientation

Introduction to the Power BI Web App

  • Opening the Power BI Web App
  • The Web App Interface
  • Web App Building Blocks
  • Key Differences

Connecting to Data Sources with the Power BI Web App

  • Connecting to Local Data
  • Connecting to Live Data
  • Connecting to Content Packs
  • Connecting to Samples

Connecting to Data Sources with the Power BI App

Using Workspaces, Dashboards, and Reports

  • Viewing and Managing Power BI Content
  • Viewing a Workspace
  • Viewing Dashboards and Reports
  • Managing Reports

Creating Custom Dashboards

  • Creating a Dashboard
  • Pinning Visualizations to a Dashboard
  • Adding Custom Tiles
  • Managing Dashboards
, Microsoft Power Bi Training Course
, Microsoft Power Bi Training Course