Dashboards by Example
    Digital Dashboard Examples & Best Practices.   From Excel Dashboards to Enterprise Business Intelligence, these dashboards contain KPIs, metrics, charts, trends and data visualizations. Learn the best practices of enterprise dashboard design by studying the work of your peers on business dashboard implementation teams around the world. Examine their digital dashboards and share your dashboard design tips in return.

For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers and I.T. trade magazines at no cost.

Archive for February, 2007

This is an archive of the unique and controversial resource on Enterprise Dashboards known as The Dashboard Spy blog on Enterprise Dashboards. This is Volume 1 of the dashboard screenshot collection where you will find 837 dashboard screenshots of various dashboard implementations. Included in this collection are executive dashboards, enterprise dashboards, performance dashboards, corporate dashboards, balanced scorecards, BI dashboards, business intelligence dashboard - the list goes on. What is the difference between all those terms? That's part of the fun! Start studying these screenshots and learn.

Here is an interesting way to find more enterprise dashboards to study: Click this link for a random dashboard. You'll never know what dashboard you'll see next.

Sharepoint Digital Dashboard Navigation Wireframe

Monday, February 5th, 2007

On digital dashboard navigation and usability best practices: With the latest version of SharePoint being so robust in features handy for enteprise dashboard projects, I’m seeing quite a few SharePoint-based dashboard projects underway. Here is a great article on the navigation aspects of Sharepoint. While navigation in enterprise dashboards tend to be very straight-forward, it’s still important to understand the usability principles underlying it. For most dashboards, go with what everyone else is using. As mentioned in the article:

Emerson (who said “Foolish consistency is the hobgoblin of little minds”) is a personal favorite author of mine; however, he didn’t have to train hoards of users how to use a new interface. There’s definitely something to be said for creating the kind of navigation that users are accustomed to. In the world of the Web that means navigation belongs on the top and on the left.

Nearly every non-marketing Web site will follow a pattern with navigation on the top and on the left-hand side. While what is on the top and left side differs, the fact that these spaces are reserved for navigation normally does not. So if you’ve got a wild side, or feel like training scores of users, you can move the navigation — otherwise we’re more or less stuck with the accepted norm.  

This wireframe shows the structure of SharePoint’s zones, or sections of the screen in which you can populate web parts. It is recommended that you place the horizontal navigation above (right of the site logo) and use left navigation as shown:

Navigation wireframe Sharepoint dashboards

Tags: Enterprise Dashboard Design, Executive Dashboard Navigation, Business Intelligence Dashboard Design

Homework: Usabilty is key when presenting to the end user through a dashboard. Study up on the discipline of usability. Start with these usability books.

The Dashboard Spy Business Intelligence Dashboards Blog


Airline Operations Executive Dashboard KPIs for Sales, Operations and Financials from Dundas

Saturday, February 3rd, 2007


I’ve written before about the great executive dashboard design team at Dundas a provider of charts, maps and gauges for .net based digital dashboards. See their work at this executive dashboard gallery. Today’s enterprise dashboard screenshot review is based on their recent work on an airline executive management dashboard system. If it seems to you that everyone does an airline executive dashboard, you are right. There was a business intelligence dashboard competition a while back that asked entrants to design a dashboard for airline management - hence the proliferation of airline dashboards. So, here are some more airline management dashboards. I am a sucker for nice graphics, so I particularly like the approach of the following screenshots. The demo is available online so check out the summary screen, the sales dashboard, the operations dashboard and the finances dashboard for yourself.

airline executive dashboard kpi

airline bookings sales dashboard

airline operations dashboard screenshot

airline financial dashboard screenshot

 

Homework: The best way to make sure that your dashboard is a success is to really pay attention to the design phase of the project. Well worth studying is this lavishly illustrated book, Information Dashboard Design: The Effective Visual Communication of Data.

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 digital dashboard, balanced scorecard, or any business intelligence graphic to share, send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s books on enterprise dashboards. His current favorite is Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing executive dashboards.

The Dashboard Spy Business Intelligence Dashboards Blog

