Project Description

The client was a global provider of research products and services for pharmaceutical advancement, discovery, and development. They did not have an effective way for the CEO and other senior executives and account managers to analyze corporate revenue data.

The Challenge

The client, a global life sciences organization, needed a way to turn corporate revenue data into actionable information, on demand, and deliver it on Apple iPads to the CEO and executive staff as well as the account managers and the field sales team.

Solution Requirements:

  • Enable account managers to review detailed account information with customers
  • Allow CEO and executives to understand the overall current state of the business on a daily basis
  • Include strict access and security standards from the device all the way down to the data itself
  • Ensure account information is not shared amongst account managers
  • Enable different views based on employee level

Chateaux worked with the client to choose:

  • A visualized home page with starting point prompts that set the overall context
  • A series of visualizations including top customers, trends, alerts, and population charts
  • Drill-down paths to hone in on specific data, enabling root cause analysis

Key criteria that required analysis:

  • Choice of database platform (SQL Server, Oracle, DB2)
  • Choice of data source (OLAP, Relational, Transactional)
  • Regulatory and corporate security standards
  • Corporate Hierarchies

Successful implementation of SAP BusinessObjects Enterprise supporting:

  • Complete Dev, QA and Production Platforms
  • Active Directory and SSL Integration
  • Production Team Knowledge Transfer

Data Warehouse Support and Tuning for:

  • Star Schema Models
  • Role-based Security Models

SAP BI Mobile solution with:

  • All levels of sales hierarchy from CEO to Account Manager
  • Response time within 3 seconds for all dashboards
  • Drill down, drill across, and multi-screen visualizations