Building an Effective Data Warehousing for Financial Sector

by   Jose Ferreira, et al.

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.



There are no comments yet.


page 1

page 2

page 3

page 4


Determinants of Mobile Money Adoption in Pakistan

In this work, we analyze the problem of adoption of mobile money in Paki...

Form 10-Q Itemization

Form 10-Q, the quarterly financial statement, is one of the most crucial...

Towards Intelligent Robotic Process Automation for BPMers

Robotic Process Automation (RPA) is a fast-emerging automation technolog...

High-Level ETL for Semantic Data Warehouses—Full Version

The popularity of the Semantic Web (SW) encourages organizations to orga...

Collaborative Company Profiling: Insights from an Employee's Perspective

Company profiling is an analytical process to build an indepth understan...

Modelling and Enactment of Data-aware Processes

During the last two decades, increasing attention has been given to the ...
This week in AI

Get the week's most popular data science and artificial intelligence research sent straight to your inbox every Saturday.