Enterprise Dashboard KPI Visualization for Control Engineering

Friday, February 2nd, 2007

As I mentioned recently, I do a lot of research on enterprise dashboard matters by using some very costly databases that aren’t usually available to most people. As a result, I come across some great articles that would never see the light of day. Associates always ask me to forward the good ones, and I’d thought I’d do the same for you Dashboard Spy readers. Here is a great article on using KPI visualization in the area of control engineering:

Copyright 2007 Reed Business Information, US, a division of Reed Elsevier Inc.
All Rights Reserved
 
Control Engineering

January 1, 2007

SECTION: FEATURES; Information Control; Pg. 42

LENGTH: 1958 words

HEADLINE: KPIs Made Easy;
Behind the data walls and executive dashboards, metrics increasingly link to real-time, plant-floor data. Do you know enough about key performance indicators (KPIs) and manufacturing execution systems (MES) to invest in efficient process improvements?

BYLINE: Frank O. Smith, Control Engineering

BODY:

Process control is hip. Manufacturing line optimization is cool. Everybody from the CEO down wants a piece of it. And judging by the clamor around video walls, information portals, and executive dashboards, everyone wants to visualize control to drive performance.

Globalization and pressure on companies to compete at the most fundamental level of operational excellence means everyone is looking at the factory, the mill, or the plant more closely. The challenge is whether control engineering can master the strategic role implicit in this level of scrutiny.

What’s strategic in the role can be summed up in three letters: K-P-I. Key performance indicators are measures of success or compliance, and the industry is rife with talk of them. Industry analysts, organizations, and enterprises are deep in exploration and analysis of how to define, create, calculate, and disseminate KPIs. And control engineers need to understand them, so they can help in meaningful ways.

“Control engineers can no longer afford to be satisfied with a controller’s performance by viewing how straight the lines on the control chart are,” says John Snodgrass, process control engineer for Chemtura Corp.’s Morgantown, WV, specialty chemical plant.

“In today’s market, with today’s technology, typical operators aren’t typical anymore. They don’t just turn valves. Control engineers shouldn’t be typical either,” says Snodgrass. “They should be looking at the information they have and trying to determine what they can do make product more efficiently. If they don’t, it won’t be long before there won’t be a business anymore.”

MESA International, a trade organization constellated around manufacturing execution systems (MES), has actively investigated KPIs since early last year. In October 2006, it published an initial report on its efforts called “Metrics That Matter: Uncovering KPIs that Justify Operational Improvements.” But MESA concedes it’s just scratched the surface of a very complex issue. Consequently, MESA working groups are delving deeper still, particularly into the labyrinthine linkages between KPIs at different business levels within organizations. A common thread is the control layer of a plant, where the data that feeds many KPIs is generated. Another common element is MES. That’s where aggregation of the data and context typically happens before it’s passed up to enterprise systems and their dashboard and video wall outputs that executive management sees.

KPIs and MES are becoming critical elements to running a plant, because they’re critical to running a business. And, in today’s world, anyone not thinking about the business isn’t as keyed in to business performance as they should be.

Engineering to money

“Everything a control engineer does eventually rolls up into money,” says Jim Christian, product manager for Honeywell. “It’s important to know how what you do contributes to the business. Stable operations translate into greater reliability and better throughput, longer catalyst and equipment life, and reduced use of chemicals. All are measurable.”

One way for control engineers to think about KPIs is “to understand how what you do contributes to your company making money,” says Christian. “What measurements do you need to track to know you’re maximizing value?”

A vast, widely prevalent disconnect exists in most organizations today, at various levels of conceptual abstraction as well as within data flow linkages. “Many of our customers view KPI initiatives as an engineering exercise to collect data,” says Claus Abildgren, marketing program manager for production and program development for Wonderware. “They don’t understand the key needs of the business-what are the pieces of data that the rest of the business needs to make decisions.”

