An analysis of existing data structures, business processes and the company reporting requirements. The aim of the project was to design and build the data warehouse, which stands for the basis of Business Intelligence system. The necessary mapping tables and ETL processes were designed and implemented, which will allow an easy increase of the number of the source systems of the data warehouse in the next stages of the project.
Technology used in project: IBM DB2, Pentaho Data Integration.
Squared Financial Services Limited – independent, full-service broker company regulated by the Central Bank of Ireland (CBI).