Business Intelligence and Dashboarding (16 hrs)

Course Code: OA-BIAD-02

In this course, participants will learn how to use Power Pivot to analyse large amounts of data and create analytics dashboard with Power View’s amazing visualizations tools.

  • Analyse large volumes of data
  • Create analytics dashboard

Planning the Dashboard

Using Power Pivot

  • Power Pivot: Overview
  • Starting Power Pivot
  • Importing from Access
  • Importing from Excel
  • Importing from a Data Feed
  • Power Pivot window
  • Checking relationships
  • Adding columns
  • A quick Pivot Table
  • A very quick Pivot Chart

Using Power View

  • What is Power View?
  • Enabling the Power View add-in
  • Inserting Power View
  • Setting the title
  • Inserting a table in Power View

Building the Dashboard

Inserting charts

  • Creating charts
  • Adding a second series to a chart
  • Sorting values in a chart
  • Moving the chart legend
  • Arranging items in the view
  • Highlighting and filtering data
  • Highlighting chart data with another chart

Formatting the report

  • Applying themes
  • Changing the theme font
  • Changing the theme text size
  • Changing the theme background
  • Applying an image background

Using slicers

  • Inserting slicers
  • Creating a second slicer
  • Filtering data with slicers
  • Clearing filters

Using cards and tiles

  • Using cards
  • Using tiles
  • Inserting another view

Creating bubble charts

  • Creating a bubble chart
  • Adding category group colours to a bubble chart

Creating multiples charts

  • Creating multiples charts
  • Creating multiples line charts
  • Using view filters
  • Using visualization filters

Creating interactive pie charts

  • Creating pie charts
  • Creating a drill-down pie chart using hierarchies
  • Adding more detail using slices
  • Cross-filtering bar charts with other visualizations

Creating map charts

  • Creating an interactive pie chart in a map
  • Changing the sort order of a field using another field
  • Filtering the map using a slicer
  • Filtering other visualizations using the map
  • Creating an interactive bar chart

Reporting

Using Power BI with Office 365

  • Enabling the Power BI app
  • Adding reports
  • Adding a document to featured reports
  • Highlighting report data
  • Filtering report data

Using Power BI Q&A

  • Adding reports to Power BI Q&A
  • Keyword search
  • Searching related data

Participants will benefit from the hands-on practical sessions during the course.

This course is designed for CXOs, Managing Directors, General Managers, Project Managers, Data Warriors and professionals in Finance, Sales, Marketing, Engineering and IT that deal with large volume data and require advanced techniques to convert data into actionable information.

Prerequisite

Participants must be users of Microsoft Excel 2007/2010 for at least 1 year.

Duration : 2 days (16 hrs)
Time : 9:00am – 6:00pm

Course Fee : $800.00
Nett Fee Incl. 7% GST : $856.00

(A course in partnership with COMAT)

Key Benefits
  • Analyse large volumes of data
  • Create analytics dashboard
Course Contents

Planning the Dashboard

Using Power Pivot

  • Power Pivot: Overview
  • Starting Power Pivot
  • Importing from Access
  • Importing from Excel
  • Importing from a Data Feed
  • Power Pivot window
  • Checking relationships
  • Adding columns
  • A quick Pivot Table
  • A very quick Pivot Chart

Using Power View

  • What is Power View?
  • Enabling the Power View add-in
  • Inserting Power View
  • Setting the title
  • Inserting a table in Power View

Building the Dashboard

Inserting charts

  • Creating charts
  • Adding a second series to a chart
  • Sorting values in a chart
  • Moving the chart legend
  • Arranging items in the view
  • Highlighting and filtering data
  • Highlighting chart data with another chart

Formatting the report

  • Applying themes
  • Changing the theme font
  • Changing the theme text size
  • Changing the theme background
  • Applying an image background

Using slicers

  • Inserting slicers
  • Creating a second slicer
  • Filtering data with slicers
  • Clearing filters

Using cards and tiles

  • Using cards
  • Using tiles
  • Inserting another view

Creating bubble charts

  • Creating a bubble chart
  • Adding category group colours to a bubble chart

Creating multiples charts

  • Creating multiples charts
  • Creating multiples line charts
  • Using view filters
  • Using visualization filters

Creating interactive pie charts

  • Creating pie charts
  • Creating a drill-down pie chart using hierarchies
  • Adding more detail using slices
  • Cross-filtering bar charts with other visualizations

Creating map charts

  • Creating an interactive pie chart in a map
  • Changing the sort order of a field using another field
  • Filtering the map using a slicer
  • Filtering other visualizations using the map
  • Creating an interactive bar chart

Reporting

Using Power BI with Office 365

  • Enabling the Power BI app
  • Adding reports
  • Adding a document to featured reports
  • Highlighting report data
  • Filtering report data

Using Power BI Q&A

  • Adding reports to Power BI Q&A
  • Keyword search
  • Searching related data
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is designed for CXOs, Managing Directors, General Managers, Project Managers, Data Warriors and professionals in Finance, Sales, Marketing, Engineering and IT that deal with large volume data and require advanced techniques to convert data into actionable information.

Prerequisite

Participants must be users of Microsoft Excel 2007/2010 for at least 1 year.

Course Details

Duration : 2 days (16 hrs)
Time : 9:00am – 6:00pm

Course Fee : $800.00
Nett Fee Incl. 7% GST : $856.00

(A course in partnership with COMAT)

Course Application

Details Registration
January 6, 2020 - January 7, 2020 (9:00 am - 6:00 pm) Closed
February 27, 2020 - February 28, 2020 (9:00 am - 6:00 pm) Closed
March 30, 2020 - March 31, 2020 (9:00 am - 6:00 pm) Closed
August 20, 2020 - August 21, 2020 (9:00 am - 6:00 pm) Register Now
September 7, 2020 - September 8, 2020 (9:00 am - 6:00 pm) Register Now
October 12, 2020 - October 13, 2020 (9:00 am - 6:00 pm) Register Now
November 19, 2020 - November 20, 2020 (9:00 am - 6:00 pm) Register Now
December 3, 2020 - December 4, 2020 (9:00 am - 6:00 pm) Register Now