Case Study | Municipal Services
Master Data Management
City Council company that manages the public parking network, blue zone and tow truck, bus stops, civic agents and facilities such as zoos and parks.
GOAL
- Organise and unify customer and transaction data from the different entities involved, to incorporate them into a corporate CRM tool.
- Address all the contacts obtained by the business areas in a coordinated manner.
STRATEGY
- Acquisition of customer data from the different data sources
- Initial data de-duplication through ID and relevant fields
- Data Quality process that applies data mining algorithms and displays possible duplicates and applies a % hit rate to them
- Final user review to validate the elimination or not of proposed duplicates
- Additional database of transactions (tickets, reservations, consumptions,...) that links with the MDM
- Clients to get their real history.
RESULTS
- Data cleansing from different sources
- Informed CRM with unified real data that avoids errors in the relationship with customers/contacts
- Real knowledge of a customer's activity and possibility to exploit synergies between different areas of activity
More than 7 different business areas
Single data
More than 50,000 duplicates cleared
Other Case Studies
Discover what we can do for your business