Microsoft PowerBI Dashboard User Course

overview

This is a bespoke course for specific audiences and is therefore not on our public schedule. This course needs to be customised to the unique settings of a business and will, therefore, be quoted on separately. The possible audience includes the executive team, their personal assistants, divisional heads, line managers, as well as personnel who need to receive alerts on changes in data.

Apply Today

Instructor Led Learning

Duration: 1 Day
Location: Cape Town & Johannesburg
Registration Open Now!

Video Learning

Duration:1 Day
Registration Open Now!

What you will learn

  • Lesson 1 :Overview of Business Intelligence and PowerBI
  • Lesson 2 : Using Data Sources:
  • Lesson 3 :Designing styles and templates
  • Lesson 4 :Accessing Microsoft PowerBI.com web-based application
  • Lesson 5 : Use Built-in Visualizations and Formatting to create Reports
  • Lesson 6 :Interacting with the data
  • Lesson 7 :Dashboards
  • Lesson 8 : Additional visualizations
  • Lesson 9 : Best Practice for Dashboard design
  • Lesson 10: Optional: Data sources and data manipulation

Basic computer skills

Computers made easy course

Introduction to Microsoft Office course

Location for instructor led courses are Cape Town and Johannesburg. We also offer onsite training country wide. T’s and Cs apply. Contact us for more information.

FULL COURSE OUTLINE

Lesson 1: Overview of Business Intelligence and PowerBI

  • Microsoft Self-Service Business Solution
  • Microsoft PowerBI applications

Lesson 2: Using Data Sources:

  • Data Sources available
  • Uploading Excel workbook
  • Uploading CSV file
  • Uploading a Web page containing tables
  • Accessing a SQL Server database

Lesson 3: Designing styles and templates

  • Define a new style
  • Create a template

Lesson 4: Accessing Microsoft PowerBI.com web-based application

  • Login
  • Review the structure of the application
  • Accessing the first dashboards

Lesson 5: Use Built-in Visualizations and Formatting to create Reports

  • Data Structure of the sample database
  • Tables
  • Matrices
  • Cards
  • Multi-level cards
  • Switching between table types
  • Basic charting and the Bar chart
  • Column chart
  • Line chart
  • Pie chart
  • Adjusting charts
  • New visualizations
  • Enhancing charts
  • Clustered charts
  • 100% Stacked charts
  • Text boxes
  • Page background color

Lesson 6: Interacting with the data

  • Drilling down
  • Slicers
  • Using charts to slice data
  • Filtering data

Lesson 7 : Dashboards

  • Working with a Dashboard
  • Using the PowerBI application for Android
  • Create an alert

Lesson 8 : Additional visualizations

  • Donut charts
  • Funnel charts
  • Scatter charts
  • Bubble charts
  • Waterfall charts
  • Line and stacked coMaps
  • Gauges
  • Custom visualizations
  • Bubble chart play axislumn charts

Lesson 9: Best Practice for Dashboard design

Lesson 10: Optional: Data sources and data manipulation

  • Accessing a SQL Server database
  • Refresh data
  • Split data columns imported from a CSV file

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.