Data Warehouse

1️⃣ OLTP to OLAP Schema Transformation:

Galaxy Schema was the most appropriate type in this case to be useful, clear and familiar with all aspects

2️⃣ ETL (Extract, Transform, Load) through SSIS:

Extracting the data from the "Gravity Book " database and loading it to its new home in an integrated and organized manner

3️⃣ Analysis through SSAS:

The data cubes were meticulously designed to facilitate multidimensional analysis, enabling detailed insights into order trends, customer behavior, and other key metrics.

4️⃣ Reporting through SSRS:

Extracting some distinctive and fast reports from the data, as it presents it in a different way and view