Data Analytics Dashboard Using Power View (Excel 2013/2016) (8 hrs)

Course Code: OA-DADP-03

In this course, participants will learn how to use Power View to analyse large amounts of data, as well as create analytics dashboard and amazing visualizations.

  • Learn to use Power View
  • Analyse large volumes of data
  • Create analytics dashboard
  • Create amazing visualizations

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

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

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

This course is ideal for Managers, Business Analysts, Data Analysts, Business Intelligence Professionals, MIS Professionals, Dashboard Makers and students with basic knowledge of Microsoft Office Excel seeking to reap the benefits of Power View.

Prerequisite

Participants must have a basic working knowledge of Pivot Tables and formulas in Excel.

Duration : 1 day (8 hrs)
Time : 9:00am – 6:00pm

Course Fee : $400.00
Nett Fee Incl. 7% GST : $428.00

(A course in partnership with COMAT)

Key Benefits
  • Learn to use Power View
  • Analyse large volumes of data
  • Create analytics dashboard
  • Create amazing visualizations
Course Contents

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

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
Learning Methodology

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

Who Should Attend

This course is ideal for Managers, Business Analysts, Data Analysts, Business Intelligence Professionals, MIS Professionals, Dashboard Makers and students with basic knowledge of Microsoft Office Excel seeking to reap the benefits of Power View.

Prerequisite

Participants must have a basic working knowledge of Pivot Tables and formulas in Excel.

Course Details

Duration : 1 day (8 hrs)
Time : 9:00am – 6:00pm

Course Fee : $400.00
Nett Fee Incl. 7% GST : $428.00

(A course in partnership with COMAT)

Course Application

Details Registration
January 23, 2020 - January 23, 2020 (9:00 am - 6:00 pm) Closed
March 18, 2020 - March 18, 2020 (9:00 am - 6:00 pm) Closed
September 23, 2020 - September 23, 2020 (9:00 am - 6:00 pm) Register Now
November 26, 2020 - November 26, 2020 (9:00 am - 6:00 pm) Register Now