Portfolio Details

Project Information

Category: Data Analytics
Client: Self-Directed Project
Project date: August, 2025
Project URL: Ademola-1/shopsmart-sqlserver

Project Overview

ShopSmart is an end-to-end SQL Server analytics project showcasing a retail star schema with CSV seed data and executive analytics. It answers leadership questions around year-over-year revenue and margin, channel mix, return drivers, cohort retention, and RFM segmentation. Built and tested in SSMS, with a lightweight ERD rendered in Mermaid.

Key Features

Dimensional model

FactSales and FactReturns linked to DimDate, DimProduct, DimCustomer, DimStore, and DimPromo (star schema).

Executive KPIs

YoY revenue & margin, channel performance, return root-cause signals, customer retention cohorts, and RFM.

Reproducible setup

CSV seed data and reusable views for quick spin-up and testing.

Tooling

SQL Server (T-SQL) in SSMS; ERD published alongside the repo