Manufacturing & Industrial

Modern Data Platform

Master Data Management the First Step Toward World-Class Customer Data Access

By embracing the adage ‘there’s no place like home’, a North American residential and commercial construction products maker built a thriving national enterprise. The company’s roofing, siding, windows and other goods customize homes and commercial property across the U.S. and Canada.

Master Data Management the First Step Toward World-Class Customer Data Access.jpg

This booming business wants to better understand, market to and connect with its vast customer base. Contractors, designers and builders either buy the company’s goods through one of its many supply centers, or from a partner independent supplier. Knowing if a client is a national homebuilding account affiliate or an individual contractor is a major challenge.

Company leaders knew that learning more about their clients could offer many benefits, from creating effective, targeted marketing, to rewarding repeat clients. They approached BlueGranite with a vision to create world-class customer data to affect superior customer service.

To that end, we’re working to join information from more 40 distinct source systems scattered across the company’s satellite locations. We’ll pull it all together and implement a master data management system – a way for this organization to connect its vital customer data to a single, reliable source of truth. Collecting analytic and reference data in a single repository ensures consistency and eliminates duplication.

The system gives business users the ability to quickly organize, segment, market to and communicate better with customers. Creating new customer attributes was once a major IT undertaking, with lead times of up to a year. Our scalable solution will allow users to create these attributes themselves in moments.

These first small steps into modern self-service analytics will empower the manufacturer’s business users to better understand its customer base. BlueGranite’s solution lays the foundation for users to take bigger data exploration strides in the future.

Whether you are also taking your first steps on the data discovery path, or your analytics journey is well underway, let our experts ensure that you get the most out of your data. Contact us today.


  • Using Microsoft’s SQL Server Integration Services, we pulled customer data from myriad sources and integrated it into a unified view.
  • We utilized Microsoft's SQL Server 2016 to allow us to make use of its robust and scalable engine to make data management easy, secure, and reliable.
  • Microsoft Master Data Services (MDS) – the SQL Server master data management solution – let us compile and centralize data to create a single, reliable customer list.