The disconnect is from the bottom up and from the top down. This was revealed in the survey behind the report that MESA developed. “The big surprise for us was how few felt they had a strong structure of linkage from financial goals and metrics down to the shop floor,” says Julie Fraser, principal at Industry Directions, a Boston-area industry consultancy. Fraser was contracted to help drive the MESA “Metrics That Matter” project. “Only 3% of the companies we interviewed for the study said they had strong linkage. We didn’t expect it to be huge, but we didn’t expect it to be that small either.”

Contributing to the problem is structural weaknesses in technology infrastructure-in other words, an inability to handle the vast number of applications and amounts of data now being generated. “AMR has worked with manufacturers who have over 5,000 point solutions [applications] in their portfolio,” says Colin Masson, research director for supply networks operations for Boston-based AMR Research.

Under such circumstances, “it’s not trivial to construct metrics at a single site, let alone across multiple sites. That’s not even taking into consideration performance data composed of millions of readings a day and putting that into some business context that has meaning at a higher level,” he says.

Growth of data models

Such a wealth of data possibilities is contributing to a growing emphasis on standardization of manufacturing data models that can establish commonality.

This desire for a comprehensive manufacturing model is one of the market drivers behind the surge in interest in MES, for models are core to functionality of this software. It’s also what’s prompted automation and human machine interface (HMI) vendors to invest in model-driven integration infrastructures, such as Rockwell Automation’s FactoryTalk, GE Fanuc’s Proficy, and Invensys’ Infusion platforms. These create “one common computing environment,” in the words of Peter Martin, vice president of strategic ventures for Invensys.

Other factors driving interest in MES and KPIs are increasing product and manufacturing complexity and regulatory compliance needs. Align Technology manufactures a line of individually custom-designed orthodontic appliances used to properly align teeth. Orders are acquired at its Santa Clara, CA, headquarters, then transmitted to its facility in Costa Rica where clinical technicians create 3-D representations. These are then sent back to prescribing doctors for verification, before work orders are transmitted to the company’s Mexico production facility.

Align Technology turned to MES to enable it to recover the detailed visibility of manual tracking that was lost when it implemented an enterprise resource planning (ERP) system. It uses Production Centre MES, a component of the Rockwell Automation FactoryTalk platform.

“We manufacture 50,000 custom parts every day-and every day it’s a different 50,000,” says Michael Henry, Align Technology CIO and vice president of information and technology. “The KPIs we’ve focused on initially are public facing ones-cycle times and gross margins.”

By providing greater visibility into the flow and status of work orders, MES was instrumental in attacking problems that had driven up cycle times and eaten into gross margins. Real-time visibility into the status of work orders in the geographically distributed process flow helped Align Technology identify bottlenecks and smooth the flow into a more seamless stream, from order acquisition to finishing and polishing at the end of the production line.

“Cycle times, which were two weeks, are down to five days. And gross margins that were 58% are now up to 69-70%,” Henry says.

Regulation helps?

Business metrics such as cycle times and gross margins are relatively common. Determining which manufacturing metrics are critical to track can be more challenging-unless you’re in a regulated industry. Utica, NY-based ConMed Corp., manufacturer of laparoscopic surgery products, patient support and other products, is bound by U.S. 21CFR Part 820 regulations outlining Good Manufacturing Practices (GMP) for medical device manufacturers.

“We operate in a tightly regulated industry, which determines which KPIs you must track and trend in your operations. We have to validate the process to begin with to determine the variable data, such that when I set these indicators, and the numbers are being met, I know the process is stable,” says Bill Wheatley, ConMed manager of manufacturing engineering.

“After that, we’re looking at: first pass yields, are we staying capable, is preventive maintenance effective, [and] are we preventing breakdowns.” Implementing MES was crucial to streamlining the process, Wheatley says. ConMed uses Visiprise MES.

How does a company determine which KPIs to use? Ideally, it’s a top-down decision. “In concept, you want to take top-level goals and strategy and build out departmental metrics and link those all the way down,” says Fraser of Industry Directions. “You want to take manufacturing metrics…right down to the machines.”

Eliminating boundaries

The whole issue of KPIs is exceedingly complex and, as a “science,” is still young and evolving. But progress being made is looping downward evermore inclusively into the domain of control engineering. As work in the field is revealing, everything is indeed interconnected.

