00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Microsoft Power BI


Power BI is a Microsoft product that allows for the creation of powerful, interactive visualizations using business intelligence. This training course will teach participants how to create highly interactive and sophisticated dashboards using Power BI.

Price: €550 per person


  • Book a place on this course and pay with your credit card.13 January 2020, 1 Day
  • Book a place on this course and pay with your credit card.23 April 2020, 1 Day
  • Book a place on this course and pay with your credit card.02 July 2020, 1 Day
  • Book a place on this course and pay with your credit card.05 October 2020, 1 Day


The Microsoft Power BI training course is aimed at experienced Excel users who wish to use the Power BI interface to create their own reports and dashboards.


No previous knowledge of Microsoft Power BI is required, however, participants should be experienced users of Excel. They should be able to create, edit and manipulate spreadsheets containing formulae and functions. They should also be able to create charts and pivot tables. Ideally they should have completed the Excel Introduction and / or Excel Intermediate training course.


Having completed this course, participants will have a good working knowledge of Power BI which will enable them to create interactive visualizations and business intelligence capabilities within their own organisations.

Course Outline
Click here to download course outline

Introduction to Power BI
Introducing Power BI
The Power BI Analytics Service
Creating a Power BI Dashboard

Using Power BI
Using Excel as a Data Source for Power BI
The Power BI Data Model
Database as Data Source for Power BI
Using the Power BI Analytics Service
Importing Data into Power BI
Getting Data: Excel vs. Power BI Desktop and Service
Data Structure for Q&A
Direct Query vs. Import Data

Shaping and Combining Data
Power BI Desktop Queries
Shaping Data
Combining Data

Modelling Data
Introduction to Modelling
Setup and Manage Relationships
Cardinality and Cross Filtering
Default Summarization and Sort By
Creating Calculated Columns
Creating Measures & Quick Measures
DAX Queries
Calculations and Measurements

Interactive Data Visualizations
Creating Visualizations
Colour Formatting
Setting Sort Order
Scatter & Bubble Charts and Play Axis
Slicers, Timeline Slicers and Sync Slicers
Cross Filtering and Highlighting
Visual, Page and Report Level Filters
Drill Down and Drill Up
Reference Lines and Constant Lines

Power BI Desktop Visualizations
Tables, Matrices and Conditional Formatting
KPIs, Cards and Gauges
Map Visualizations
Custom Visuals
Managing and Arranging
Drill Through
Custom Report Themes
Grouping and Binning
Selection Pane, Bookmarks and Buttons
Managing a Power BI Solution

Publishing and Sharing
Sharing Options Overview
Publish from Power BI Desktop
Publish to Web
Share Dashboard with Power BI Service
Workspaces and Apps (Power BI Pro)
Content Packs (Power BI Pro)
Print or Save as PDF
Row Level Security (Power BI Pro)
Export Data from a Visualization
Publishing for Mobile Apps
Export to PowerPoint

Direct Connectivity
Cloud Data
Connecting to Analysis Services

Developer API
Using the Developer API
Custom Visuals

Power BI Mobile App
Introduction to the Power BI Mobile App
Using the Power BI Mobile App
Power BI Embedded

Course Summary and Review
Recap of Topics Covered
Question Time

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.