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.
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
- 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
- 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