The Dashboard Spy

July 19, 2006

Health Care Clinical Quality and Safety Dashboard - Using enterprise dashboards for hospital performance improvement

Filed under: Dashboard Screenshots — dashboardspy @ 4:12 am

By special request from a Dashboard Spy reader interested in using enterprise dashboards in the area of Health Care Clinical Performance Improvements, we present these screenshots from Methodist Medical Center of Illinois, a 330-bed hospital in Peoria. This organization was an early adopter of data dashboards. See this great article on how Methodist’s IT team started developing and implementing data dashboards in 2003, using dashboards to track and improve all dimensions of performance organizationwide, including market breadth and penetration, customer service/patient satisfaction, employee satisfaction, clinical quality and safety, and financial results. Board members, senior executives and physician leaders, service line directors, department or unit managers, and front-line staff review specific data dashboards regularly.

Here is the process improvement process used at the hospital:

Performance Improvement Process

The statement of the formal goals and establishment of the above process was key to the Performance Improvement program. As the article states:

Michael Bryant became Methodist’s CEO in 2000, and he raised the performance bar by setting a goal of being in the top 5% of every performance area. To achieve that goal, it was clear that communication of the goal and the status at the indicator level was a must. Methodist achieved that communication by using a simple stoplight color scheme, which provides clarity for all Methodist dashboards. “Green” indicates excellent work that should be maintained; “yellow” signifies a need for focus because performance is starting to lag; and “red” is an alert, indicating an immediate need for intervention and improvement. “We use these stoplight colors for every dashboard, whether measuring admissions, employee turnover, patient satisfaction, falls, or operating margin,” says Duvendack.

To ensure reliability and validity of data collection and analysis, dashboards should have rules that govern their development and implementation. “Behind the scene of any data dashboard is a strict set of definitions for indicator numerators and denominators, how measures are calculated, inclusion/exclusion criteria, and other parameters,” says Duvendack. “Consistency of dashboard construction and indicator calculations is critical, so a limited number of trained individuals at Methodist are responsible for working with the data that populate the clinical dashboards.”

In addition, because timeliness of the data is critical to effective response, rapid turnover of charts for abstraction is required. Clinical abstracters at Methodist review charts as soon as possible, generally no more than a few weeks after a patient is discharged. “In order to provide meaningful input to quality improvement efforts, the data cannot lag too far behind the care received,” says Duvendack. Data from chart abstraction are entered into the database. The PI department disseminates the dashboards weekly.

These are the bi-weekly hospital-wide dashboards used to enable the performance improvements in the hospital. I apologize for the low quality of the dashboard screenshots. This is the data the Heart Failure Care team uses. The PI staff releases unit-based disease-specific dashboards weekly. Front-line staff and all members of the disease-specific teams in the appropriate clinical units receive the dashboards via e-mail and other means. “We distribute report copies at team meetings and post the dashboards on PI boards, in bathrooms, and every other venue we can use to get the word out. Staff is very familiar with the dashboards,” says Duvendack.

data dashboard

This is the unit specific dashboard. Service line directors, physician partners, and core teams review the reports during weekly meetings, and teams identify “outlier” indicators that require focus. Weekly dashboards may not include all the cases because data are added on a “rolling forward” basis, but by the end of the month, all cases are included in the monthly report

Data Dashboards

Homework: For background on this please look at these books on clinical improvement. And if you are on an enterprise dashboard project, do yourself a favor and take a look at Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

July 17, 2006

MIS Cockpit Enterprise Dashboard - Putting Excel on steroids with Palo, an open source business intelligence tool

Filed under: Dashboard Screenshots — dashboardspy @ 11:44 pm

Thanks to a tip from a Dashboard Spy reader, I’ve been checking out the Palo open source tool at www.palo.net. The product is an open source business intelligence tool that works in conjunction with Microsoft Excel. It is basically a data store for Excel that permits incredibly huge amounts of data in a small number of worksheets.

Here are a couple of dashboard screenshots. The first shows the MIS Cockpit which is a demo application you can download and try. According to the site: “The application only consists of five Palo enabled screens. But these screens hold as much data as thousands of conventional Excel worksheets.”

MIS Enterprise Dashboard

This next screenshot shows a sales analysis dashboard using the palo product:

