Financial Services

Data Management

International Money Mover Improves Customer Data


Money transfers can be crucial in preventing personal financial emergency. A Latin American money transfer leader has been helping its customers quickly get cash to family and friends in need for more than 20 years.

International Money Mover Improves Customer Data.png

With hundreds of its own retail stores and more than a 1,000 retail agent partners, the company’s services span not just countries, but continents. Keeping in contact with its countless customers was a priority, but outdated, inaccurate information made it a challenge. This money transmission leader wanted a reliable customer directory and they paired with BlueGranite to get it.

Names, emails, phone numbers and addresses can change, whether due to a move, a marriage, a new job, or other circumstances. BlueGranite’s main goal in this partnership was to create a clean customer contact list. We started by pulling customer information from three point-of-sale systems, then standardizing, correcting and verifying the data. We then took the added step of merging duplicate customers using fuzzy matching techniques.

Once records were matched, we created a golden record – a single, correct master record for the duplicates, and used survivorship rules to ensure retention of the best representative customer data. We loaded the final product into Microsoft SQL Server Master Data Services for long-term storage, review, and integration into the company’s data and analytics solutions. Our use of Microsoft’s SQL Server Analysis Services provides a rich semantic layer, and a robust set of customer churn analysis calculations so the company can see which relationships have ended and when.

We also installed the Microsoft Gateway to deploy multiple on-premises Power BI connections and ensure secure data access. Additionally, we are working with the company to teach its users the ins and outs of self-service BI using Power BI, including best practices. Users are now using the combination of Analysis Services and Power BI to create rich analytics to track customer activity, customer retention, and look for ways to implement new customer programs.

There are so many ways, and reasons, to channel the power of your data. Let BlueGranite, a data and analytics leader, help you explore many ways data can work for you. Contact us today.



Powe[R] BI: Enhance Your
Microsoft Power BI Experience
with R

As a specialized, open source statistical environment, R
represents the primary analysis language for many data
scientists and statisticians. By extending Power BI with R,
Microsoft has created several opportunities to enhance your
Business Intelligence solutions and visualizations.