Data Warehouse usage in an insurance company environment
Kosonen, Jenna Vivi Maria (2019)
Kosonen, Jenna Vivi Maria
2019
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2019121827446
https://urn.fi/URN:NBN:fi:amk-2019121827446
Tiivistelmä
A data warehouse is the main source of data within a company. All the relevant inputs to leads and trends can be built up on data warehouses data collections. It is important to keep the data relevant and updated to be used in daily bases.
The main goal of the thesis was to expand the readers’ knowledge of data warehouse and describe the different methods used to bring in the data that is needed. Additional goals of the thesis were to show how the data is loaded in to the database and to explain what implications GDPR has for a data warehouse.
The goals of this thesis were achieved by having a communication between the IT department and the other departments of an insurance company to know what data needed to be stored for data analysis within the insurance company.
The thesis explains the Extract, Transfer and Load method which is the main method of extracting, transferring and loading data into the database. Historical data loadings are usually the only way that data is loaded in to the core of databases, so that there is a timestamp when an older version was relevant.
A great amount personal data can be found within the data warehouse of an insurance company, therefore data protection needs to be taken into account. According to the General Data Protection Regulation, GDPR, customers have right to access any information that a company holds on them, and the right to know why that data is being processed, how long it is stored for, and who can see it.
The main goal of the thesis was to expand the readers’ knowledge of data warehouse and describe the different methods used to bring in the data that is needed. Additional goals of the thesis were to show how the data is loaded in to the database and to explain what implications GDPR has for a data warehouse.
The goals of this thesis were achieved by having a communication between the IT department and the other departments of an insurance company to know what data needed to be stored for data analysis within the insurance company.
The thesis explains the Extract, Transfer and Load method which is the main method of extracting, transferring and loading data into the database. Historical data loadings are usually the only way that data is loaded in to the core of databases, so that there is a timestamp when an older version was relevant.
A great amount personal data can be found within the data warehouse of an insurance company, therefore data protection needs to be taken into account. According to the General Data Protection Regulation, GDPR, customers have right to access any information that a company holds on them, and the right to know why that data is being processed, how long it is stored for, and who can see it.