Manufacturing Co Centralized Data Ecosystem

← Back

PE-backed manufacturing company needed a holistic view of their business including manufacturing floor metrics, finance metrics, sales metrics and product metrics.  Executives and investors needed a better handle on metrics across the organization with quickly changing environment during COVID.

Challenge Solution Impact

Challenge

In the ever changing environment of manufacturing, this PE backed company needed to make quick decisions to handle such challenges as Covid, Supply Chain constraints from tariffs, and raw material cost fluctuations.

Similar to many other companies, they had data spread across numerous systems, both internal and external, with little infrastructure to pull it all together, that left them flying without a view of their metrics.

Solution

The NuView team developed a holistic infrastructure to pull data from systems including Shoplogix, Sage ERP, Salesforce, Inventory Management Systems, and offline files to aggregate data across the business.

Utilizing Alteryx these sources now settled in a single source of truth and were brought to the forefront of the business through Tableau dashboards developed for the Sales team, Warehouse operators, and Executives.

Impact

With a holistic view of the operations of the business, the executive team was able to quickly pivot their supply chain to address the rocky climate of trade wars between the US and China, allowing the team to weather what could have been a detrimental situation.

The creation of a single source of truth and a centralized data ecosystem allowed the company to upgrade their ERP system seamlessly into their reporting environment, without skipping a beat.

Data Sources

Tools

Related Case Studies