Article citationsMore >>

Zaki, M., & Meira, W. Data Mining and Analysis. Cambridge: Cambridge University Press, 2014.

has been cited by the following article:

Article

Building an Effective Data Warehousing for Financial Sector

1Higher Polytechnic Institute of Gaya, V.N.Gaia, Portugal

2Faculty of Engineering of Oporto University, INESC TEC, Porto, Portugal


Automatic Control and Information Sciences. 2017, Vol. 3 No. 1, 16-25
DOI: 10.12691/acis-3-1-4
Copyright © 2017 Science and Education Publishing

Cite this paper:
José Ferreira, Fernando Almeida, José Monteiro. Building an Effective Data Warehousing for Financial Sector. Automatic Control and Information Sciences. 2017; 3(1):16-25. doi: 10.12691/acis-3-1-4.

Correspondence to: José  Monteiro, Higher Polytechnic Institute of Gaya, V.N.Gaia, Portugal. Email: almd@fe.up.pt

Abstract

This article presents the implementation process of a Data Warehouse and a multidimensional analysis of business data for a holding company in the financial sector. The goal is to create a business intelligence system that, in a simple, quick but also versatile way, allows the access to updated, aggregated, real and/or projected information, regarding bank account balances. The established system extracts and processes the operational database information which supports cash management information by using Integration Services and Analysis Services tools from Microsoft SQL Server. The end-user interface is a pivot table, properly arranged to explore the information available by the produced cube. The results have shown that the adoption of online analytical processing cubes offers better performance and provides a more automated and robust process to analyze current and provisional aggregated financial data balances compared to the current process based on static reports built from transactional databases.

Keywords