QlikView as a Data Management Solution
Lopatenko, Anna (2015)
Lopatenko, Anna
Metropolia Ammattikorkeakoulu
2015
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2015120419381
https://urn.fi/URN:NBN:fi:amk-2015120419381
Tiivistelmä
The purpose of this thesis project was to conduct a study of data warehousing concepts and compare the technology to the data processing concepts used in QlikView application development. The project aimed to simulate an environment where data warehouse building stages could be utilized and applied to a QlikView environment.
The project consisted of a theoretical part which reviewed the main stages of data warehouse building including the information gathering and consolidation, data transformation and querying. It also provided an overview of business intelligence technologies and tools and an overview of the QlikView platform.
The practical part was aimed to support the theory and included an implementation of the final application. The aim was to go through each stage of data report creation in QlikView starting from the raw data extraction and ending with building a visual dashboard. The project aimed to compare both data warehousing and QlikView technologies and estimate the best possible solution for designing a centralized data system and creating further data analyses.
On the completion of the project it was concluded that the optimal solution for today’s business needs would be using a centralized data warehouse as a base or as one of the source data for future QlikView projects.
The project consisted of a theoretical part which reviewed the main stages of data warehouse building including the information gathering and consolidation, data transformation and querying. It also provided an overview of business intelligence technologies and tools and an overview of the QlikView platform.
The practical part was aimed to support the theory and included an implementation of the final application. The aim was to go through each stage of data report creation in QlikView starting from the raw data extraction and ending with building a visual dashboard. The project aimed to compare both data warehousing and QlikView technologies and estimate the best possible solution for designing a centralized data system and creating further data analyses.
On the completion of the project it was concluded that the optimal solution for today’s business needs would be using a centralized data warehouse as a base or as one of the source data for future QlikView projects.