Demo project (sample data): SQL

Demo project (sample data): SQL KPI analysis on a star schema (fact_sales with date, product and customer dimensions). Uses CTEs and window functions (LAG, RANK, SUM OVER) to calculate monthly revenue, order counts, average order value, month-over-month growth, revenue share by category, top cities and refund rate. The same queries feed the KPI dashboard demo.