Data Lineage Analysis for Qlik Sense
| Thesis title in Czech: | Analýza datových toků pro Qlik Sense |
|---|---|
| Thesis title in English: | Data Lineage Analysis for Qlik Sense |
| Key words: | data lineage, dátové toky, business intelligence, qlik sense |
| English key words: | data lineage, data flow, business intelligence, qlik sense |
| Academic year of topic announcement: | 2019/2020 |
| Thesis type: | Bachelor's thesis |
| Thesis language: | angličtina |
| Department: | Department of Distributed and Dependable Systems (32-KDSS) |
| Supervisor: | doc. RNDr. Pavel Parízek, Ph.D. |
| Author: | hidden - assigned and confirmed by the Study Dept. |
| Date of registration: | 18.10.2019 |
| Date of assignment: | 31.10.2019 |
| Confirmed by Study dept. on: | 26.11.2019 |
| Date and time of defence: | 14.09.2020 09:00 |
| Date of electronic submission: | 28.07.2020 |
| Date of submission of printed version: | 31.07.2020 |
| Date of proceeded defence: | 14.09.2020 |
| Opponents: | Mgr. Martin Blicha, Ph.D. |
| Guidelines |
| Qlik Sense is a data analytics and reporting platform that creates visual representations of aggregated data from various sources, including popular relational database systems. Generated reports are stored internally in JSON files.
The goal of this project is to design and implement a tool for data lineage analysis of Qlik Sense reports, and integrate the tool within the Manta Flow platform. One of the main tasks to be performed is a thorough inspection of the structure and content of JSON responses from a Qlik Sense server, focused especially on precise identification of data sources for relevant entities present in the reports (e.g., columns in a bar chart) and their characteristics (e.g., font and color). For a given set of JSON files with reports, the tool should produce a graph that captures the flow between data sources and corresponding entities in the reports. Other specific tasks to be performed include syntactic and semantics analysis of the input JSON files, and extensive testing on real-world inputs. |
| References |
| 1. Qlik Sense. https://www.qlik.com/us/products/qlik-sense
2. Qlik Sense Developer Documentation. https://help.qlik.com/en-US/sense-developer/September2019/Content/Sense_Helpsites/Home-developer.htm 3. Qlik Sense JSON API Reference. https://help.qlik.com/en-US/sense-developer/September2019/APIs/EngineAPI/index.html 4. JSON specification (ECMA-404). http://www.ecma-international.org/publications/files/ECMA-ST/ECMA-404.pdf 5. Manta Flow platform. https://getmanta.com/ |