Download PDF
of this course

MS50596 - Dashboards for Monitoring, Analyzing and Managing (MS50596)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 3 Days

This course is designed to empower the students to effectively design web-based dashboards by utilizing the three main tools for dashboard building in the Microsoft tool set. Report Builder 3.0 from SQL Reporting Services, Dashboard Designer from PerformancePoint Services and SharePoint Designer. In using each of these tools you gain the best of breed to combine features and develop dashboards that are highly effective for monitoring, analyzing and managing your business.

Who Should Attend

The goal of creating effective dashboards is a collaborative team effort. This course is targeted at that team.

  • The Project Manager to gain an understanding of best practices, follow a design methodology and gain an understanding of ineffective dashboard designs.

  • The Business Managers so they can understand the input that they will need to provide to the project team and what they should expect back from these dashboards.

  • IT as they manage the infrastructure.

  • Report Builders' so their designs can be effectively presented to the report consumer.

  • Business Intelligence/SQL Personnel as it is their data that is displayed and analyzed.

This course utilizes the tools in such a manner that we do not expect the students to have developer level skills.

Course Certifications

This course is part of the following Certifications:

Prerequisites

Before attending this course, students should have:

  • An understanding of the state of the data repository in their environment.

Course Objectives

After completing this course, students will be able to:

  • Utilize the dashboard development methodology

  • Optimize visual design of dashboards

  • Structure dashboards hierarchies

  • Understand the basics of data visualizations

  • List the thirteen crucial errors in dashboard design

  • Implement user menus in scorecards

  • Understand how to connect into multiple data sources

  • Gain familiarity with the definitions of common Business Intelligence terms

  • Learn the methodology for connecting into and displaying near-real-time data

  • Create parameterized reports

  • Create sub reports

  • Create map based reports

  • Use the Decomposition Tree in PerformancePoint Services

  • Connect together SharePoint components into PerformancePoint components

  • Use report parts as a library

  • Know when to use Report Builder, Dashboard Designer and SharePoint Designer

  • Use and understand Report Builder 3.0

  • Use and understand Dashboard Designer from PerformancePoint Services

  • Use and understand SharePoint Designer for working with dashboards

  • Utilize Excel Services to share Excel workbooks

  • Design and implement KPIs

  • Understand the scoring methodologies used with indicators to change visual displays

  • Be able to develop proper filters for easy end-user click to detail on dashboards

  • Group scorecards into dashboards and link them together

  • Modify the web page hosting the dashboards for branding

  • Implement master pages in dashboards for consistency with company standards.

  • Develop multiple-valued KPIs. For example this year actual and target and last year actual and target at the same relative point in time

  • Implement time intelligence features to query such as Year-To-Date, Last 6 Months etc.

  • Develop filters for scorecards

  • Understand the implications of where a filter is applied

  • Create effective graphs

  • Create visual reports

  • Create effective gauges

  • Utilize sparklines in reports

  • Understand how to secure dashboards

  • Use dynamic hierarchies in dashboards

  • Implement user menus in dashboards

  • Create monitoring dashboards

  • Create analytical dashboards

  • Create management dashboards

Course Content

Module 1 : Course Overview 

Ths module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course materials
  • Facilities
  • Prerequisites 
  • What we will be discussing

 

Module 2 : The Micrcosoft Business Intelligence Stack tools

Lessons

  • SQL Analysis Services
  • SQL Reporting Services
  • SharePoint 2010 PerformancePoint Services
  • SharePoint Business Intelligence Center 
  • Understanding the terminology of dashboards
  • Report Builder 3.0
  • Dashboard Designer 
  • SharePoint Deisgner

Lab : The Business Intelligence Stack

 

Module 3 ; Dashboard design principles

Lessons 

  • Dashboard taxonomies
  • Visual perception
  • Dashboard design flaws
  • An effective dashboard design process
  • Dashboard hierachy
  • Dashboard variance
  • Dynamic dashboards
  • Dashboard interactivity
  • Develop multiple dashboards
  • Change deployed dashboards
  • Provide interactices help for your dashboards
  • Monitor dashboard utilization
  • Control dashboard updates

Lab : PerformancePoint Services 2010

 

Module 4 : Report Builder 3.0

Lessons

  • Report Builder Interface
  • Data connections
  • Graphs
  • Gauges
  • Parameterized reports
  • Report parts
  • Mapping reports

Lab : Repoert Builder 3.0

 

Module 5 : Dashboard Designer

Lessons 

  • Dashboard Deisgner interface
  • Key performance indicators ( KPIs )
  • Multivalued KPIs
  • Objective KPIs
  • Leaf KPIs
  • Indicators
  • Filters
  • Scorecards ( as containers )
  • Connections 
  • Visual reports ( Called graphs in Report Builder )
  • Dashboards ( Here we mean the web page )

Lab : Dashboard Designer

 

Module 6 : SharePoint Designer

Lessons

  • SharePoint Designer Interface
  • Business Connectivity Services
  • SharePoint Web Parts
  • Using Sharepoint Designer for dashboard refinement

Lab : SharePoint Designer 

 

Module 7 : Dashboards that monitor 

Lessons

  • Guidance through monitoring dashboards
  • Characteristics of monitoring dashboards
  • Real-time monitoring 
  • Best practices
  • Intructors guided project as preparation for the lab

Lab : Dashboards that monitor

 

Module 8 : Dashboards that analyze 

Lessons 

  • Guidance through analytical dashboards
  • Characteristics of analytical dashboards
  • Best Practices
  • Intstructors guided project as preparation for the lab

Lab : Dashboard that analyze

 

Module 9 : Dashboards for management strategy

Lessons

  • Guidance through management dashboards
  • Characteristics of management dashboards
  • Best practices
  • Instructor guided project as preparation for the lab

Lab : Dashboards for management strategy

 

Module : 10 Custom reports and graphs using MDX ( Optional module )

Lessons 

  • What is MDX ?
  • MDX Query Editor 
  • Key concepts 
  • Sets
  • Functions
  • Time intelligence

Lab : MDX reporting ( Optional Module )

Additional Reading

To help you prepare for this class , review the following resources :

Larson , Brian. Delivering Business Intelligence with Microsoft SQL Server 2012 . Third ed. The McGraw-Hill Companies , 2012.

Course ID: MS50596


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register