The client – a major global pharmaceutical company with sales of over $21.4 billion – uses MicroStrategy to report on and analyse data in its sales prescriber data warehouse (SPW). Approximately 250 employees use MicroStrategy’s web-based analytical tools to determine market share, easily explore cost and profit data, and track the performance of new products. As a result, employees are making more effective business decisions that increase sales and drive market share gains.
The MicroStrategy platform distributes 70,000 reports within a 24-hour window each month. Employees can pull up reports via its sales force portal or run queries, with 20-second average response times, against a one-terabyte Oracle® data warehouse. As a result, end users can view critical pharmaceutical sales information in a matter of seconds and quickly make decisions to optimise market share with a particular NHS Trust or prescription benefit management organisation.
“MicroStrategy business intelligence gives us a better understanding of the market, and helps us meet expected market share goals for our products. The performance and scalability of our MicroStrategy-based application is remarkable, allowing our users to be more productive and efficient.” Senior Manager Commercial Data Warehousing