SQL-based EDA project exploring a retail data warehouse. Includes database setup and analysis scripts for data exploration, dimension profiling, date range discovery, measures analysis, magnitude breakdowns and ranking using aggregates and window functions.
data-science sql-server exploratory-data-analysis dimensions data-warehouse data-analysis academic-project aggregation measure-analysis smss window-functions-in-sql gold-layer
-
Updated
Dec 5, 2025 - TSQL