|
|
Design of Data Warehouse and Data Structure in BigQuery for Selected Business
Šimková, Michaela ; Kříž, Jiří (referee) ; Luhan, Jan (advisor)
This master's thesis focuses on the design and implementation of a data warehouse and data structure in the BigQuery cloud environment, with the aim of analyzing data obtained from Google Analytics 4 and subsequent automation of processing these data and their visual interpretation. The theoretical part of the work presents key concepts and principles related to Business Intelligence, data warehouses, web analytics, and Business Intelligence tools in the cloud environment, thus providing the necessary theoretical basis for the practical part of the work. The practical part deals with the design of the data warehouse structure and a specific design of the logical and conceptual model of the data marketplace and its implementation in BigQuery. It describes the company's requirements, extraction of data from the primary system, creation of SQL queries to obtain historical data, and creation of ETL processes for automated processing of new data. The work also includes visualization of the obtained data using the Looker Studio, resulting in an interactive report allowing visual display of data for easier analysis. The objective of this work is to provide an efficient solution for processing web and application data of the selected company using BigQuery. This will enable the company to gain a better understanding of the acquired data, thereby facilitating strategic and informed decision-making.
|
guest ::
