Business Analysis and Implementation of a New Data Warehouse

Technical analysis and design of DW models

The project began with an analysis of existing data structures, business processes and the company’s reporting needs. The job was to transform complex business requirements into a clear and coherent technical solution.

The documentation which came out of the analysis contained a business model, the design of the required reports, the design of the data warehouse in the form of a multidimensional data model and basic guidelines for the implementation of the complete analytical solution. The aim of the design of the data warehouse was to ensure that fundamentally the Business Intelligence system is able to standardize data from various sources and to collect it almost in real time. Users should get fast, flexible and easy access to consolidated information.

Implementation and deployment of DW and ETL systems

The second phase of the project was to build the Data Warehouse, designed in the previous analysis stage, and to load it with data from one source platform. Bearing in mind that in future the Data Warehouse will collect information from many different transaction platforms, the necessary mapping tables and ETL processes were designed and implemented. This facilitated an easy increase of the number of source systems of the Data Warehouse in the successive stages of the project.

About the client

Squared Financial is a full-service broker regulated by the Central Bank of Ireland which offers an ECN-style trading model across a broad mix of Bank and non-Bank liquidity pools. Squared Financial specializes in Foreign Exchange (including CFDs) and related products. Their clients benefit from the best price and highest quality of execution for their personal trading style and strategy.