“The traditional approach over the years has held that automation, MES, and IT are three individual layers,” Martin says. “But it’s an artificial separation. It’s been necessary, he says, because past technology required that problems be segmented to deal with the unique requirements at each level.

As the technology evolves, “in time that separation is going away,” Martin says. The push for KPIs linked from top floor to shop floor is driving the business case for that. And in the end, it truly is all about the business case.

That’s what control engineers need to grasp and master. Forget the flashy data walls and Web-enabled dashboards. Focus instead on the metrics that feed those broadcasts. Your company’s future will be increasingly dependent on converting control data into strategic intelligence.

KPIs in action

Frank O. Smith

Performance measurement is not static: it evolves as performance issues vary, as the market strategy changes, as technologies and the means to measure and record performance evolves over time. Sources of KPIs that others are using include research from MESA, AMR, and Aberdeen. Here are specific recommendations from users.

“We manufacture 50,000 custom parts every day…. The KPIs we’ve focused on initially are public facing ones-cycle times and gross margins.”

“We operate in a tightly regulated industry, which determines which KPIs you must track and trend in your operations. After that, we’re looking at: first-pass yields, are we staying capable, is preventive maintenance effective, [and] are we preventing breakdowns.”

“Corporate division headquarters set up the specific KPIs they wanted us to use.”

“We put no more than four [KPIs] in front of an operator at any time.”

“Our company has determined as an organization that there are four process areas that the enterprise needs to focus on. These include: financial; process excellence; quality; and environmental health, safety and security. Everything cascades down from those.”

“At the operator level, we use the real-time accounting measurement of cost-per-batch. With that an operator can drive down costs and keep quality high. The next layer up doesn’t want to see the cost of everything, but [wants instead] variance-to-budget of production, or variance-to-budget from department to department. It’s all based on the same data that flows up.”

For more information visit:

http://www.aberdeen.com/

http://www.amrresearch.com/

http://www.gefanuc.com/

http://www.honeywell.com/

http://www.mesa.org/

http://www.rockwellautomation.com/

http://www.invensys.com/

http://www.visiprise.com/

See also:

“Proving Control System Performance” under www.controleng.com/archive July 2006.

LOAD-DATE: January 17, 2007
 

The Dashboard Spy Business Intelligence Dashboards Blog

Building an Executive Dashboard in Excel 2007 with Conditional Formatting

Thursday, February 1st, 2007

Latest News in Excel Dashboards: New functionality for Excel based Enterprise Dashboards.

One of the truly exciting improvements in Excel 2007 for us avid enterprise dashboard project team members is the extent of the conditional formatting of the cells. Depending on logic related to the value of the contents of the cell, you can assign colors (think heat map visualizations) or icons (think red/green visual KPI indicators).

Here are a couple of excel 2007 demo videos that give a glimpse of the new features that you will definitely be using when building an executive dashboard.

This first video has no sound so think of it as an early silent movie about business intelligence visualization! Watch the cells as the person quickly drops down the conditional formatting options.

http://video.google.com/videoplay?docid=-4115540572629796916

This next one does have sound. You may want to skip straight to the latter part on the formatting options.

http://video.google.com/videoplay?docid=-1192618361577555007

And here is a quick tour of some new Excel 2007 features. This guy blows through 5 new features in 30 seconds!

YouTube Preview Image

For reference, here is a link to some more info on Excel 2007.

Tags: Excel Dashboard, Excel Dashboards, Excel Dashboarding, Dashboards with Microsoft Excel

The Dashboard Spy Business Intelligence Dashboards Blog

If you are new to enterprise dashboards, you really must start by reading the book by Malik:

Enterprise Dashboards: Designs & Best Practices for IT

To give you a flavor of the wonderful nuggets of enterprise dashboard knowledge, here is a quote from Mr. Malik in which he talks about the SMART elements that enterprise dashboards should have:

So, let us establish the basic characteristics specific to an enterprise dashboard with a useful acronym—SMART. A dashboard must be SMART in that it contains the following underlying elements, which are essential for success: