Raising the bar for data analytics across multi-brand manufacturing organization

Background

• Customer is a collection of the leading brands in commercial outdoor play and recreational products. The transactional systems for these brands span multiple databases and source ERP systems.

• There is a need to build a platform that will serve as the “Single Version of the Truth” for Analysis and Reporting across these multiple sources of data.

• The goal is to drastically reduce the time and effort to access Order, Sales and Revenue information while enabling a high level of self-service and actionable insights.

Challenge

• As the customer has grown through acquisitions, there is no single system in place to perform consolidated reporting of sales, revenue and finance information
• Weekly, Monthly and Quarterly reporting is primarily driven by Excel spreadsheets that are generated by individual brands and consolidated at corporate headquarters.
• Users are spending unacceptable amounts of time on a daily basis to generate reports, reconcile the data to individual systems and sometimes across multiple systems.

Solutions

• Kenfront has analyzed over 90 different Excel spreadsheets being used by different users to publish reports.

• Kenfront proposed to build a data ingestion and processing system that provides a unified view of Order and Sales data across all the brands in North America.

• Using modern analytics system like Incorta, the customer is able to address their need for traditional and advanced analytics.

• Power BI is used for self-service data visualization to enable ad-hoc and enterprise level reports and dashboards.

Result

• After the initial successful POC the customer agreed to move forward with a phased implementation with Incorta.

• Live with Incorta for past 3 years, currently moving to Incorta Cloud.