a view of the business with drillable graphics southern computer measurement group may, 2012 martha...

A View of the Business with Drillable Graphics

Southern Computer Measurement GroupMay, 2012Martha Hays

2

Agenda The issues One look at all of your resources IT Tile Chart

– How it works– Extending the possibilities with Stored Processes

SAS BI Dashboard

3

Today’s IT Issues 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

5

What is a Tile Chart? Technically, a rectangular tree map

– Heat Map– Tile Map– Heat Chart

SAS calls it a Tile Chart

6

What is a Tile Chart? 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 IdeaThe 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.

12

Creating a Stored ProcessCreating a stored process makes the underlying code

available for execution from other SAS applications

Demo of a SAS Tile Chart

13

14

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.

15

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.

16

Dashboard support many types of gages and graphs.

Dashboardscan display

one or two

analysis variables

at a time.

Display TypesDifferent display types are used for visually displaying information on a dashboard.

17

Configuration IconsFurther customize the indicator by configuring: links to other dashboards, graphs or stored processes alerts gauge properties.

Not all display types enableyou to access each of thedifferent configuration icons.

18

Define gaugeproperties

Define indicatoralerts

Defineindicator links

Demo of a BI Dashboard

19

20

The Business Value Identify issues at a glance Details in the data tips Drill down to specific information Save the time of looking through hundreds of reports

21

Suggested uses 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– …

22

Questions?