The Dashboard Spy

July 31, 2006

Enterprise Dashboards for Agriculture – Hog production executive dashboard

Filed under: Dashboard Screenshots — Tags: , — dashboardspy @ 9:55 am

Dashboard Software Focus: Agricultural Dashboards

We’ve all heard about the demise of the family farm and the shift towards farming as big business. Did you know that half of hog production (traditionally dominated by small operators) is from large scale, multiple-site operations of over 50,000 head? The impact of this for us enterprise dashboard types is the growing need to manage agriculture via business intelligence tools.

Let’s take a look at dashboard software. Here is an enterprise dashboard from a hog production concern. The underlying dashboard product is the Farm SERVey Executive Dashboard by Farm Business Software Systems, Inc. They sell quite a few pig production software packages with great names like PigChamp, PigWings, and my favorite moniker, PigFlow/CashFlow.

The enterprise dashboard screenshot shows hog production KPIs such as Sales Trends, Percent Sold, Costs, Projections, Pigs Weaned per Week: 

Hog Production Enterprise Dashboard

The graph that catches my eye is this “upside down” one. It’s unusual to see such a graph. I’m no pig farmer, so I don’t know if it indicates losses per load, but does the lack of a positive portion of the graph mean that it never is a positive number? Here is a detail screenshot:

Agriculture KPI Dashboard

Here is a look at typical hog production details:

Pig Weaning Enterprise Dashboard

Homework: If you are looking to learn more about the business of farming, start with these books on agricultural business practices.

Tags: Dashboard Software, Farming Dashboards, 

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 presidential campaigns, we’ve examined enterprise dashboards from all aspects of business. I’ll do my share to keep snooping around for those elusive dashboard screenshots that keep this dashboard screenshot collection interesting.

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.

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.

Advertisements

July 28, 2006

Beer Marketing Dashboard – Raising a glass to enterprise dashboards

Filed under: Dashboard Screenshots — Tags: — dashboardspy @ 9:27 am

You know you are a total enterprise dashboard addict when every little thing that you see makes you think of KPIs, portlet layouts and drill-downs. I’m outside having a beer, admiring the glistening drops clinging to the bottle, when I am reminded of a beer marketing dashboard in my collection. I wonder how long it would take me to dig it up. (OK, I know it’s kind of bizarre, but I believe I have the world’s largest collection of enterprise dashboard screenshots – and sometimes it’s hard to locate particular dashboards. I got it – I need a dashboard just to track my dashboards!).

Here is a marketing enterprise dashboard used by a famous beer manufacturer:

Beer Marketing Dashboard Logon

The other screenshots are not in English, but, hey – beer is beer, right? This screenshot of the dashboard shows the top 5 brands. This is a rich client application. By selecting different dropdowns, you can generate a new chart below:

Beer brand dominance

Here is the Customer Brand Tracking section of the enterprise dashboard. Share of market statistics are provided by Neilsen.

Customer Brand KPIs

Got to go. All this enterprise dashboarding is making me thirsty. Cheers!

Homework: Study this great book on using dashboards for marketing: Marketing by the Dashboard Light. Also, 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 27, 2006

Web Measurement KPIs – Choosing the best metrics for web analytics enterprise dashboards

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

For many people, the most commonly and closely measured thing is their website or blog. And, of course, for many businesses, this is a hyper-critical area. Optimizing the performance of their websites has a direct impact on the top and bottom lines. We’ve seen many enterprise dashboard techniques applied to web analytics. In fact, many avid Dashboard Spy readers belong to the web measurement world.

I wanted to bring to your attention the KPI selection chapter of the book, Website Measurement Hacks: Tips & Tools to Help Optimize your Online Business. O’Reilly offers this free download of the chapter. It’s well worth the quick read. Here are a few screenshots I took from the KPI hacks. The tips offered apply to all KPI selection, not just for web analytics dashboards.

Here are a few suggested KPIs for web measurement:

Web Measurement KPI

This is a sample web measurement KPI worksheet. The suggested Key Performance Indicators include: Percent New Visitors, Percent Returning Visitors, Ratio of New to Returning, Conversion Rates, Average Order Value, Sales per Visitor, Customer Retention Rate, and my favorite, Percent of Visits Under 90 Seconds. (That’s a KPI that tells a lot!)

Web Analytics Worksheet

And here is a screenshot of a web measurement enterprise dashboard:

Web Analytics Enterprise Dashboard

Homework: Do be sure to check out the free download and read it carefully. If you are looking for more background on web measurement, check these books on web analytics.

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 26, 2006

Finding the Right KPIs for Enterprise Dashboards – How MIT did it for airline operations control

Filed under: Dashboard Screenshots — dashboardspy @ 11:56 am

How do you pick your KPIs for your enterprise dashboarding projects? If you are like most of us, we interview business users and scribble down their kpis, figure out what datasources to tap into and then code the calculations into our dashboards. Simple, right? But do we ever stop to think about how effective those KPIs are? Well, thanks to a Dashboard Spy who hangs out with some smart people at MIT, we get to see another way of choosing KPIs. Seems pretty good to me – what do you think? Time to start hiring MIT grads for enterprise dashboard projects? If you want to read the MIT paper for yourself, take a look at this pdf titled Airline Operations Feedback Control with KPIs.

