Power BI Desktop Advanced

Power BI is a suite of business analytics tools to analyse data and share insights. Power BI Desktop transforms your company’s data into rich visuals for you to monitor your business and get answers quickly with rich dashboards available on every device.

Power BI Desktop is required to be installed prior to the course

Duration: 3 Day

Timings: 09:30 – 16:30

Max number of delegates – 8

For more information Tel: Call us on 0800 107 6362 / / 01782 390130 to discuss the course further.

Delivery Method: Onsite or virtual via MS Teams

Target student:

This course is intended for people who want to use all the capabilities of the Power BI platform to build self-serviced business intelligence solutions.  This course should not be delivered to novice Power BI Users.

Students will learn:

  • Power BI Desktop Features
  • Power BI Concepts and Terms
  • Manage Data Visualizations
  • Manage DAX formulas
  • Publish and Share Power BI Reports

Power BI Training

Course Guide:

Module 1: Power BI Desktop Introduction

  • Download Power BI Desktop
  • Overview and Terminology
  • Imports
  • Visualizations
  • Filters and Queries
  • Reports

Module 2: Data Sources

  • Compatible Data Sources
  • Get Data
  • Direct Query vs Import Data
  • Defining Hierarchies based on a single Table
  • Create and Manage Relationships between Tables
  • Use Append Queries
  • Merge Data Tables

Module 3: Visualizations

  • Creating Visualisations
  • Colour Formatting
  • Setting Sort Order
  • Scatter and Bubble Charts
  • Slicers, Timeline Slicers & Sync Slicers
  • Cross Filtering and Highlighting
  • Visual, Page and Report Level Filters
  • Drill Up, Down and Through
  • Hierarchies
  • Reference / Constant Lines
  • Tables, Matrices & Conditional Formatting
  • KPI’s, Cards and Gauges
  • Map Visualizations
  • Custom Visuals
  • Custom Report Themes
  • Grouping and Binning
  • Selection Pane and Bookmarks

Module 4: Querying Data

  • Query Editor
  • Filters and Delimiters
  • Transforms
  • Pivot and Group By
  • Creating Custom Calculated Columns
  • Creating Tables
  • Adding Conditional Columns

Module 5: Data Analysis Expression (DAX)

  • DAX Overview
  • DAX data types and operators
  • Common DAX functions
  • Referencing other tables in DAX
  • Using CALCULATE and RANKX
  • Using RELATED, RELATEDTABLE, LOOKUPVALUE

Lesson 6: Reports and Exports

  • Report Elements and Options
  • Working with Pages
  • Adding Graphics
  • Report Level Filters
  • Report Themes
  • Export Power BI Data to CSV
  • Create a Power BI Template

Module 7: Sharing Content

  • Power BI Service
  • Sharing Dashboards with internal and External users
  • Sharing content with Office 365 groups
  • Using Publish to Web with Dashboards

Module 8: Power BI Workspaces

  • Understanding Workspaces
  • Creating Workspaces
  • Personal vs
  • Workspace Permissions and Roles

Module 9: Power BI App

  • Supported Platforms
  • Creating Dashboards for Mobile devices
  • Accessing Reports and Dashboards from Mobile

Module 10: Gateways

  • Power BI Personal Gateway
  • Working with OneDrive
  • Working with SharePoint Lists

**All of our courses are designed so we can modify and tailor them to your business needs.  The outline for this course is for guidance only.  The course may not run exactly as laid out in the outline as it will be adapted to meet your requirements.

Follow us on Facebook and Twitter to stay up to date with our latest news.

What our clients say

Scott was very approachable, always willing to answer questions and assist where needed

Onsite, Scotland

Scott is clearly an expert with Power BI and associated areas, and was also able to integrate our specific requirements into the training material very well. I appreciated his desire to ensure we were getting what we needed from the 3 days. I came away from the course confident that we could make great improvements to how we deliver Power BI to our customers and excited about how we can benefit from the Power platform internally.

Onsite, Scotland

We are happy to discuss a tailored course if the above does not meet your exact requirements.  Our aim is to deliver the best IT training experience for our clients and make sure we help you reach your business goals.

Contact us now to discuss course dates via email: training@blackbirdcorporate.co.uk or call our office on 0800 107 6362.

We offer both onsite training and online training using Microsoft Teams, so we can meet your organisational needs.

Follow us on Facebook, LinkedIn and Twitter to stay up to date with our latest news.