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?
4. Approach
4.4. Architecture
The system consists in a data warehousing solution, built using Microsoft technology, specifically Microsoft SQL Server 2008 and its Integration Services (SSIS) and Analysis Services (SSAS) component. The information provided by the SSAS project, consists in an OLAP cube which can by access by the final user using a Microsoft Excel 2010 spreadsheet, properly connected to the SSAS. A visual representation of the architecture is depicted in Figure 1.
Figure 1. System architecture
