Dashboards by Example
    Dashboard: Examples & Best Practices.   From Excel Dashboards to Enterprise Business Intelligence, these dashboard implementations contain KPIs, metrics, charts, trends and more.

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 January, 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.

Survey of Business & Technical Benefits of Enterprise Dashboards

Wednesday, January 17th, 2007

The following two charts show the business and technical benefits of enterprise dashboards as reported by Hurwitz and Associates. The most significant business benefits of dashboards (as reported by users) are Improved decision making, Faster time to market, Improved competitive advantage, Improved customer satisfaction, Improved productivity, and Improved profitability. The most significant technical advantages of enteprise dashboards are: Rapid problem detection, Respond to KPI changes faster, reduce manual and administrative work, Improve organizational alignment, Identify problems, Manage exceptions, Better visualization into remote operations, and Increase operational efficiency. Some of these seem like business benefits to me.

Nice listing of benefits for you to use in justifying your enterprise dashboard project. Good luck.

top business benefits of enterprise dashboards 

Top technical benefits of enterprise dashboards

PS: If you find yourself part of an enterprise dashboard effort, you must study Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.

 

The Dashboard Spy Business Intelligence Dashboards Blog


Excel Dashboard for Monitoring the Competitive Landscape

Tuesday, January 16th, 2007


Here is a look at how an excel dashboard can be used to compare the financial ratios of competing companies. It comes from excel dashboard guru, Charley Kyd, who provides sample excel dashboards at his site. This enterprise dashboard provides a graph of a company’s sales and profits and lists the company’s competitors. Various financial ratios are then provided so that the user can perform a competitive analysis. The data is provided via data from live links to an OLAP database of public data from Hoovers.com. The KPI categories include: Operating Ratios, Profitability Ratios, Financial Ratios, Cash Flow Ratios and information on Revenue Growth. Here is the screenshot of the excel dashboard:

excel dashboard competitive landscape

Need to review charting with excel? Start with Excel Charts for Dummies.

Tags: Excel Dashboard, Enterprise Dashboard, Executive Dashboard

The Dashboard Spy Business Intelligence Dashboards Blog

Information Technology Risk Management Dashboard Screenshot

Friday, January 12th, 2007

Enterprise level concerns about the possible risks regarding information technology systems, projects and initiatives are covered nicely by this IT risk management dashboard. 

This IT Risk Management Dashboard contains sections for metrics involving Technology Risk, Security Risk, Outsourcing Risk, Risk by Organization, Risk by Type and Major Investments and Project. The executive dashboard shown is the Technology Risk Dashboard. Metrics include IT Outsourcing Expenditure Tracking (Budget, Forecasts, Actual), Server Availability, Client Outages, Current Alarms, and Transaction Failures by System versus Gross Revenue.

IT Risk Management Dashboard

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.

The Dashboard Spy Business Intelligence Dashboards Blog

Construction Project Webcam Dashboards

Thursday, January 11th, 2007

Some projects, such as construction and other site-specific projects, really benefit from an approach to enterprise dashboards that incorporate live video views. Here is a product from oxblue.com that uses webcams effectively to help the enterprise dashboard user both navigate between and monitor projects.

We start off with an overall dashboard that provides a tiled view of various construction projects. The individual projects can be accessed via left side menu navigation or by simply clicking on the photo thumbnail.

Construction Project Executive Dashboard

This second page of the enterprise dashboard application is annotated with usage notes:

Project Dashboard Webcam

 

Note: Hey, Dashboard Spies!: Do you know how smart you are getting by reading The Dashboard Spy? From pig production to airplane crew size optimization to monitoring construction projects, we’ve examined enterprise dashboards from all types of business divisions. Let’s keep those enterprise dashboard screenshots coming. PS: 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.

Federal Government Agency Program Management Office Dashboard

Wednesday, January 10th, 2007

Government agencies, both civilian and defense, have been under intense pressure to show value in their projects and alignment of programs with their charters and goals. This has lead to a swell in implementations of PMOs and their associated business intelligence systems. Here are a couple of quick enterprise dashboard screenshots of one agency’s Program Management Office dashboard. Sorry for the lack of detail. These pmo dashboards seem to be based on the Niku (Clarity) product.

Government PMO dashboard

Federal PMO Dashboard

So who is the Dashboard Spy? No one really knows, but his growing collection of enterprise dashboard screenshots has captured the imagination of the executive dashboarding community. From excel dashboards and custom-built business scorecards, to xcelsius and flex-based visualizations, the dashboard screenshots at dashboardspy.com serve both as nuggets of inspiration and warnings of what not to do on an enterprise dashboard. These hits and misses will enlighten and entertain. Technology-neutral, and always business-driven, the Dashboard Spy website is the place to go to learn about the latest enterprise dashboard packages. Check out the Dashboard Spy’s latest recommended book, Information Dashboard Design: The Effective Visual Communication of Data

The Dashboard Spy Business Intelligence Dashboards Blog

HR Financial Data and Benefits Enterprise Dashboard Screenshot

Tuesday, January 9th, 2007

Dashboard Topic: Human Capital Dashboards, HR Financials Dashboard

Here is an excellent enterprise dashboard-style depiction of key HR financials data. These financial dashboards draw upon consolidated payroll data and other key financial metrics to present an “at-a-glance” summary of payroll data rolled up as corporate financial health metrics.

