Emerson is an $18 billion, American multinational corporation headquartered in United States. This Fortune 500 company manufactures products and provides engineering services for a wide range of industrial, commercial, and consumer markets.
Insinkerator is a division of Emerson and is the world’s largest manufacturer of Waste Disposal Systems and is credited with inventing them over 75 years ago.
InSinkErator products are sold to both commercial and residential customers through 1000s of retailers across the world, including two of the largest home improvement retailers in North America and Canada.
These retailers send raw data via Electronic Data Exchange (EDI) to the InSinkErator enterprise data hub. From here the data is extracted and manually uploaded into the DOMO business Management Platform.
DIACTO was engaged to assist InSinkErator in taking this raw data and turning it into meaningful KPI dashboards. Part of the challenge being the lack of standard fields and the need to sanitize and standardize the data from multiple datasets. In addition, InSinkErator needed help in extracting, cleansing and merging years historical data from legacy systems such as AS400 into DOMO to enable business leads to have a single, holistic view of past and current business and customer performance.
Within a few weeks DIACTO was able to integrate the disparate data sets from EDI feeds, Oracle E-Business Suite and historic data from JDE and create KPI dashboards aligned with the business requirements in DOMO. In addition, DIACTO implemented automated the entire process to ensure the data and dashboards are refreshed as soon as the input data feed is updated.
“Working with the DIACTO Team with their expertise in data transformation and business analytics made a complex project much easier to execute. The ease of working with DIACTO from start to finish along with their commitment to going above and beyond to achieve customer success was refreshing, we will definitely work with DIACTO again on future projects”
Tom Orlowski , Director, Oracle Applications and Analysis