Standardization of data structures of a financial BI solution

In this diploma thesis I concentrate on analysing the possibilities of standardization of financial Business Intelligence solution. The objective is firstly to assess whether it is useful to create a so-called standard model, i.e. a solution model, which could be used repeatedly in independent BI project implementations. The objective is to analyse whether there are similarities among the implemented BI projects in terms of content requirements (measures and dimensions), or what are the differences. The objective is then to design a standard solution model (design relational and dimensional model for data structures). Another objective is to create a functional prototype solution based on the designed model, i.e. to create the actual data structures and fill them with data. A part of this prototype solution should be a set of demonstrative reports. The objectives will be achieved first of all by analysing the theoretical foundations, which provides the literature, and by analysing available real project documentation. Considered BI projects have been implemented within several non-financial commercial institutions. That means that the outputs of this thesis are applicable primarily in non-financial enterprises environments. In the next step, the dimensional modelling techniques will be used to create the schema. Then, leveraging the knowledge of BI solution development techniques on Microsoft SQL Server platform, the prototype solution will be deployed. Reports will be developed using the Microsoft Excel client tool. The benefit of this thesis consists in the model added value, which can be used as the core of newly developed financial BI solutions. The implementation process should by this spare some time. Another benefit of the thesis is the possible use of the prototype solution as a tool for customized demonstration of the financial BI capabilities to potential customers.