1 kevin kratzer, systems engineer dashboards tips and techniques march 2, 2012
TRANSCRIPT
![Page 1: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/1.jpg)
1
Kevin Kratzer, Systems Engineer
Dashboards Tips and Techniques
March 2, 2012
![Page 2: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/2.jpg)
Agenda
Introductions
Why Dashboards
Graphs or Tables
When to use what charts
Creating Useful Dashboards
![Page 3: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/3.jpg)
Why and Types of Dashboards
![Page 4: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/4.jpg)
Why Dashboards
A man with a broom is standing sideways on the wall of a brownish-orange building. There are potted trees and plants near by. Several windows can be seen – one at street level, one approximately 6 feet from the ground the other at ten feet. Each of the windows are guarded by black wrought-iron fencing. A Lamp post is seen directly behind the horizontal man.
![Page 5: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/5.jpg)
What Type of Dashboards to Use
Know yourTarget
Audience
ActiveDashboards
FlexDashboards
CustomDashboards Analytical
Dashboards
GeographicDashboards
RealTime
Dashboards
PerformanceManagementDashboards
![Page 6: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/6.jpg)
Tables vs Graphs
![Page 7: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/7.jpg)
Table vs Graph
Table • Use when you need to read every value
• Use when you need to compare every value
Graph• Provides shape to your data and forms
• Shows patterns and trends
• Reveals relationships among many values
![Page 8: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/8.jpg)
Types of Graphs and When to Use Them
![Page 9: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/9.jpg)
Types of Graphs and when to Use Them
Bar Graph
• Use bar graphs when individual values are important
• Simple comparison of categorical subdivisions of one or more measures in no particular order
![Page 10: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/10.jpg)
Types of Graphs and when to Use Them
Pie Chart
• Use to show the relative size of each pie segment (slice) to one another and to the whole.
• At times difficult to visually distinguish differences in slice sizes.
• Each pie chart can draw only one measure
![Page 11: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/11.jpg)
Types of Graphs and when to Use Them
Line Chart
• Use to show and compare changes over time or sequential data
• Frequently used to show trends and performance
• Suggest a gradual flow between points
![Page 12: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/12.jpg)
Types of Graphs and when to Use Them
Scatter Chart• X Y Plot
• Compare two sets of numbers at once, possibly revealing patterns and trends
• Numeric X-Axis
Bubble Chart• Three variables in two
dimensions
• Like scatter, with a third variable „Size‟
• Size of each bubble is used to show the data‟s relative importance
![Page 13: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/13.jpg)
Techniques for Creating Dashboards
![Page 14: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/14.jpg)
Techniques for Creating Dashboards
Creating Chained Filters• Secondary Filters are
based on Primary Filter
• Minimizes user views of unrelated criteria
![Page 15: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/15.jpg)
Techniques for Creating Dashboards
Using Tab Controls• Provide More Content
• Minimize Scrolling
• Categorize Tab Content
• Create Multiple Dashboard Views within a Single Dashboard
![Page 16: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/16.jpg)
Techniques for Creating Dashboards
Maximize Real Estate by Providing Parameter Driving Reports
• Create Parameters for any aspect of a report
• Allows Users to get a lot of information in a small amount of real estate
• Minimizes the amount of reports that need to be maintained
![Page 17: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/17.jpg)
Techniques for Creating Dashboards
Drill Down/Drill Anywhere• Drill Down
• Use when you are only supplying one option for next level view
• Drill Anywhere• Provide multiple drill down
options
• Drill down to WebFOCUS reports, Websites, and any other system or job
![Page 18: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/18.jpg)
Best Practices
![Page 19: 1 Kevin Kratzer, Systems Engineer Dashboards Tips and Techniques March 2, 2012](https://reader030.vdocuments.us/reader030/viewer/2022032705/56649dca5503460f94ac06cd/html5/thumbnails/19.jpg)
Questions
Thank You!
Questions?