First, you start off with a KPI brainstorming session and interviews to produce plenty of KPI candidates:

KPI Process at MIT

Then you rate each potential KPI according to various characteristics. For example, detectability is a key. If changes in KPI value have little impact on the output, it makes a poor KPI:

Detectability makes a good KPI

And you look at how precise a KPI is:

KPI precision is good

Here are some sample KPIs studied by MIT for airline operations:

Airline Operations KPI

Airline Crew KPI

Homework: Need to study up on these types of KPIs for your enterprise dashboard? Start with this list of books on airline operationsIf 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 25, 2006

Customer Metric Enterprise Dashboard – Tracking fashion business KPIs

Filed under: Dashboard Screenshots — dashboardspy @ 8:57 am

Thanks goes to the Dashboard Spy who shared this enterprise dashboard meant to monitor customer metrics for a fashion business. The underlying product used is by pilotsoftware.com and it’s a role-based, multiple data source enterprise dashboard. Note the view is chosen via the dropdown selector. It is showing “Customer Dashboard”, hence the appearance of the Key Customer Metrics, Trend on Returns, Top Products by Returns, and Top Stores by Returning Customers portlets. The Key Customer Metrics include: Number of Customers, Number of Repeat Customers, Advertising Effectiveness, Loyalty Rates, Revenue per Customer, Gross Margin, and Returns per Customer.

Customer Metrics Enterprise Dashboard

Homework: Need to brush up on fashion/apparel/clothing retail management metrics? Start with these books on clothing retail management.

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.

July 24, 2006

Dashboard Software: Terrorism Incident Dashboards – Tracking incidents, fatalities, injuries with a knowledge base

Filed under: Dashboard Screenshots — Tags: , — dashboardspy @ 9:52 am

Dashboard Software Topic: Using dashboards as a front-end to a world-wide terrorist incident tracking database.

Here’s a very nicely designed front-end to an interesting database. I particularly like the incident analysis wizard where you choose the visualization you want.

Unfortunately, terrorism has not gone away. A comprehensive terrorism activity database with data reaching back as far as 1968 is available at http://www.tkb.org/AnalyticalTools.jsp The database is presented via a dashboard-type interface as the following screenshots show. One can only hope, that in some way, our advances in Knowledge Management, Business Intelligence and Enterprise Dashboards can contribute to the fight against this terrible activity.

Terrorism Incident Dashboard

Query Dashboard

Incident Dashboard

Tags: Dashboard Software, Dashboards 

Homework: Read up on terrorism here: books on terrorism

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 21, 2006

E-learning Course Dashboard – Creating online courses

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

In doing some research for a Dashboard Spy reader who was interested in creating a dashboard for elearning management and what performance metrics should accompany such an enterprise dashboard, I came across the ATutor Learning Content Management System, an excellent open source product. I’ll get to the Dashboard Spy reader’s request for e-learning management KPIs in a future post, but here are some screenshots of the ATutor product. It’s basically a way to create, serve and consume online courses that you can create. It’s quite robust. You can log in to the demo on the site and check out the features. Here are some dashboard-style screenshots for a taste.

E-Learning Dashboard

This is the dashboard for the classes that you belong to:

Listing of courses

You can even apply different themes to the course portal that you create:

Different themes for elearning

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 20, 2006

Commercial Airline Executive Dashboard – SAS/GRAPH Implementation for BI Contest

Filed under: Dashboard Screenshots — Tags: , — dashboardspy @ 8:50 am

Dashboard Software Topic: SAS Dashboards 

This just in from Robert Allison, a Dashboard Spy reader who is contributing quite a few enterprise dashboards to our little collection here. Thanks!

Here’s another original/unique dashboard I’d like to submit to your collection.  This one was created to enter into the b-eye-network’s recent contest for question #4 (their “dashboard” question). Here is the website describing the data & question:
http://www.b-eye-network.com/newsletters/data_viz_contest/data_viz.html

They supply an excel spreadsheet with the underlying data and the following scenario:

You are a consultant who has been hired by a U.S. commercial airlines to design a dashboard for its executives. The information that the executive team wants to monitor has been identified and now its your job to create the dashboard’s visual design. You must try to display all of this information in some manner on a single screen such that the executives will be able to quickly identify anything that needs their attention and then have the means to discern enough about the situation to decide if they can ignore it for now or must perhaps take some action. It is up to you to determine the appropriate manner, level of detail, and means to display each piece of information.

Since the contest deadline was last Friday, I guess it’s safe to show this one in public now 🙂 For those of you who want a look behind the scenes of my implementation, here is a link to the interactive web output, and the SAS/Graph code used to create it:

http://robslink.com/SAS/b-eye/beye4.htm
http://robslink.com/SAS/b-eye/beye4.sas

Commercial Airline Executive Dashboard

Tags: Dashboard Software, SAS Dashboards 

Homework: If you are new to SAS/GRAPH, of just not sure of what it is, check out these books on SAS/GRAPH.

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.

Older Posts »

Blog at WordPress.com.