LUX Transcend is Your All-In-One Platform

By Cody Robertson, Head of Product (Transcend)

When you have dozens of data sources, how do you link them all together to make more informed decisions? That’s the question facing fund managers, CFOs, and other business professionals.

Today, data management is not really centered on the collection or even the analyzing of data, but is focused more on aggregation, transformation, and presentation of that data in a format that allows the end user to gain actionable insights.

For example, it’s one thing to pull data from an accounting system to see the profit and loss of your positions, but it’s another thing to merge that information with market data, perform a time-weighted return calculation to see year to date performance contributions and exposure across asset class, region, and industry. This merging and aggregation of datasets provides insights that are otherwise only available by performing a lot of manual and error prone work in Excel – and one error is too many.

Most firms have myriad data sources; everything from files and proprietary API calls, to manual inputs and overrides. The maintenance and management of all those connections is a huge expense for investment managers and puts burden on technical staff that are often already stretched. So, what is the best solution?

Simplified Data Integration and Aggregation

There are a number of business intelligence products available today to help business users build data dashboards. But most focus on allowing users to simply visualize the data, versus providing connectivity to different data sources and being able to combine that data and produce custom calculations and aggregations on top of it.

The best data solutions have built-in connectors that can be easily configured to automatically pull data from virtually any source without the need for a software engineer. That’s the solution delivered by LUX Transcend.

Having a direct connection into the data source eliminates the need to manually cobble together Excel spreadsheets from emails, FTP sites, and file shares.

Recently we helped a client save their CFO several hours a week producing manual cash summary reports. Previously, she had to download over 30 files from four different counterparty portals, plus extract several attachments from her email. Then she should would copy and paste those files into Excel, setup several V-Lookups, add conditional logic to map the data correctly, and finally create pivot tables to produce her report. Does this sound familiar? If you’re in this situation it’s time to rethink your strategy.

After implementing LUX Transcend, her files and email attachments are automatically loaded into each morning and a calculation process runs to normalize and aggregate the data. By 6 a.m. each morning, her cash summary dashboard is ready for review. The CFO is ecstatic to have her time back and values the ability to be more proactive in identifying counterparty errors.

Are you ready to move forward and take the next step in data integration and aggregation? It’s time to save time, increase efficiency, and get more valuable insights from your data.