Case Study | Municipal Services | Master Data Management

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.

bismart-business-intelligence-servicios-municipales-data-warehouse-power-bi

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

07-bismart-business-intelligence-servicios-municipales-data-management-data-quality-1-150x150

More than 7 different business areas

 

07-bismart-business-intelligence-servicios-municipales-data-management-data-quality-2-150x150

Single data

07-bismart-business-intelligence-servicios-municipales-data-management-data-quality-3-150x150

More than 50,000 duplicates cleared

Other Case Studies

 

Discover what we can do for your business