Case Studies

Pharmaceutical & Healthcare

Personalising and Distributing Information to Over 1,000 Employees

A leading international pharmaceutical company – employing some 65,000 people in 150 countries -selected MicroStrategy to deliver daily mission-critical information on sales and profitability to its employees. Using MicroStrategy platform, the client developed and deployed three business intelligence applications in record time, and anticipates deploying additional Bl applications in the near future. Sales, marketing, production, […]

Services: Accounts Receivable Reporting, Budget Variance Analysis, Cash Flow Analysis, Financial Analysis, Payment and Collection Reporting, Underwriting Requirements

Read more



Pharmaceutical & Healthcare

Using High Volume Reporting to Make Informed Sales and Pricing Decisions

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. […]

Services: Balanced Scorecards, Budget Variance Analysis, Capacity Planning, Cash Flow Analysis, Forecast Capacity and Staffing, Materials Routing, Operations Procurement, Product Management, Supplier Analysis and Management, Yield Planning

Read more



Pharmaceutical & Healthcare

MicroStrategy 9 Reduces Database Preparation Stage of a Project from 300 IT Days to Just 25 IT Days

The client is one of the UK’s leading full-line pharmaceutical wholesalers, with 19 warehouses across the UK, stocking over 20,000 different products, and employing some 3,600 staff. To meet profitability targets, it is vital to track and analyse every detail of over 15 million items that are shipped each week, amounting to several terabytes of […]

Services: Campaign Analysis, Commission Reporting, Competitive Tracking, Customer Loyalty Analysis, Customer Segmentation, Pricing and Promotions, Pricing Models, Promotion Effectiveness Balanced Scorecards, Promotional Lift, Sales Performance

Read more



Financial Services

Helping a rapidly growing Managing General Agent achieve its aspirations with a tailor-made, scalable insurance analytics solution.

How GIROUX implemented a logical data warehouse and advanced analytics toolset to help transform a growing MGA into a business analysing all of its key data for easy and seamless decision making. Executive Summary Client’s challenge To achieve sustainable growth with analytics forming a core capability: Grow through a variety of products and more diverse […]

Read more



Financial Services

Mobile intelligent transacting for better value creation – PlusAccounting

PlusAccounting offers accounting bureau services to major retail, media and financial services organisations across the UK. Its clients require regular updates on the management of their financial affairs including sales, profitability, invoice payment and cash-flow. Traditionally, clients would receive summaries in Excel, which would then be adapted to each client’s business. However, the summaries were […]

Services: Budget Variance Analysis, Compliance Alerting, Cost Analysis, Customer Profitability Analysis, Loan Analysis, Margin Analysis, P&L Reporting, Revenue Reporting, Tax Notification, Taxes

Read more



Pharmaceutical & Healthcare

Improving the efficiency effectiveness of the business process using BI – GlaxoSmithKline

Improving the Efficiency Effectiveness of the Business Process using BI – GlaxoSmithKline  The global team of one of GSK’s therapeutic divisions was involved in pulling information from multiple sources of data including MR hypothesis-testing data to feed into their forecasting models. The process was complex, due in part to the need for local operating companies’ […]

Services: Balanced Scorecards, Budget Variance Analysis, Cash Flow Analysis, Channel Analysis, Customer and market segmentation, Demographic Analysis, Key Profit Contributors, Manufacturing Planning & Engineering, Marketing Spending, Revenue forecasting and targeting, Sales Performance, Sales Trends

Read more



Retail & Distribution

Analysing Purchasing Behaviour to Develop More Effective Personalised Marketing

Employing more than 68,000 people, the client is one of the UK’s leading health and beauty retailers. It uses MicroStrategy for a range of applications including basket analysis, customer segmentation and direct marketing, using the vast amount of data collected from its customer loyalty programme. MicroStrategy has been one of the client’s primary insight tools […]

Read more



Retail & Distribution

Deploying MicroStrategy-based Sales Reporting and Analysis to Over 800 Users

The client is one of the country’s leading online motor vehicle classifieds and consumer information providers.  After an evaluation of competing business intelligence products, they selected MicroStrategy Report Services for enterprise-wide reporting and analysis. Fully integrated with the MicroStrategy platform, MicroStrategy Report Services simplifies the deployment of business intelligence applications throughout the client’s organisation. It […]

Read more



Infrastructure & Transport

Dissemination of strategic or operational insights through personalised and interactive dashboards

The challenge A large UK transport authority lacked access to a unified view of its performance, with the result that lower levels of management were unclear whether they were meeting the performance network expectations. The data was there, but only accessible through compiling it in a complex and unwieldy manual. The solution GIROUX developed a […]

Services: Project Management

Read more



Financial Services

Relying on Easy-to-Use Bl Technology to Forecast Policy, Claims, Exposure, and Reinsurance Data

A leading insurer – operating in the Lloyd’s market with a managed capacity of £850 million – selected MicroStrategy as its enterprise-wide business intelligence standard.  The client utilises the MicroStrategy platform to analyse and report on policy, claims, exposure and reinsurance data, and to provide end users with the ability to understand and report on […]

Services: Channel Efficiency, Customer Analysis, Financial / P&L Reporting, Financial Reporting, Market Basket Analysis, Market Data Analysis, Portfolio Analysis, Refinance Risk Analysis, Research Distribution Client Loyalty Analysis, Trade Floor Reporting, Transaction Volume Analysis

Read more



Retail & Distribution

Improving Purchasing Strategies at a Leading UK Retailer

A major UK electrical retailer relies on the MicroStrategy platform to deliver new management information to its purchasing teams and improve buying strategies. Using MicroStrategy, the client’s new DPP (Direct Product Profitability) application now gives product category managers information on the gross margin of each product and, by integrating data from various sources, presents them […]

Read more



Retail & Distribution

Insights from multiple sources of high-velocity and volatile data

One of the country’s fastest growing wholesalers, the client supplies most independent retailers in the UK. The tight profit margins on its many thousands of products – distributed across 62 nationwide depots – means that achieving the right level of inventory is critical. With inventory checks performed locally it was difficult to optimise inventory levels. […]

Services: Project Management

Read more



Financial Services

Deploying MicroStrategy for Enterprise Scorecarding & Reporting Applications

With over a billion dollars in written premiums, the client is a property and casualty insurer, as well as offering home, auto, business and life insurance. The client expanded its deployment of MicroStrategy with MicroStrategy Report Services to provide enterprise reporting and analysis of sales and loss ratios. More than 300 territory managers, portfolio managers, […]

Services: Claims Analysis, Compliance Alerting, Credit Risk Management, Customer Risk Scoring, Exceptions Risk Management, Exposure Reporting, Financial Reporting, Fraud Risk Management, Hedge Slippage Alerts, Index Performance Alerts, Position Reporting, Prepayment Risk, Underwriting Scorecards, Value At Risk Analysis

Read more



Retail & Distribution

Increasing Efficiency and Profitability via Customer and Product Sales Reporting

The client is one of the UK’s leading soft drink manufactures, with a turnover of some £600 million a year and supplying approximately 250,000 retailers. The company selected MicroStrategy to anchor its enterprise-wide business intelligence applications, allowing the company’s 21 UK offices to gain valuable insights into operations and increase profitability. Following an extensive evaluation […]

Read more