The Dashboard Spy

October 23, 2007

Ask The Dashboard Spy Video Tutorials Launched

Filed under: Dashboard Screenshots — Tags: , , — dashboardspy @ 5:42 am

Dashboard Spy readers can now have their dashboarding questions answered by the Dashboard Spy in video format. “Ask The Dashboard Spy” is a series of video tutorials that explore various business intelligence dashboard topics.

The first video is about “Coding Dashboard Portlets in HTML” and it explains a nifty trick on how to produce a live pie chart that displays your latest data. This dashboard tutorial is meant as an introduction to coding and will be of interest to dashboard project team members who have always wanted to get more technical.

Use the link above to view the dashboard video on the main Dashboard Spy site.

Here is a look at the portlet that you will see implemented. The HTML and CSS is straight-forward. The magic comes in how we code the pie chart. Using google docs spreadsheet web services, we can easily implement a live pie chart that is driven by values on a web-based spreadsheet.

Dashboard portlet sample

Tags: Ask The Dashboard Spy Video Tutorial, Coding Dashboard Portlets in HTML, Dashboard Software

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.

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

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.

Blog at WordPress.com.