Final Thesis: Web App Analytics Warehouse with BigQuery

Abstract: In established “Software as a Service” markets, user acquisition is one of the most important but at the same time most challenging tasks for new platforms. Both advertising campaigns and search engine optimization require a broad and reliable dataset as a basis for decision-making and optimizations, as well as an intuitive yet powerful interface for visualization and evaluation of this data. QDAcity is a competitor in the qualitative data analysis space, dealing with exactly this challenge. As part of this work, an analytics warehouse was planned and built specifically for QDAcity, tailored to the requirements and needs of the application. In addition, an interactive admin dashboard was designed and implemented using React, allowing for real time aggregation, evaluation and visualization of the collected data. In this context, the advantages and motivation for an in-house implementation compared to the purchase of existing external software are discussed as well.

Keywords: Analytics, GCP, BigQuery, QDA Software, QDAcity

PDF: Bachelor Thesis

Reference: Andreas May. Web App Analytics Warehouse with BigQuery. Friedrich-Alexander-Universität Erlangen-Nürnberg: 2024.