Data Centralization and Access.
A global manufacturer of outdoor power equipment was struggling to increase their number of new product warranty registrations.
2nd Watch used customized data management tools and integrations to improve data centralization and access, which helped to uncover the data they needed to solve the problem.
Our client’s centralized data warehouse with ongoing replication shows new data daily, allowing account managers to chart their progress and better measure the success of their efforts. They plan to expand the data warehouse by integrating predictive analytics capabilities such as production forecasting and demand planning.
A global manufacturer of outdoor power equipment was struggling to increase their number of new product warranty registrations. Years of successive acquisition and neglect had left the company’s data assets in severe disarray, making it nearly impossible to find the insights they needed to address the challenge.
Our client reached out to 2nd Watch to improve data centralization and access to help them solve a couple important business challenges:
- Product warranty registrations for their equipment at the point of sale had been chronically lower than desired.
- Company leadership also wanted to create a system for incentivizing account managers who increased sign-ups, but they lacked the systems for managing this program at scale.
A major challenge in establishing this system was the company’s data. Our client had grown through acquisition over the course of many years; and during this time, little attention was paid to the collection and management of company data. As a result, data related to dealers, account managers, and warranty registrations was decentralized throughout their infrastructure.
With their existing systems, collecting data for the program would require hours of manual queries, data cleansing, aggregation, and analysis. Moreover, this long, labor-intensive process would only create a single monthly report, which failed to provide the engagement and excitement the client desired.
2nd Watch used data management platform Qlik Replicate to gather data from the company’s disparate systems and place them in a centralized, cloud- based Snowflake repository. This data repository featured ongoing data replication in near-real-time, providing a foundation for faster, more accurate reporting.
Next, using both Azure Data Factory and Azure Functions, the 2nd Watch team transformed the raw data into a modeled data warehouse. The warehouse served as the basis for a front-end dashboard that we built using reporting and visualization system Tableau.
The result was a system that showed the year-over-year improvement in total product registrations, as well as the percentage of registrations compared to units sold for each account manager.
The centralized data warehouse with ongoing replication shows the team new data daily. This allows account managers to chart their progress and better measure the success of their efforts. It has also helped the client’s staff and dealerships to cooperate on adjusting the warranty registration program and further optimizing results.
Our client plans to partner with 2nd Watch to expand the data warehouse by integrating new predictive analytics capabilities such as production forecasting and demand planning.