This repository creates a data warehouse using snowflake model technique for a football game management company called "Moments" (fictional) and some SQL queries to analyse data.
Toolkit used in this repository: MySQL and dbdiagram.io
The design of data warehouse contains the fact event, the dimensions time, stadium, public, game and the sub dimension championship.
Data model:
