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.
翻译:本篇文章介绍金融部门控股公司数据仓库的实施过程和对商业数据进行多层面分析的情况,目的是建立一个商业情报系统,以简单、快速和多功能的方式,使人们能够查阅银行账户余额方面的最新、汇总、真实和(或)预测的信息,已建立的系统利用来自微软 SQL服务器的整合服务和分析服务工具,提取和处理支持现金管理信息的业务数据库信息,最终用户界面是一个支流表,为探索所制作的立方体所提供的信息作了适当的安排。结果显示,采用在线分析处理立方体可提供更好的业绩,并提供更自动化和强有力的程序,以分析当前和临时汇总财务数据余额,而目前流程则以交易数据库建立的静态报告为基础。