Get a Quote
Course Enquiry
Contact Us

Microsoft PowerBI Dashboard User Course Course Details


The course:

  • Makes use of the Microsoft PowerBI.com web-based application to create basic reports and dashboards. The reports and dashboards can be shared both inside and outside of the company
  • Focuses on the skills that will be needed by dashboards users to compile reports and dashboards, and share the dashboards with colleagues and clients
  • Covers the basic built-in visualizations in detail, with the relevant exercises
  • Covers the advanced built-in functionality for visualization as demonstrations and as self-study sections
  • Gives some guidelines for report and dashboard design

Audience:

Roles include the executive team, their personal assistants, divisional heads, line managers, as well as personnel who need to receive alerts on changes in data

Pre-Requisites:

Delegates must have a working knowledge of Microsoft Windows, and either Microsoft Edge, Microsoft IE, or Google Chrome. Delegates should be able to use one of the Microsoft Office applications on a basic level. Delegates should have some experience in doing reporting

Duration:

1 day

Price:

$225.00 If you are currently resident in South Africa you will need to pay VAT at 14%.   *Discount available

PC Hire:

$33   *Bring a PC

Note: information may change without notice.

About Microsoft PowerBI Dashboard User Course

You are a business user of reports and dashboards, and need to use a tool to support your decision making. You use data both in tabular and in graphical format, and need to access both summarized and detailed versions of the data. You need to interact live with the data sets using a web-based application.

Course Outline


"Course Outline":

  •  Overview of Business Intelligence and PowerBI
    •  Microsoft Self-Service Business Solution
    •  Microsoft PowerBI applications
  • Using Data Sources:
    • Data Sources available
    • Uploading Excel workbook
    • Uploading CSV file
    • Uploading a Web page containing tables
    • Accessing a SQL Server database 
  • Accessing Microsoft PowerBI.com web-based application
    • Login
    • Review the structure of the application
    • Accessing the first dashboards
  • Use Built-in Visualizations and Formatting to create Reports
    • Data Structure of the sample database
    • Tables
    • Table granularity
    • 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
  • Interacting with the data
    • Drilling down
    • Slicers
    • Using charts to slice data
    • Filtering data
  • Dashboards
    • Working with a Dashboard
    • Using the PowerBI application for Android
    • Create an alert
  • Additional visualizations
    • Donut charts
    • Funnel charts
    • Scatter charts
    • Bubble charts
    • Waterfall charts
    • Line and stacked column charts
    • Maps
    • Gauges
    • Custom visualizations
    • Bubble chart play axis
  • Best Practice for Dashboard design
  • Optional: Data sources and data manipulation
    • Accessing a SQL Server database
    • Refresh data
    • Split data columns imported from a CSV file
  • Close

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.

Scheduled Dates


To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date Duration  
Wed 20 Sep 2017 1 day Book Now
Wed 22 Nov 2017 1 day Book Now