Sales Analytics SQL Project

Project Overview

This project contains a complete Sales Analytics database built with T-SQL. It simulates a realistic e-commerce environment with customers, products, orders, and order items, including seasonal trends, discounts, and one cancelled order.

The repository demonstrates best practices in relational database design and advanced SQL analytics.

✨ Key Features

Relational Database Schema with proper primary keys, foreign keys, and constraints

Performance Indexes on frequently queried columns

Realistic Seed Data: 10 customers, 12 products, 32 orders spanning 14 months

Analytical Views for quick business reporting

Advanced Queries using CTEs, Window Functions, and aggregations

Revenue calculation logic: quantity × unit_price × (1 - discount_rate)