A High-level View of the Business with Drillable Graphics
Download
Report
Transcript A High-level View of the Business with Drillable Graphics
A View of the Business
with Drillable Graphics
Southern Computer Measurement Group
May, 2012
Martha Hays
Agenda
2
The issues
One look at all of your resources
IT Tile Chart
– How it works
– Extending the possibilities with Stored Processes
SAS BI Dashboard
Today’s IT Issues
3
Resources are growing
– Numbers
– Size
– Volume of information
Reports are growing
Fewer Analysts to develop and use
Need
– a capability to view and analyze a large quantity of
resources
– a quick and easy development process
– A report to focus attention on the issues that
require action
Reports that Focus
Overview
tile chart
BI
Dashboard
What is a Tile Chart?
5
Technically, a rectangular tree map
– Heat Map
– Tile Map
– Heat Chart
SAS calls it a Tile Chart
What is a Tile Chart?
6
Technically, a rectangular tree map
Designed to:
– View a large quantity of data
– Visualize hierarchical data
– Show many levels of detail
– Use limited visual space
– Limit use of labeling
– Use data tips or “mouse over” capability
– Link to other tile charts, graphs, tables, or Web sites
Accessed through a Web browser or portal
The Original Idea
The chart is designed to view a large quantity of
hierarchical based data in a limited space.
Each unique category combination is represented by a
rectangular “tile” with size and color determined by
response variables.
These tiles are placed in a hierarchal arrangement.
One version created by smartmoney.com is called the
Map of the Market, which visualizes the stock market.
(www.smartmoney.com/map-of-the-market)
7
What does it Look Like?
An existing Tile Chart as seen through the SAS
Information Delivery Portal
8
What does it Look Like?
Hierarchical organization
Current level of hierarchy is the only label
9
What does it Look Like?
A color-gradient legend provides a key to the value of
the tile colors
A data tip with detail information
10
Drill-Down Hierarchy
Here is a link to a stored process with prompts:
http://sasbi.demo.sas.com:8080/SASStoredProcess/do?
_program=/BIP%20Tree/Daily_CPU&Machine={&1}
&date={&2}&_odsstyle=ITRMDefault
The drill-down hierarchy passes prompt values from
the current tile to a stored process.
Creating a Stored Process
Creating a stored process makes the underlying code
available for execution from other SAS applications
12
Demo of a SAS Tile Chart
13
What Is a Dashboard?
Dashboards are information delivery tools:
used to graphically display key metrics within an
organization.
primarily used as a way to summarize information for
decision support purposes.
Corporate dashboards have existed for many years, as
has the ability to create them using various SAS
software products.
14
What Is a BI Dashboard?
SAS BI Dashboard
Bi Dashboard enables the rapid creation and
deployment of dashboards that display data from a
wide variety of data sources and systems.
A dashboard is a way to represent numbers in an
easily consumable, graphical form. Dashboards display
information in such a way that the information can be
interpreted and monitored at a glance.
15
Dashboard support many types of gages and
graphs
.
Dashboards
can display
one or two
analysis variables
at a time.
16
Display Types
Different display types are used for visually displaying
information on a dashboard.
17
Configuration Icons
Further customize the indicator by configuring:
links to other dashboards, graphs or stored processes
alerts
gauge properties.
Not all display types enable
you to access each of the
different configuration icons.
Define
indicator links
18
Define indicator
alerts
Define gauge
properties
Demo of a BI Dashboard
19
The Business Value
20
Identify issues at a glance
Details in the data tips
Drill down to specific information
Save the time of looking through hundreds of reports
Suggested uses
21
We have seen:
– Stock changes
– IT Resource usage
– Sales representative performance
You might also use:
– Division / region / store / sales
– Inventory status
– Customer satisfaction by service or product
– …
Questions?
22