Data Warehouse and Aanlytics Project

Definition

An advanced SQL project focused on transforming retail operational data into a structured analytical database using Data Warehouse concepts, relational modeling, and advanced SQL techniques.

The project aims to build a Star Schema consisting of fact and dimension tables, then use advanced SQL queries, views, and stored procedures to analyze sales performance, profitability, customer behavior, and business trends.