Excel Sales Dashboard

Homework: Getting into enterprise dashboarding with Excel? Review charting with this book: Excel Charts for Dummies. If you are on an enterprise dashboard project, do yourself a favor and take a look at Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

Sales and Marketing Enterprise Dashboard - tracking pipeline KPIs

Filed under: Dashboard Screenshots — dashboardspy @ 9:30 am

Here is a sales enterprise dashboard packed with plenty of sales and marketing KPIs to study. The info on the underlying product is located at http://www.azerity.com/products_azerity_dashboard.htm. The focus of this example is on the world of sales. There are lots of sales, marketing and sales pipeline metrics presented. Different dashboard views can be selected via a dropdown control.

The first screenshot shows an overall sales dashboard view. Graphs are presented in portlets with dropdown filtering underneath each one. A simple graphic is shown for each KPI with the underlying data accessible via a link. The top row features Top Customers, Sales Revenue and Top Markets Sales Trend. The second row looks at pricing pressures and win/loss ratios. The bottom of the page features the sales pipeline.

Sales metrics dashboard

Here is the Sales Pipeline Projection KPI dashboard. The KPIs are presented by close date, by organization and by market segment.

Sales Pipeline Project Enterprise Dashboard

This is chart detailing the trend in the margin percentage that the company is making. A good way to focus sales attention in the areas that really pay off.

Margin Metrics Dashboard

Finally, you know I like to see how the dashboard views can be configured  by the users. Here is how the charts can be customized.

Customizing enterprise dashboards

Homework: Trying to understand what is behind sales pipeline management? You must take a look at Sales Forecasting Management: Understanding the Techniques, Systems and Management of the Sales Forecasting Process.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

If you are on an enterprise dashboard project, do yourself a favor and take a look at Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.

July 14, 2006

Casino Management Enterprise Dashboard - KPIs for regulatory compliance of slots revenue

Filed under: Dashboard Screenshots — dashboardspy @ 9:19 am

A Dashboard Spy looking into the challenges of maximizing slot machine revenue at an indian reservation casino reports in with these screenshots of enterprise dashboards dedicated to tracking gaming machine KPIs. Did you know that slots account for more than half of a typical casino’s revenue? The key factor is the gross revenue (or the “drop”) of these machines. Statistics are carefully kept down to the individual machine as these dashboard screenshots show. If you didn’t realize, this proves that it’s all about optimizing the total drop by carefully manipulating every element in the casino. This starts with the exact placement of every machine. These screenshots show gaming machine moves, destroys and sells.

The last screen shows the revenue of a certain slot machine. My question is when is the money actually counted for these statistics? A big concern in the industry is “skimming the drop”, that is, employees taking money out of the machines - usually the coins are diverted before the count room is reached. Does the technology exist to have the machines networked to report in real time the money received? That way, skimming is shown instantly with the discrepancy between the machine’s report and the actual counting room report. Shouldn’t this be straight forward?

Here is an interesting article regarding slot fraud from a 1991 CPA Journal article, “Control Testing in the Gaming Industry“.

Slot Machine Dashboard

Casino Management Enterprise Dashboard

Gaming Machine Revenue Dashboard

Homework: Casino management is a very interesting topic. Take a look at these books on casino management. And if you are on an enterprise dashboard project, do yourself a favor and take a look at Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

July 13, 2006

User Configurable Service Desk Operational Metrics Dashboard - letting users create their own dashboard queries

Filed under: Dashboard Screenshots — Tags: , — dashboardspy @ 4:18 am

Dashboard Software Focus:  IQ Dashboard, Configuration of Dashboard Chart Views

Today we look at how one dashboard software package allows its users to customize their dashboard charts and graphs.

>>>

This just in from a Dashboard Spy over at enterprisesolutionsinc.com who has developed a user-configurable dashboard system used to track real-time performance of service desk functions. Called the iQDashboard, the .net-based system allows the users the self-configure the flash-based graphics.

To use their enterprise dashboard, the user logs in through this cute logon page:

Dashboard Logon Screen

The user then gets their dashboard. In this case, they’ve chosen a couple of metrics important for monitoring service desk performance. Note the navigation on the left. There are user configurable folders (ie. multiple dashboards) and links to user setting controls.

Service Desk Dashboard Metrics

