Analytics and Collaboration Success Story

Customer Data Model for Leading Beverage Distributor

Business Situation

• The client is one of the country’s largest marketers, producers, and distributors of carbonated beverages
• The client uses its extensive sales and delivery force to market and distribute products to retail customers and consumers
• The client initiated a Customer Management project to improve the accuracy of its customer data, and ensure their processes and technologies were poised to facilitate future customer management strategies

Key Issues

• There was a growing need to be able to apply the customer profile information across a disparate range of back-office applications, front-office applications and web customer automation applications
• Customer service capability is severely reduced by this lack of shared information, creating significant and redundant short and long-term IT integration costs
• The creation of a detailed data model and associated use cases was an important first step in improving the quality of their customer data

Outcomes

• The Revere Group worked with key members of the Customer Management project team to create an effective Customer Data Model that met the objectives of the project
• Documented Requirements that drove the design of the data model and use cases
• Developed function point driven cost estimates for building a customer data repository
• As a result of the project, the client had an effective data model, and was poised to facilitate the implementation of a new customer management system