3rd Place Excel Dashboard is for Pharmaceutical Sales

Executive dashboards are hot IT projects at Bristol-Myers Squibb this year. The sales operations management area at the company has already developed 10 business intelligence dashboards (and 100 operational reports) so far in 2008.

This particular sales force dashboard, developed in Microsoft Excel by Hitesh Patel and Mike Askew of Data Intelligence, was entered into the Microcharts Best Excel Dashboard of the Year contest and won the third-place prize.

Here is the dashboard screenshot. Click on the image to enlarge it. 

 Bristol Myers Squibb Dashboard

Let’s take a look at the background and implementation details of this excel dashboard. Join us after the “read more” link:

Continue reading

Second Best Excel Dashboard of 2008

The Excel Dashboard that placed second best in the MicroCharts 2008 Excel Dashboard Competition was created by Jim Uden. His Outpatient Surgery Center Dashboard shows the metrics for the operations of a health care facility. Owned by a partnership that demands comprehensive reporting, the ambulatory center operations generate large volumes of data that must be digested and presented in a clear and concise manner.

We’ll examine the Excel dashboard itself in a moment, but I wanted to point out this dashboard received a special mention on account of the great documentation and project background that the developer provided with the dashboard. Take a look through this Dashboard Walk-through Document and you’ll be impressed as well. A nice document to emulate in our own dashboard projects, for sure.

Here is the screenshot of the Second Best Excel Dashboard of 2008. It’s a large screenshot, so please click on the image to bring it into full view.

Second best excel dashboard of 2008

We’ll pull some backgound material from that great project document that I mentioned earlier, so please join me in reading the rest of this post by clicking on the “read more” link below.

Continue reading

2008 Best Excel Dashboard

Excel Dashboard Update:

New tutorial walks you through the design, architecture and construction of this Microsoft Excel dashboard:

excel dashboard tutorial

Click here to see the Excel Dashboard Tutorial details.

Excel dashboards submitted as candidates for the best 2008 Excel dashboard design contest run by BonaVista Systems have been evaluated.

Wade Stokes is the winner of the best excel dashboard with his entry of this International Bank Dashboard. Click on the dashboard screenshot to enlarge the image and you’ll see a dashboard that make efficient use of screen real estate through incorporation of the popular sparkline graphic:

Winner of Best 2008 Excel Dashboard Competition

Click on the “read more” link to read some commentary by the dashboard designer:

Continue reading