When the user needs a new query, they can construct one themselves using the following screen. Obviously, a screen like this may be overpowering for some users, but the gung-ho power user can help themselves without calling the IT department.

Construct a dashboard query

The user can then select the flash chart they want to use to display the dashboard metric.

Select a flash graph

The user can select what folder to place the graphs of the metrics in.

Multiple enterprise dashboards

Tags: Dashboard Software, Configuring Dashboard Charts

Homework: If you are on an enterprise dashboard project, do yourself a favor and take a look at Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

July 12, 2006

ITSM Dashboard Screenshots for SAP service level KPIs - Applying technical analysis to IT service level management?

Filed under: Dashboard Screenshots — dashboardspy @ 9:15 am

Thanks goes to the Dashboard Spy who tracks Information Technology Service Management (ITSM) dashboards. He sent me some screenshots of an ITSM dashboard that shows an SAP system being monitored in terms of its SLA, costs, performance and many other metrics. The underlying product is from mirror42.com.

Take a look at these dashboard screenshots. You’ll find many detailed and wonderful metrics. My only issue is with the last screen. It deals with the analysis of the service level agreement performance. Look carefully at the analysis options in the chart. Bollinger Bands and Donchian Channel technical analysis! Investment analysis techniques applied to IT service metrics? What the..? Are we saying that standard statistical analysis of IT system SLAs is not good enough? We have to try the controversial world of predictive technical analysis and charting from the world of securities trading? I don’t know if this is over-analysis or what. Maybe they had the charting engine sitting around from a trading system project. Does anyone else think this a case of overkill? Or worse yet, a mis-application of technology? Maybe I’m wrong and this is a new trend? Please let me know.

SAP SLA Dashboard

SAP Dashboards

 SAP SLA KPI Scorecard

SAP KPI metrics

Technical Analysis charting

Homework: Two different areas to study. If you need to brush up on IT Service Management, the place to start is the book, IT Services Costs, Metrics, Benchmarking and Marketing. If you want to know more about technical analysis of investments, start with these books on technical analysis.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

July 11, 2006

Currency Trading Dashboard - Screenshot of a trade management dashboard

Filed under: Dashboard Screenshots — dashboardspy @ 4:03 am

Thanks to a rather sneaky Dashboard Spy, we have this enterprise dashboard screenshot from a large financial institution’s trade management system. This dashboard shows positions, a maturity profile, deal statistics, deal action status, recent deals and a “pick a task” portlet.

I did some research and this looks like it is based on the Sungard Avantgard treasury management dashboard product (see http://www.sungard.com/products_and_services/treasury/).

Treasury Trading Deal Dashboard

Homework: This is a complicated field of dashboarding to attempt if you don’t have trading systems experience. If you like the sink or swim approach, better start with these books on trading treasuries.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

July 10, 2006

Self Service Performance Dashboard - tracking operational data through personalized enterprise dashboards

Filed under: Dashboard Screenshots — dashboardspy @ 10:09 am

One challenge for both dashboard users and IT departments is how to deal with the success of an enterprise dashboard. As we all know, once business users get a taste of the ease of use and at-a-glance understanding that an enterprise dashboard provides, they want more - lots more. Not only that, everyone wants something different.

The question becomes, how does the IT department handle these requests? Stack up the requirements for future releases? That tried and true solution does work, but, depending on the particular agility of the IT department, may take a while. This may be OK, but what about building in a self-service element into the dashboard itself?

The folks at Celequest (see http://www.celequest.com/products/lava/PerformanceDashboards.aspx) have taken this approach of allowing business users to personalize, modify and create new metrics on their dashboards without the intervention of the IT department. They’ve put up a roll-over tour of their performance/operational dashboard at the above link which I’ve taken screenshots from for you.

Operational Performance Enterprise Dashboard

User Personalized Executive Dashboard

Task Management Assignment Dashboard

Root Cause Drill Down Enterprise Dashboard

Dashboard KPIs

Alerts Executive Dashboard Alerts Screenshot

Homework: If you want to make users happy, include self-service features in your applications. Things like personalization, configuration and “remember my settings” go a long way toward usability. Look for simple to implement features that bring lots of usability. Take a look at this list of books on usability

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

« Newer PostsOlder Posts »

Blog at WordPress.com.