Portfolios - OBIEE for Pharma Company

OBIEE for Pharma Company

Portfolio Description

BI & Analytics

Client  is one of the leading  and fastest growing pharmaceutical and animal health  product companies in Bangladesh. The have implemented Oracle EBS application but they did not have any proper Business Intelligence system for various management & Analytical reports 

Business Problem : 

  • Missing strategic growth opportunities
  • Failing to take advantage of cost savings
  • Falling down on customer satisfaction
  • Losing your competitive edge


Business Solution 

ICG  designed a proper ETL and developed various management & analytical reports , Dashboard for stake holders , forecasting  and drill down reports. 

Below are the major steps ICG took to implement OBIEE 

  • Assess the current situation
  • Understand current business which need stakeholder’s input
  • Understand Current data which need existing techno-functional experts input
  • Bringing the data in to BI system
  • Clean the data
  • Identify key performance indicators (KPIs)
  • Develop a “Data Warehouse” by transforming existing transactional data to meaningful business intelligence data
  • ETL tool, to help transform the transaction data to meaningful business data
  • Reporting tool, to create all the analytical reports