Návrh a implementace datového skladu v cloudovém prostředí pro projekt webové aplikace vybrané společnosti

This thesis focuses on the design and implementation of a data warehouse solution for a web application project. An important aspect of the entire technological solution is that it is built using cloud tools and services offered by Google. Besides the data warehouse itself, this thesis presents how to connect the data to a data visualization tool and create a dashboard. The thesis has six chapters. The first two chapters are the theoretical part of the thesis, and the remaining four chapters are the practical part. The theoretical part describes the principles of data analytics and Business Intelligence, followed by its components, that usually create Business Intelligence solutions and eventually are presented possible architectures of BI solutions. At the end of the theoretical part are presented the tools, which were used for the implementation of the designed solution in the practical part. The practical part aims to describe the design and its implementation using the tools, which are presented in the theoretical part. The goals of this thesis were to gather requirements for the BI solution, design the data warehouse in the cloud environment using Google Big Query, followed by implementation of the designed solution including the set-up of ETL processes. The last of the goals was to connect the data warehouse to a visualization tool Google Data Studio and create a basic data dashboard.