Analytics on Channel Rebate Programs Enabled Fine Tuning of Sales and Marketing Strategies

Established in 1997, the client is a world leader in developing and commercializing first-or-best-in-class therapies for rare genetic diseases. Headquartered in California, US, the client has operations spread across 20+ countries and has 2500+ employees worldwide.

Background

Customer had implemented additional modules of ‘Trade Management’ and ‘Advanced Pricing’ in Oracle eBusiness System (EBS) for Channel Rebate functionality and wanted to obtain insights about the effectiveness of its rebate programs.

DiLytics’ Solution

DiLytics extended the current report solution in Oracle Analytics by

  • Extending Enterprise Data Warehouse (EDW) to create new tables and add columns to existing tables
  • Developing Extract Transform and Load (ETL) code using Informatica to extract Channel Rebate data from EBS into EDW staging tables
  • Writing SQLs to extract Channel Rebate data from EBS to staging tables
  • Developing ETL code using Informatica to load Channel Rebate data from the EDW staging tables into Facts and dimensions
  • Modelling the extended EDW tables in OBIEE to create metrics and attributes

DiLytics implemented a solution on Oracle Analytics that involved:

  • Loading planned data from Oracle Advanced Supply Chain Planning and actual manufacturing orders execution, and inventory data from EBS into Data Warehouse
  • Building metrics, KPIs, dimensions and hierarchies on the operational data, planning data, inventory data, and manufacturing execution data in Oracle BI Server
  • Building reports, dashboards, conditional alerts, and guided navigations in Oracle BI Presentation Server

It has also provided reports on the following

  • Channel Rebate Offer
  • Channel Rebate Accrual Report
  • Channel Rebate Claim Report

Business Benefits

Key business benefits to the client included:

  • Improved Visibility: with a clear understanding of how its products are performing in the market, allowing the company to adjust its sales and marketing strategies accordingly
  • Enhanced Decision Making: on how to allocate resources to optimize channel rebate programs including deciding which products to offer rebates on, what levels of rebates to offer, and which channels to target
  • Improved Relationships with Channel Partners: understand how channel partners are performing and where they need support

Technical Stack

Source System(s): Oracle EBS
Data Integration Tool: Informatica
Data Warehouse: Oracle Business Analytics Warehouse

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Enterprise Data Warehouse Implementation Enabled Better Business Performance

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.