1 / 22

A View of the Business with Drillable Graphics

A View of the Business with Drillable Graphics. Southern Computer Measurement Group May, 2012 Martha Hays. 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. Today’s IT Issues.

farrah
Download Presentation

A View of the Business with Drillable Graphics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A View of the Business with Drillable Graphics Southern Computer Measurement Group May, 2012 Martha 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 focusattention on the issues that require action

  4. 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

  7. 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)

  8. What does it Look Like? • An existing Tile Chart as seen through the SAS Information Delivery Portal

  9. What does it Look Like? • Hierarchical organization • Current level of hierarchy is the only label

  10. 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

  11. 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 Process • Creating a stored process makes the underlying code available for execution from other SAS applications

  13. Demo of a SAS Tile Chart

  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.

  17. Display Types • Different display types are used for visually displaying information on a dashboard.

  18. Configuration Icons • Further 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. Define indicatoralerts Defineindicator links Define gaugeproperties

  19. Demo of a BI Dashboard

  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?

More Related