Project description:
In this project were employed software languages and tools (SQL Management Studio, Microsoft Azure, Python, Visual Studio) for the design of the datawarehouse and its data population through ETL flows. The snowflake schema was then used to generate an OLAP cube which was queried through MDX. Ultimately, we used the multidimensional structure to extract information and buils KPI using Power BI.