Create data base

Project: Sales Analytics & Business Intelligence System

This project is a comprehensive SQL-based analytics system designed to simulate a real-world sales environment and generate actionable business insights.

I designed and implemented a complete relational database (SalesAnalytics) including customers, products, orders, and order_items tables with proper constraints, relationships, and indexing to ensure performance optimization.

The project includes:

* Database Design (DDL): Created normalized tables with primary keys, foreign keys, and constraints.

* Data Simulation: Inserted realistic sales data across multiple months, including seasonal spikes, discounts, and cancelled orders.

* Performance Optimization: Added indexes on key columns such as customer_id, order_date, and product_id.

Advanced Analytics & Reporting:

* Created views for business insights:

* Monthly Revenue tracking with time-based aggregation

* Active customers within a 90-day window

* Top-selling products using ranking functions

* Implemented analytical queries using:

* CTEs (Common Table Expressions)

* Window functions (ROW_NUMBER, LAG)

* Aggregations and KPIs

Key Insights Generated:

* Identified high-value customers based on total revenue contribution

* Calculated Month-over-Month (MoM) revenue growth percentages

* Analyzed category performance including total revenue, number of orders, and average order value

* Built a regional leaderboard to identify top customers per region

Technologies Used:

* SQL Server

* T-SQL (Views, CTEs, Window Functions)

* Data Modeling & Normalization

* Business Intelligence Concepts

This project demonstrates my ability to design scalable databases, perform advanced data analysis, and extract meaningful business insights from raw transactional data.