Set-Up of Business Intelligence Center of Excellence Improved User Adoption and Experience

 

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. 

 

Background

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. 

 

Solution

DiLytics established a BI Center of Excellence (CoE) in partnership with clients’ IT and business teams. As part of the CoE, some of the key undertakings that DiLytics accomplished included: 

  • 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.

 

Business Benefits

  • 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.

 

Technical Stack

  • Source System: Oracle E-Business Suite
  • Data Integration Tool: Informatica
  • Data Warehouse: Oracle Database
  • Reporting Tool: Oracle Analytics

To get a copy of this success story in a downloadable format with more in-depth analysis, kindly provide us a little information about yourself in the form below

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.

Custom Data Warehouse

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.