Data Warehousing Solution for a Pharmaceutical Company

Customer

The client, a Fortune 100 company Pharmaceutical Company based in U.S.

The Challenge

For a data warehousing project being implemented for a Fortune-100 Pharmaceutical company, following are the key business drivers:

• Lack of organized, End-To-End data warehousing solution system which could provide slice and dice analysis ability covering various business areas like Sales, Marketing, Finance and RISK
• Existing source/transactional system provided limited reporting options
• Make web enabled Data Dictionary available for definitions and business logic details of all data elements of DWH

E2SCorp's Solution

• Classify all the data elements and source systems needed for organization DWH and reporting
• Create a data warehouse that could cover this information
• Asynchronously extract all data elements to feed the data warehouse
• Provide interfaces for RISK and CRM related information
• Provide business objects universes and standard reports for data analysis
• Aid ad-hoc querying and report generation features
• Provide web enabled sales cockpit for executive analysis

Client Benefits

• Admission to and analysis of business information made easy & proficient
• Asynchronous data flow from various data sources captured in DWH
• Ad-hoc queries and reporting features for executive decision making
• RISK data available for SAS Analytics
• Web enabled data dictionary
• Web enabled sales cockpit for executive analysis
• DWH staging area will be extended to serve as operational data source for various other client applications