Dashboards for Monitoring, Analyzing and Managing

Understanding the terminology of dashboards

Report Builder 3.0

Dashboard Designer

SharePoint Designer

Explore SharePoint 2010 Business Intelligence Center

Dashboard taxonomies

Visual perception

Dashboard design flaws

An effective dashboard design process

Dashboard hierarchy

Dashboard variance

Dynamic dashboards

Dashboard interactivity

Develop multiple dashboards

Change deployed dashboards

Provide interactive help for your dashboards

Monitor dashboard utilization

Control dashboard updates

Group lab using scenarios

Report Builder interface

Data connections

Graphs

Gauges

Parameterized reports

Report parts

Mapping reports

Data connections

Graphs

Gauges

Parameterized reports

Report parts

Mapping reports

Dashboard Designer 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)

Create data connections

Create multiple types of KPIs

Create visual reports

Create the hosting scorecard

Deploy the dashboard to SharePoint

Create filters

SharePoint Designer interface

Business Connectivity Services

SharePoint Web Parts

Using SharePoint Designer for dashboard refinement

SharePoint Designer interface familiarization

Use Business Connectivity Services in a dashboard

Use SharePoint Web Parts in a dashboard

Using SharePoint Designer for dashboard refinement

Guidance through monitoring dashboards

Characteristics of monitoring dashboards

Real-time monitoring

Best practices

Instructor guided project as preparation for the lab

The students will walk through the creation of three dashboards based on scenarios.

Scenario1

Scenario 2

Scenario 3

Student presentation to the group

Guidance through analytical dashboards

Characteristics of analytical dashboards

Best practices

Instructor guided project as preparation for the lab

Scenario 1

Scenario 2

Scenario 3

Students presentation to the group

Guidance through management dashboards

Characteristics of management dashboards

Best practices

Instructor guided project as preparation for the lab

Scenario 1

Scenario 2

Scenario 3

Students presentation to the group

What is MDX?

MDX Query Editor

Select statement

Key concepts

Sets

Functions

Time intelligence

Examine what MDX can add to the reporting environment