Building an Effective Data Warehouse
This case study provides insight into how a data warehouse was built for a firm in the financial sector using its existing Microsoft technology. It touches on the current form of "static reports" currently used within the company, which we have identified as problematic. This case study showcases a step-by-step method of how this DW is built. After reading, you should understand the theory and practical application of the DW approach. How would you apply a similar framework to a large department store chain's supply chain?
7. Conclusion
The performed work demonstrated that the use of a DW approach is an important tool to support decision-making and for the strategic management level, both the tactical and even operational level. The concept of building a DW presented in the literature review section was performed in practice using Microsoft SQL Server BI tools. The use of OLAP cubes facilitates the retrieval and analysis of large amounts of data. The Excel displays summarized data in PivotTable reports and OLAP server performs calculations to summarize the data. The end user interface is simple to use and allows the user to create analyzes with great flexibility (by month, year, bank, business type, real or estimated balance, etc.). Additionally, the analysis of the process becomes more automated and robust to the introduction of errors in the analysis of the process by the user. These are in fact the great advantages of this study to overcome the difficulties that existed before, wherein the access of information and analysis were very costly in terms of time and offered very limited flexibility.
In the future it is planned the development of this working. Currently we have identified two needs: the identification of accounts with infringement balances (based on pre-defined parameters); analysis of aggregate movements by budget code.