OFI processes 20GB of data each day for financial assets, non-financial data related to making ethical investments and regulatory reporting. In most use cases it involves extracting data from over 20 legacy data warehouses from which this data has to be unified. All of them have to be sent to the data warehouses at least one time per day. The whole dataset include around 3000 data columns, each requiring specific data preparationbefore being sent to the data warehouses. In order to serve their clientele OFI needed the right tool to serve their current data needs and the ability to grow and scale to support new types of data in years to come.
How Trifacta Solved this Problem
Trifacta enables OFI to collect, refine, and reorganize raw data files. Using Google BigQuery pushdown optimization to access refined data, OFI is able to support a variety of business cases including marketing forecasting, sales forecasting, interest prediction, and capital structure planning. According to OFI, one of Trifacta’s best features is its ability to create unique tests while preparing data, as most bugs that come up during data transformation come from insufficient testing.
Users are able to run multiple tasks at the same time on Trifacta. On average, 3 employees were able to simultaneously work on the database project and serve OFI internal customers, a task which typically requires 9 people when completed separately at the industry standard.
A clear data design plan and systematic integration of data fields has enabled a data warehouse in which OFI can deliver reporting to businesses early. By building the data warehouse progressively they can build over time with a smaller budget and consensus over time.
Unlike legacy tools, which require specific expertise, users were able to get started with Trifacta right away. This ease of use, coupled with the quick delivery of business results, made it easy for executives to select Trifacta.
OFI was founded in 1971 and has been committed to Socially Responsible Investment (SRI) for over 25 years; it is a reference in asset management and among France’s leading SRI asset managers. The Group has developed expertise in both collective management and discretionary management, on listed and unlisted assets, in order to offer solutions and services adapted to the needs of a diversified clientele of institutional and private wealth clients in France and internationally.
“We chose to work with Trifacta because we saw it was a good setup to do our job today and for years to come. We are in a changing world especially in finance where there are new data sets coming and that can be structured or unstructured datasets so we need to have the capabilities to work with all data.”
Matthieu DumergueChief Data Officer at OFI Asset Management