SQL Insights
A SQL Server project that pulls scattered retail data into one model and answers the basic questions a business keeps asking: when do we peak, which categories drive revenue, and who are our best customers.
Problem
Retail decisions were flying blind. The data lived in scattered CRM and ERP CSV files with no single source of truth. Reporting depended on ad-hoc SQL and spreadsheets, which made it slow and error prone.
Basic questions went unanswered: when do we peak, which categories drive revenue, and who are our best customers. Non-technical teammates also lacked a simple way to see the answers.
Approach
- Used the sandbox as a learning lab for analytics storytelling and governance.
- Serves as a template for future reporting layers on top of production data.
The project