Objectivity > Case Studies > Assessing an Innovative Data Warehouse Technology for EFL

Assessing an Innovative Data Warehouse Technology for EFL

Objectivity Logo
 Assessing an Innovative Data Warehouse Technology for EFL - IoT ONE Case Study
Technology Category
  • Application Infrastructure & Middleware - Database Management & Storage
Applicable Industries
  • Finance & Insurance
Applicable Functions
  • Business Operation
  • Cloud Planning, Design & Implementation Services
  • System Integration
The Challenge

Knowing the importance of flawless data architecture in the finance industry, EFL was considering multiple options to upgrade its data warehouse. This system lies at the center of their operations and plays a crucial role in allowing them to provide the highest quality services to their numerous customers. One of the possibilities they were investigating was a full migration to an innovative data warehouse solution — Snowflake.  

It was crucial for them to get an independent expert opinion and not rely purely on the data and materials provided by the vendor. Objectivity was selected as a result of successful collaboration between the two organizations on multiple occasions in the past.  

The Customer
About The Customer

EFL S.A. (Credit Agricole group) began its operations in June 1991 as one of the first leasing companies in Poland. Today, the company provides a comprehensive set of financial solutions, including leases, loans, long-term hires, factoring, and more. They serve more than 320,000 customers and have financed 65 billion PLN worth of investments.

The Solution

Objectivity built a proof of concept of the Snowflake data warehouse solution and conducted an extensive testing process using a portion of EFL’s actual data. This was to emulate the real-life scenarios as accurately as possible and get the most relevant results. The client received a direct comparison of Snowflake and their current data warehouse solution. Moreover, the team tested multiple data loading methods to gain the most exhaustive insight into the platform’s capabilities. 

A Snowflake-based data warehouse can utilize multiple servers for a single client. This allowed Objectivity to set up a separate server for every EFL’s department that requires access to the data warehouse. The company can more accurately track the needs and expenses of every department and manage permissions easily. 

In addition to testing the solution’s performance, this proof of concept enabled EFL to estimate the total costs of moving and maintaining their data warehouse in Snowflake. Objectivity remained impartial in the process and provided the client with detailed results of the audit.

Operational Impact
  • [Data Management - Data Analysis]
    • Successful verification of data warehouse technology against EFL’s requirements
    • Rapidly delivered complex performance report which supports informed decision-making
  • [Cost Reduction - Data Management]

    Simplified cost management thanks to an accurate estimation of exploitation costs

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.

Thank you for your message!
We will contact you soon.