Data Aggregation: The Answer to Big Data?

    150 150 INDATA

    Interesting perspective in Wall Street & Technology last week from a performance measurement solution vendor. The premise is that data aggregation is the answer to keeping up with the ever increasing demands of big data. At first glance, this seems like a sound concept but upon further examination, it would not hold up for the needs of an average asset management firm.

    First, while all buy-side firms have to reconcile their books and records to their custodians, custodian downloads only contain the basics that are used for client portfolio reporting, namely positions & transactions. This is good for a performance measurement only system, since aggregating transaction downloads saves a lot of work, rather than trying to go to each custodian directly or trying to gather transaction data from in-house systems for use in dashboards and client reports.

    The problem arises in the data that is required to manage the investment process itself, namely portfolio analytics – It’s not typically provided by custodians. If it is, it’s only provided at a basic level and isn’t useful for pre-trade investment decisions since it’s not provided until the following day, at the earliest.

    And this is where the data aggregation argument falls apart. Big data and the data management process itself has a much bigger role in the aggregation of data from sources other than the custodians, namely analytics and pricing services from various vendors. The challenge becomes getting access to this data. Custodial data aggregators can’t get it because the data is internal to the individual investment firm. From there, the challenge increases when trying to validate this data to make sure that it’s accurate before it’s used to make investment decisions or before it ends up on a client report. This is where data management technology comes into play and this technology has to come from other sources either internal or external, since the data aggregators only get data from custodians.

    So in summary, data aggregation can help with big data in certain specialized areas but it’s not the be-all, end-all answer for the big data challenge. The answer is data management technology itself, whether it’s built in-house at a huge expense to the firm or provided by third party vendors.