Building an Effective Data Warehouse

Based on compliance with the following steps:

1) Data Source Definition and Data Source View
It was created a view with the dimensions and fact tables from the resulting DW project SSIS. These tables are organized using the star schema already presented. The above mentioned auxiliary tables were not considered because they are not necessary.

2) Creation of Dimensions
From the Data Source View was created and characterized the dimensions that will be considered in the cube. One should mention the specific case of the time dimension whose type was defined as a time and not as regular as the others. This is particularly important because it enables the definition of measures based on time such as the average balance.

3) Creation of Cube
From the created dimensions and existing measures in the fact table (the various types of balances) was established an information cube that was complemented with an additional measure: average balance sheet in Euros. This measure belongs to average over time type.

Finally, an automatic task was created, on a daily bases, that updates the DW and its information cube.

4.7.1. Spreadsheet to Data Cubes Exploration

A spreadsheet in MS Excel 2010 properly connected to the source of the Analysis Services data type was created. In this sheet several pivot tables were created (PivotTable) in order to meet the functional requirements.

To check the accuracy of the information presented, unit tests were performed in order to compare against the results from the operational treasury management software.