[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1766557987182{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1766557974061{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1766558709997{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Analytics on Channel Rebate Programs Enabled Fine Tuning of Sales and Marketing Strategies
[/vc_column_text][vc_column_text css=”.vc_custom_1766551054612{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]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.[/vc_column_text][vc_column_text css=”.vc_custom_1766556373437{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1766556457628{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]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.[/vc_column_text][vc_column_text css=”.vc_custom_1766556403301{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1766556536560{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics extended the current report solution in Oracle Analytics by[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1766556647731{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- 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
[/rt_list_style][vc_column_text css=”.vc_custom_1766556618469{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]
DiLytics implemented a solution on Oracle Analytics that involved:
[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1766556733081{margin-top: -5px !important;margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- 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
[/rt_list_style][vc_column_text css=”.vc_custom_1766556769578{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]
It has also provided reports on the following
[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1766556796658{margin-bottom: 35px !important;padding-left: 35px !important;}”]
- Channel Rebate Offer
- Channel Rebate Accrual Report
- Channel Rebate Claim Report
[/rt_list_style][vc_column_text css=”.vc_custom_1766557044256{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1766557094294{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Key business benefits to the client included:[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1766557690356{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- 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
[/rt_list_style][vc_column_text css=”.vc_custom_1766557456870{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1766557601330{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]
[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1766557953271{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 75px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”.vc_custom_1766557888970{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics Delivers
[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column css=”.vc_custom_1661424713241{margin-bottom: 25px !important;}”][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]