[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_1764053350455{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;}”][vc_column css=”.vc_custom_1661511619445{margin-top: 20px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1764241279758{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Setup of Business Intelligence Center of Excellence Improved User Adoption and Experience
[/vc_column_text][vc_column_text css=”.vc_custom_1764241292721{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client is a multinational video game and digital entertainment company. Its main American headquarters is based in San Mateo, California, while its main Japanese headquarters is based in Tokyo. The client handles the research & development, production, and sales of both hardware and software for the PlayStation line of handheld and home console video game systems. It is also a developer and publisher of video game titles.[/vc_column_text][vc_column_text css=”.vc_custom_1764241320454{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1764241333318{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client had implemented Oracle Business Intelligence (BI) Applications (Financial Analytics, Procurement & Spend Analytics, Supply Chain and Order Management Analytics) to replace the long-time incumbent Business Objects. It was facing challenges in driving the transition of business users from Business Objects to Oracle BI Applications. Due to this, it was not able to derive the maximum adoption & ROI from Oracle BI Applications.[/vc_column_text][vc_column_text css=”.vc_custom_1764241350909{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1764241367120{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics’ partnered with the client to implement a solution based on Oracle Analytics. The solution was implemented across the following phases:[/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_1764241934015{margin-top: 0px !important;margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Trained sales team to develop top priority reports – Returns, Daily Open Order, SKU Cost Inventory, Shipments and Orders by Client and Platform, Sample Client Summary, Open Order Value, Order Amount by Order Age Category (0-10 days, 11-20 days, etc.), Tie Ratio KPI reports, top 5 clients and others by adj gross qty – on a self-service basis
- Trained operations team to develop their top priority reports – Invoice Check, Shipped QTY by Client (refurbs), Inventory Balance (refurbs) – on a self-service basis.
- Provided data definition documentation for the required attributes and metrics in sales reporting subject area
- Installed Sameeksha tool and configured with Informatica
- Created User Productivity Kit (UPK) training materials for users to understand OBIA subject areas and how to develop prompts, reports & dashboards
- Reviewed and identified issues in ETL mappings in Enterprise data warehouse Finance. Provided recommendations on fixing the issues
- Integrated Master Data Management with Oracle BI Applications
[/rt_list_style][vc_column_text css=”.vc_custom_1764241530487{margin-bottom: 35px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1764241546742{margin-bottom: 10px !important;}” el_class=”text-block”]The client achieved several improvements across user adoption and experience, including:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764241559902{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Improved adoption of the new reporting tool by users
- Improved user experience with enhancements in the reporting tool such as reduction in account payable query time from >8 minutes to 32 seconds, and reduction in accounts receivable query time from >7 minutes to 2 minutes
[/rt_list_style][vc_column_text css=”.vc_custom_1764049548658{margin-bottom: 0px !important;}”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1764241597479{margin-bottom: 0px !important;}” el_class=”text-block”]Source System: Oracle E-Business Suite
Data Integration Tool: Informatica
Data Warehouse: Oracle Database
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_1764053378371{margin-top: 0px !important;margin-bottom: 0px !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_1764241650448{margin-bottom: 0px !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][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][vc_row][vc_column][vc_empty_space][/vc_column][/vc_row]