Excel Dashboard Competition>Pharmaceutical Sales Dashboard
3. Hitesh Patel – Pharmaceutical Sales Dashboard
Developed by Hitesh Patel and Mike Askew of Data Intelligence, for Bristol Myers Squibb. A key report for the Regional Sales Managers, containing the information required to run the business in terms of cash, growth, share, and competitive performance.
Target User
BMS Regional Sales Manager
Content
The dashboard fits all of the information that a Regional Sales Manager requires
to run his business including Cash, Cash Growth, Market Share, Market Share
Growth and competitive performance within one screen. It also provides a
breakdown of a region into different areas along with their 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 coloured alerts for Sales vs. Target catering the needs of the business.
Trend for Cash, Cash Growth, Market Share and Market Share Growth.
Trend 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 on the Data
Intelligence website:
BMSCaseStudy