A master data management strategy is in the works for Scotiabank with respect to their data warehouse and business intelligence environment, according to a Scotiabank executive.
Neil Freake, Scotiabank’s senior manager of business intelligence (BI) planning and development, says he is working on a number of system development projects that will help the financial services firm get a better handle on the reference information that underpin a lot of its customer relationships.
This approach, which is called master data management, will potentially help improve the quality of information that resides in data warehouses or data marts.
Freake, who spoke at a breakfast seminar organized by SAS Canada, says Scotiabank first set up a data warehouse in 1998 that was mostly used to manage marketing-related information. Since he joined the company in 2000, he says the company has become more focused on using it for customer relationship management (CRM) data and helping other parts of the business make decisions.
The company has some in-house tools, including one called SalesBuilder developed by IBM, and packaged products from InSite and Xeye that deal with data in areas like its wealth management operation.
“The end result is that you have information across these systems with customer data, but the context is different,” Freake said. “When you see the address, you have to ask: is that the person’s personal address? Is it the address of a guarantor? Is it the person with power of attorney?”
This is the classic kind of problem master data management is supposed to solve, says Jill Dyche, co-founder and partner with Baseline Consulting. She explains master data management with the example of someone using an ATM machine. IT systems tend to track the transactional information about what happens when someone makes a withdrawal or transfers money between accounts, she says. Master data management is focused on the reference data – who the person using the ATM is, their history with the bank, and so on.
“It’s very subject area-specific,” says Dyche, who recently co-authored a book on master data management called Customer Data Integration. “You have customer data, that tends to change a lot. Then you have product data, which tends to be much more complex…what you can do with a data warehouse is really only as good as your data supply chain.”
Scotiabank does a lot of the data matching and cleanup associated with master data management in the warehouse itself, Freake says. Scotiabank tends to only pull about 30 per cent of the information that sits in the data warehouse, because the key is making sure it meets the needs of the business.
“We’re not going to add fields into our warehouse because it exists, but because it’s what our users want,” he says, adding that the cleanup involved is not for the feint of heart. “We’ll see a lot of nulls in non-nullable fields.”
Freake did not give a specific timeline for when Scotiabank would set up its master data management practice, but indicated it would be a long-term initiative. Already there are three teams set up around the world working on the project, and Freake says they would start having to work more cohesively.
Related content:
Integrating IT for collaboration
