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.

« Diversity Dashboard
Focus on Priorities with Desktop Dashboards »

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:

Here is the write up from the contest pages:

Target User

Bristol Myers Squibb Regional Sales Manager

Content

The dashboard shows all of the information that a Bristol-Myers Squibb Regional Sales Manager (RM) requires to run his business on a single page, including

  • Cash
  • Cash Growth
  • Market Share
  • Market Share Growth
  • Competitive performance

It also provides a breakdown of a region into different areas along with their KPI key performance indicators. Effectively, it shows all the key performance indicators for a product at all the required levels.
 

Purpose

With all the key information available on single screen, it allows Managers and Executives to compare and evaluate performance of a product at various levels of geographies.
 
Effectiveness

  • Rich data covering up to 10 data sources on one single screen.
  • Able to provide the business summary of a product at a glance for a selected geography.

 
Features

  • Tri-color alerts for Sales vs. Target catering the needs of the business.
  • Trends for Cash, Cash Growth, Market Share and Market Share Growth.
  • Trends for Market Share for all the products within the specific market.
  • Deviation Charts to evaluate performance of each Area against the overall national figure.

 

Business Background

The Regional Dashboard is just one of a series of around 10 dashboards, and 100 operational reports developed for Bristol Myers Squibb’s sales force and Sales Operations Management in 2008.
 
The parent application is in use at BMS UK headquarters, and also with several hundred sales staff. The data is sourced from around 15 separate pharmaceutical feeds, and fed into a central data warehouse. The reporting environment is Microsoft’s BI platform, Analysis Services. The Reporting and Analytics toolset is the XLCubed suite, with report delivery through XLCubed Web Edition. The web based reports are fully data connected and dynamic, such that when new data is loaded into the warehouse layer it is instantly available in the reports, significantly reducing ongoing maintenance.
 

For more background on the application see the case study pdf:

Bristol Myers Squibb Pharmaceutical Sales Case Study

 

The other winning excel dashboards:

Excel Bank Dashboard

Medical Practice Management Dashboard

 

Tags: Executive Dashboard, Excel Dashboards, Dashboard Contest Winners, Microcharts 

 

Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.  


What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.  

One Response to “3rd Place Excel Dashboard is for Pharmaceutical Sales”

  1. mr tom Said on August 6th, 2008 at 4:28 am quote

    Interesting that none of the winning dashboards contain any real bling or excessive colour. One might think that function was a higher priority than form. ;)

    Well done all.

Leave a Reply




Last Modified: Tuesday, August 5th, 2008 @ 11:38

This business intelligence dashboard blog entry was posted on Tuesday, August 5th, 2008 at 11:38 am and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Want to see a different randomly selected business intelligence dashboard example? Click here to view another Digital Dashboard from the Dashboard Spy.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Learn how to create Excel dashboards.

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?