London
15 March 2017
Reporter: Stephanie Palmer

Quest for ‘warehouses of truth’


Increased data quality is the main benefit of data warehousing for asset managers, according to a discussion at TSAM London.

In a data management forum session, audience members were asked: “What is the biggest advantage you gain from a data warehouse?”

A significant majority, 43 percent, answered that the main benefit is increased quality and a single version of the data

Increased utilisation of data within the firm was named as the biggest benefit by 29 percent, while 18 percent noted that a warehouse can provide flexibility to meet new data challenges and 11 percent selected lineage and data governance.

A speaker in the session said that with regards to data warehouses, often a lot of words are used to describe something that is “not that complicated”. He agreed with the audience poll, saying that the main goal is “one truth and one understanding of the data”.

If two areas of an organisation are working with the same piece of data, they don’t have to waste time making sure their versions match up. And, if they don’t match up, they don’t have to spend more time reconciling them.

If there is a single source of data that both businesses can access, they can immediately start discussing what they are going to do with it.

The speaker also noted challenges in the adoption of ‘data lakes’, which are stores of raw data that are set aside until they are needed.

The main challenge is getting senior management on board, persuading them to spend money on data—something they perceive that they already have.

Another speaker also noted another set of challenges that arise from trying to store everything in one place. Asset managers should have a clear definition between the middle- and back-office data and the front-office analytical data, which he called “less mission-critical”.

He added that data warehouses should be built to support the business in the future, with capabilities to encompass new products or programmes, and this requires some internal overheads.

While the data in the warehouse should be a ‘golden source’, the speaker noted that, in the case of a discrepancy, data must be fixed at its source, and not in the warehouse, otherwise the business will end up with inherent quality issues.

He concluded that a data warehouse can provide operational efficiency and flexibility, offering the ability for asset managers to “report off of something that you would inherently want to”.

More news
The latest news from Asset Servicing Times
Join Our Newsletter

Sign up today and never
miss the latest news or an issue again

Subscribe now
Harnessing data can keep securities secure
18 October 2017 | Toronto | Reporter: Stephanie Palmer
Securities transactions are just as susceptible to cybercrime as payments, and proper use, and protection, of data is key to managing that risk, Sibos attendees have heard
Banks cautiously optimistic about impact of tech
18 October 2017 | Toronto | Reporter: Theo Andrew
According to the BNY Mellon research, Rethinking the Client Payment Experience, security and reliability are viewed as instrumental in creating the ideal payment experience
BNY Mellon and HSBC sign up to Algomi’s Honeycomb
18 October 2018 | New York | Reporter: Jenna Lomax
The collaboration is expected to bolster fixed income market liquidity by giving both BNY Mellon and HSBC clients the ability to make select holdings information available anonymously through the new solution
Broadridge completes blockchain bilateral repo pilot
18 October 2016 | New York | Reporter: Theo Andrew
The pilot, conducted in partnership with Natixis and Societe Generale, utilises distributed ledger technology in order to make complex processes “more secure, transparent and efficient”
Industry torn on which city will replace London as post-Brexit financial hub
17 October 2017 | Toronto | Reporter: Stephanie Palmer
Frankfurt is set to displace London as a global financial centre after Brexit, according to an audience poll at Sibos 2017, however the session’s panellists were not convinced by the results
Quick response times key to managing reputational risk
17 October 2017 | Toronto | Reporter: Stephanie Palmer-Derrien
Reputational risk should be taken as seriously as any other type of risk, and measured, organisation-wide, and well-planned responses are key to minimising it, heard panel attendees at Sibos 2017
NEX partners with Baton Systems
17 October 2017 | London | Reporter: Jenna Lomax
The agreement means Baton Systems will be the first third party to provide its clients with services through NEX’s Infinity solution
More news