[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_1767585672135{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1767585643315{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1767585617013{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Analytics on Cost Transparency Enabled Optimization of Cost at Program Level
[/vc_column_text][vc_column_text css=”.vc_custom_1767585406524{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]DiLytics implemented Cost Transparency Analytics for an American Biotechnology Company to enable the Optimization of Cost at the Program Level.[/vc_column_text][vc_column_text css=”.vc_custom_1767585390437{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]The customer’s Finance Team (FP&A – Financial Planning and Analysis team) faced challenges with transactional reports containing disaggregated information, making it difficult to understand costs and variances from budgeted values for different programs. Further, the CCMs didn’t have visibility into transactional reports. The burden of cost analysis fell on the FP&A team, resulting in a lack of accountability for business activities.[/vc_column_text][vc_column_text css=”.vc_custom_1767585370300{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The customer aimed to automate cost transparency reporting in Oracle Analytics to provide the Finance Team with access to transaction and aggregated level information for different programs, enabling them to explain variances in budgeted and actual values.[/vc_column_text][vc_column_text css=”.vc_custom_1767584987846{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1767584585489{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics extended the current reporting 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_1767584870784{margin-bottom: 10px !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 & Lead (ETL) code using Informatica to extract data from the source database into EDW staging tables
- Developing ETL code using Informatica to load data from EDW staging tables into Facts and dimensions
- Modeling the extended EDW tables in Oracle Analytics to create metrics and attributes
[/rt_list_style][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1767585455952{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Time Reporting
- CCM Program Reporting – Summary View
- CCM Program Reporting – Transaction View
[/rt_list_style][vc_column_text css=”.vc_custom_1767585156575{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1767585042051{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics solution provided business benefits to the client such as[/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_1767585820564{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Improved accountability for various business activities
- Improved identification of cost-reduction areas
- Improved regulatory compliance
[/rt_list_style][vc_column_text css=”.vc_custom_1767585192368{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1767585288286{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]Source Systems: Oracle EBS, Hyperion, Kronos
Data Integration Tool: Informatica
Data Warehouse: Oracle Business Analytics Warehouse
Reporting Tool: Oracle Analytics [/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1767585558494{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_1767585545281{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]