The first financial dashboard is titled “Workforce Cost Dashboard” and features the following KPIs:

Revenue per Employee, Profit per Employee, Total Workforce Cost, Value Added Per Employee, Human Capital ROI.

The second dashboard is called “Compensation and Benefits, Tax and Social Security Dashboard” and features metrics such as productivity metrics, pension benefits per employee and expatriot costs.

Human Resources Financial Dashboard

Related Post: Have you seen this Human Capital Dashboard?

Tags: HR Financials Dashboard, Human capital, Human Resources metrics, Human Capital dashboard, Benefits Management Dashboards

>>>Update for Dashboard Spy readers: Ok you excel power user, financial analyst types out there in the Dashboard Spy readership - here is some hot news for you. This book just came out: Performance Dashboards and Analysis for Value Creation (Wiley Finance). I’ll be checking it out, but it looks like a real practioner’s read. The author proposes a methodology for increasing value called the Value Performance Framework. There is a companion CD with Excel models and sample performance dashboards.>>>>

The Dashboard Spy Business Intelligence Dashboards Blog

Corporate Performance Dashboard - Linking Metrics to Improvement Projects

Monday, January 8th, 2007

A Dashboard Spy reader sent me these two performance project management screenshots. Although it’s not apparent from these screenshots, the focus of the system is to tie corporate performance metrics to improvement projects involving those metrics. The intent is to identify which metrics have no associated improvement projects and that prevents wasting resources on orphaned projects that are not related to a specific corporate metric.
Metrics Dashboard

 Project Status dashboards

The Dashboard Spy Business Intelligence Dashboards Blog

B2B Sales Dashboard Metrics - Article on how to put six sigma enterprise dashboards to work on business to business sales management

Friday, January 5th, 2007

Put six sigma to work in business to business sales. That’s the message in this great article on using six sigma enterprise dashboard metrics to uncover the best ways to build,  maintain and grow relationships with customers.

Here are some great quotes and diagrams from the article:

Focus on What Customers Value in the Buying Process

Six Sigma can have a direct impact on sales results if a company is disciplined in keeping the focus on what customers value in the buying process. This is not about product attributes, customer service or sales support – although data will probably be uncovered that will lead to improvement opportunities in these and other areas. What it is about is the needs of buyers when making a major purchase decision.

Here is how the standard Six Sigma DMAIC roadmap can be used to strengthen the relationships between salespeople and customers.

Define: What Does Sales Expect to Gain?

The challenge in the Define phase is to convince the sales organization that this is a way for them to improve their relationships with key customers and prospects by gathering unique insights into how buying decisions are made.

Measure: A Loyalty Baseline

Gathering data in a way that allows the team to draw conclusions and act on them is critical. Conducting short interviews with buyers and prospects is a good way to understand their critical-to-quality attributes (CTQs) relative to the buying process. This data can be collected fairly quickly but does require up-front planning and expertise in survey design. Many companies use an objective third party to conduct the interviews. Customer loyalty extends beyond satisfaction, and directly impacts business results. The customer who values the product or service will continue to buy and will promote it to others.

Customer Loyalty Dashboard KPI

Analyze: What Do Customers Value?

Analyzing qualitative data is different from reviewing Pareto charts, statistical print-outs and customer survey results. Time should be allowed for the project team to absorb the data and engage in testing different hypotheses. There are three steps in analyzing the data.

Identify key themes. Engage a team of salespeople and other stakeholders in reviewing the feedback from the interviews. Make it easier for them to interpret the findings by organizing it around key themes and contrasting the responses from customers to those of salespeople. Be sure to support the key themes with specific examples so the flavor of the comments are retained and the findings resonate with members of the sales team. The graphs in Figure 2 illustrate how one company used interviews with customers and sales representatives and a short survey to identify opportunities for improvement and measure alignment.

Six sigma sales metrics

Improve: How Should the Company Sell Differently?

Once it has determined how salespeople deliver value to customers, the project team can develop a focused action plan. Common actions include:

  • Changes in pricing strategy: A uniform pricing strategy may not meet the needs of all customers.
  • More involvement in product delivery: Salespeople may need to work actively to stay close to the customer once the deal has been closed.
  • Training to improve consulting skills: Need may be found for training/development of the sales force.
  • Reorganization of the sales function: Internal barriers need to be removed so that the company can more effectively serve customers.
  • Cross-functional process reengineering: Customers may be frustrated by the way in which the company integrates sales/credit/distribution, etc.
  • Sales rewards/incentives: The company may need to change its sales incentive scheme to promote strong relationships.
  • Revised value proposition: Customers can recommend fundamental changes in how the company positions and markets its product.
  • Specific actions to support one major customer: There may be specific issues with one large customer that merit deeper investigation and action planning.

Control: Measuring to Sustain Improvements

Improve is the exhilarating phase – changes are implemented and results begin to be seen. To sustain the momentum, there needs to be a process in place to capture and track data on an ongoing basis. “You need to track data from lead generation to close,” said GE’s Moreland. That can mean going beyond the standard sales measures that capture activity but do not necessarily link to revenue growth. Some sample measures are listed in Table 2.

Sales Metrics Dashboard

A simple dashboard can keep the CTQ’s in front of both company leaders and members of the sales force. These key measures should be communicated regularly on a quarterly or monthly basis.

Sales Process KPIs

Be sure to read this great article on six sigma sales metrics for enterprise dashboards.

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: