Fixing Data Accuracy Issues Enabled Improved Sales and Inventory Insights

 

The client is an American manufacturer and distributor of candy and chocolates. It offers chocolate assortments, nuts and chews, decadent chocolate truffles, milk and dark chocolates, brittles and toffees, truffles, lollipops, candy bars, and gift cards, and kosher categories. It sells its products online, as well as through its shops in the United States, Hong Kong, Japan, and Macau. The company was founded in 1921 and is headquartered in Carson, California. 

 

Background

The client implemented Oracle Analytics Cloud to analyze sales and inventory data. However, it soon experienced data accuracy issues in several reports. Hence, the client wanted to review its current implementation and apply industry standards to data visualization, data warehouse design, and ETL architecture. 

In addition, the client wanted to expand Oracle Analytics Cloud’s footprint.

 

Solution

DiLytics carried out the assignment which included:  

  • Reviewing current design and performing necessary changes to implement industry standards (based on Ralph Kimball’s relational star schemas)
  • Fixing data accuracy issues in current Oracle Analytics Cloud Implementation by making changes to data warehouse design, star schemas, facts and dimension tables, SQL packages, Oracle Analytics Cloud model and reports/dashboard
  • Extending data warehouse including:
    – Gathering requirements on new data and functionality
    – Identifying the source tables and fields for data extraction
    – Design and develop extensions to the current data warehouse model to store the new data
    – Data integration to load new data into the data warehouse
    – Developing Reports and Dashboards on new data
    – Performing Conference Room Pilot (CRP) sessions
    – Executing system testing
    – Implementing best practices for backups, DB space and data purge, Usage Tracking and Report Publishing
    – Conducting UAT and Training
    – Migrating to Production and Go Live

DiLytics also provided support and maintenance services for the enhanced Oracle Analytics Cloud implementation for a period of two (2) years. 

 

Business Benefits

  • Improved insights on sales and inventory via analytical reports with high-fidelity data
  • Efficient inventory utilization with decreased stock-outs and overages
  • Increase sales through a dynamic product mix

Technical Stack

  • Data Sources: XCenter (SQL Server database)
  • Data Integration Tool: Oracle Stored Procedures
  • Data Warehouse: Oracle Database Cloud Service (DBCS)
  • Reporting Tool: Oracle Analytics Cloud

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.