Contact Us

Fixing of Data Accuracy Issues

[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_1766039946962{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1766039933504{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1766039918625{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Fixing Data Accuracy Issues Enabled Improved Sales and Inventory Insights

[/vc_column_text][vc_column_text css=”.vc_custom_1766039655547{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]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. [/vc_column_text][vc_column_text css=”.vc_custom_1766039700038{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Background

[/vc_column_text][vc_column_text css=”.vc_custom_1766039766970{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]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. [/vc_column_text][vc_column_text css=”.vc_custom_1766040221129{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

DiLytics’ Solution

[/vc_column_text][vc_column_text css=”.vc_custom_1766039841731{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics carried out the assignment which included: [/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1766039471310{margin-bottom: 10px !important;padding-left: 35px !important;}”]

[/rt_list_style][vc_column_text css=”.vc_custom_1766039562734{margin-bottom: 20px !important;padding-left: 55px !important;}” el_class=”text-block”]- 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[/vc_column_text][vc_column_text css=”.vc_custom_1766039383273{margin-bottom: 35px !important;}” el_class=”text-block”]DiLytics also provided support and maintenance services for the enhanced Oracle Analytics Cloud implementation for a period of two (2) years. [/vc_column_text][vc_column_text css=”” el_class=”text-block”]

Business Benefits

[/vc_column_text][vc_column_text css=”.vc_custom_1766039296248{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_css=”.vc_custom_1766039337847{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

[/rt_list_style][vc_column_text css=”” el_class=”text-block”]

Technical Stack

[/vc_column_text][vc_column_text css=”.vc_custom_1766040247174{margin-bottom: 0px !important;}” el_class=”text-block”]Data Source(s): XCenter (SQL Server database)

Data Integration Tool: Oracle Stored Procedures

Data Warehouse: Oracle Database Cloud Service (DBCS)

Reporting Tool: Oracle Analytics Cloud[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1766039131426{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=”” 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]