Dashboard Methodology Ray Kemp SAP Crystal Solutions Seminar

“DASHBOARDS MADE EASY” An introduction to SAP Crystal Dashboard Design

Dashboard Methodology

What are dashboards and what do they look like?

Why would we need a dashboard over a traditional report or a spreadsheet?

How would we design and implement a dashboard?

What architecture needs to exist behind the scenes?

Dashboard Methodology

What are dashboards and what do they look like?

Why would we need a dashboard over a traditional report or a spreadsheet?

How would we design and implement a dashboard?

What architecture needs to exist behind the scenes?

Dashboard Methodology

Dashboard Methodology

Dashboard Methodology

What are dashboards and what do they look like?

Why would we need a dashboard over a traditional report or a spreadsheet?

How would we design and implement a dashboard?

What architecture needs to exist behind the scenes?

Dashboard Methodology

Dashboard Methodology

Dashboard Methodology

Dashboard Methodology

Dashboard Methodology

Spreadsheet overload

Dashboard Methodology

Dashboard Methodology

What are dashboards and what do they look like?

Why would we need a dashboard over a traditional report or a spreadsheet?

• Visually easier to understand and display

• All in one place

• Portable

• Automated

• One version of the truth

Dashboard Methodology

What are dashboards and what do they look like?

Why would we need a dashboard over a traditional report or a spreadsheet?

How would we design and implement a dashboard?

What architecture needs to exist behind the scenes?

Dashboard Methodology

Example:

Direct Gov are a web based portal

that provide a large amount of public

services online.

Crucial to their business are the statistics behind the usage of the site.

• How many hits does each department get?

• Where do they come from?

• What are the trends of usage over a defined period?

• Can we split these figures over departments?

Dashboard Methodology

Dashboard Methodology

KPI’s and details are agreed with the “board” based on discussions with

the relevant managers, users, owners ...

• Is it ... how many hits does each department get?

• Is it ... where do they come from?

• Is it ... what are the trends of usage over a defined period?

• Is it ... can we split these figures over departments?

• Will this dashboard project add value?

Dashboard Methodology

Where does all the data come from for the information we wish to display?

MS SQL Server Oracle

Dashboard Methodology

Dashboard Methodology

Dashboard Methodology

Dashboard Methodology

What are dashboards and what do they look like?

Why would we need a dashboard over a traditional report or a spreadsheet?

How would we design and implement a dashboard?

What architecture needs to exist behind the scenes?

Delivery Method

Dashboard Methodology

Data Layer

Data Connector (ODBC, OLEDB, Native, etc…)

Data

Connectivity

Universe

Dashboard Connectivity XML Web Service Live Office

Dashboard On interval On open On demand Refresh

Dashboard Methodology

Data Layer

Data Connector (ODBC, OLEDB, Native, etc…)

Data

Connectivity

Universe Dashboard

Connectivity

Dashboard On interval On open On demand Refresh

Delivery Method

Thank you