The topic of this master thesis is the application of BI (Business Intelligence) Solutions in the insurance industry. The main objectives are the creation of model analyses and the design and implementation of partial BI solutions on the QlikView platform for smaller non-life insurance companies. The model also takes into consideration aspects of the new EU insurance regulatory directive, Solvency II, by selecting input parameters needed for the calculation of premium and reserve risk using segmentation rules from the lines of business specified in the directive. The thesis consists of three main parts. The first focuses on the QlikView BI platform, its market place, architecture, SW components and the technologies it takes advantage of. It also examines the differences and specific aspects of developing a BI solution using QlikView, compared to other more traditional platforms - one of these aspects is associative data modeling. The second part of the thesis focuses on the financial risks that insurance companies are exposed to, methods for their quantification and techniques that are used for solvency determination -- based upon Solvency II guidelines -- using SCR (Solvency Capital Requirement) and MCR (Minimum Capital Requirement) indicators. Particular chapters explain the concept behind the Solvency II directives and demonstrate the structure of standard formulae used for SCR calculations, which are used for ascertaining the Premium and/or Reserve risk. The final part of the thesis builds upon the earlier sections and contains practical instructions and recommendations for the development of BI solutions based on the QlikView platform in smaller non-life insurance companies. A designed model of the BI application can primarily be used for basic corporate performance monitoring but can also assist in the partial calculation of some risk categories according to the Solvency II directives. The practical section -- which is the ultimate product and the main benefit of this master thesis -- expands beyond the theory to provide a basic conceptual framework for the development of BI applications in small insurance company environments.
| Identifer | oai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:165136 |
| Date | January 2011 |
| Creators | Majling, Matej |
| Contributors | Novotný, Ota, Daňhel, Jaroslav |
| Publisher | Vysoká škola ekonomická v Praze |
| Source Sets | Czech ETDs |
| Language | Slovak |
| Detected Language | English |
| Type | info:eu-repo/semantics/masterThesis |
| Rights | info:eu-repo/semantics/restrictedAccess |
Page generated in 0.002 seconds