Microsoft Power BI Course Outlines

Microsoft Power BI Introduction

Course Duration

One Day

Course Level

Introduction

Course Requirements

An Introduction to Power BI. This takes a look at the core concepts of Power BI and introduces delegates to report and dashboard creation in Power BI. At the end of this course delegates will be able to create basic Power BI reports and Dashboards.

Power BI is a tool that enables data analysts to quickly and effectively produce clear data visualisations for an organisation. It is recommended that delegates have some experience in creating reports by other means before attending this course

Course Contents

Getting Started with Power BI

  • Power BI Concepts and Overview.
  • Introduction to Main Features.
  • Imports.
  • Visualisations.
  • Filters and Queries.
  • Reports.
  • The difference between the Desktop and Online Versions of Power BI.
  • How to determine when to use the desktop and online versions of Power BI.

Creating Data Visualisations

  • Importing and Entering Data from one or more data sources.
  • Creating Relationships in Data.
  • Creating Reports.
  • Overview of Data Visualisations.
  • Creating Charts.
  • Changing Visualisations.
  • Creating Interactive Slicers and filters.
  • Adding Filters.
  • Drilling through data.
  • Applying Data to a map.
  • Introduction to Visualisation Formatting.

Creating Dashboards

  • Creating a Dashboard.
  • Applying Report Visualisations to a Dashboard.
  • Making Dashboards interactive.
  • Sharing Dashboards.

Microsoft Power BI Intermediate

Course Duration

One Day

Course Level

Intermediate

Course Requirements

A one-day Microsoft Power BI training course to further develop the skills of the Power BI worker. The intention of this course is to improve data modelling skills, introduce the DAX Expression language and to look at methods of creating more flexible business intelligence. Delegates must have completed our Introduction to Power BI or be comfortable with the course objectives covered at Introduction level.

Course Contents

Introducing DAX and Computations in Power BI

  • Starter Exercise, Importing Data and Creating a Simple Report.
  • Applying Conditional Formats.
  • Creating Computed Columns.
  • Creating Measures.
  • Grouping Data and Creating Visualisations.
  • Creating KPIs.
  • Creating Conditional Columns.

Modelling Data

  • Using relationships to improve the ability to analyse data.
  • Pivoting and Grouping Data.
  • Creating Conditional Columns.
  • Creating Tables from existing Data.
  • Importing Data via a database query.
  • Exploring DAX further – 3 useful expression templates.

Improving Reports and Outputs

  • Working with multiple report pages.
  • Adding Graphics and drawing elements to Reports.
  • Exporting data to CSV.
  • Exporting data to PowerPoint.
  • Exporting Data to Excel.
  • Creating a Power BI Template.
  • Creating a Power BI App.

Microsoft Power BI Introduction

Course Duration

One Day

Course Level

Introduction

Course Requirements

An Introduction to Power BI. This takes a look at the core concepts of Power BI and introduces delegates to report and dashboard creation in Power BI. At the end of this course delegates will be able to create basic Power BI reports and Dashboards.

Power BI is a tool that enables data analysts to quickly and effectively produce clear data visualisations for an organisation. It is recommended that delegates have some experience in creating reports by other means before attending this course

Course Contents

Getting Started with Power BI

  • Power BI Concepts and Overview.
  • Introduction to Main Features.
  • Imports.
  • Visualisations.
  • Filters and Queries.
  • Reports.
  • The difference between the Desktop and Online Versions of Power BI.
  • How to determine when to use the desktop and online versions of Power BI.

Creating Data Visualisations

  • Importing and Entering Data from one or more data sources.
  • Creating Relationships in Data.
  • Creating Reports.
  • Overview of Data Visualisations.
  • Creating Charts.
  • Changing Visualisations.
  • Creating Interactive Slicers and filters.
  • Adding Filters.
  • Drilling through data.
  • Applying Data to a map.
  • Introduction to Visualisation Formatting.

Creating Dashboards

  • Creating a Dashboard.
  • Applying Report Visualisations to a Dashboard.
  • Making Dashboards interactive.
  • Sharing Dashboards.

Microsoft Power BI Intermediate

Course Duration

One Day

Course Level

Intermediate

Course Requirements

A one-day Microsoft Power BI training course to further develop the skills of the Power BI worker. The intention of this course is to improve data modelling skills, introduce the DAX Expression language and to look at methods of creating more flexible business intelligence. Delegates must have completed our Introduction to Power BI or be comfortable with the course objectives covered at Introduction level.

Course Contents

Introducing DAX and Computations in Power BI

  • Starter Exercise, Importing Data and Creating a Simple Report.
  • Applying Conditional Formats.
  • Creating Computed Columns.
  • Creating Measures.
  • Grouping Data and Creating Visualisations.
  • Creating KPIs.
  • Creating Conditional Columns.

Modelling Data

  • Using relationships to improve the ability to analyse data.
  • Pivoting and Grouping Data.
  • Creating Conditional Columns.
  • Creating Tables from existing Data.
  • Importing Data via a database query.
  • Exploring DAX further – 3 useful expression templates.

Improving Reports and Outputs

  • Working with multiple report pages.
  • Adding Graphics and drawing elements to Reports.
  • Exporting data to CSV.
  • Exporting data to PowerPoint.
  • Exporting Data to Excel.
  • Creating a Power BI Template.
  • Creating a Power BI App.