Návrh a implementace datového skladu a navazujícího reportingového řešení pro podporu strategického řízení v B2B společnosti

This thesis presents the design and implementation of a modern cloud data warehouse for the growing B2B company, Behavio. The primary objective of the project is to unify a fragmented data environment, eliminate inefficient manual reporting in spreadsheets, and establish a Single Source of Truth (SSOT) for financial and human resources domains. Both the theoretical and practical approaches are guided by the CRISP-DM methodology, ensuring a close alignment between the technical solution and the organization’s actual business processes. The technical architecture is built on the Google Cloud Platform, utilizing BigQuery and Dataform services. The implemented medallion architecture provides fully automated data cleaning, transformation, and historization for data sourced from the Abra, Berta, and Sloneek systems. The project outcome is an interactive reporting system developed in Looker Studio, which provides management and team leaders with key metrics in real-time while maintaining high performance and responsiveness. The evaluation confirmed high operational efficiency with minimal computational and storage costs. The primary benefits of the implementation include significant time savings for the finance department, the transformation of the CFO’s role toward strategic analytics, and the overall democratization of data access across the company. The thesis also defines a strategy for future development, focusing on infrastructure automation via Terraform and the integration of artificial intelligence for advanced data analytics.