Sales analysis SQL project

the project description

This project analyzing sales dataset using SQL 

  This dataset includes four main table 
    - customers 
    - invoces 
    - invoicedetails 
    - products
  # The goal is to perform _ sales analytics and  _ customers segmentation 

files included *

database sqript.sql :- All create table statements constraints analysis queries data_diagram.png:- relationship diagram for all tables readme.md:- 'this file" documentation of the project

the analysis questions implemented __

1\ sales analysis

 -what are best salling products 
 
 -what are the most profitable monthes 
 
 -what are the most profitable day by week
 
 -who are the top customers by revenue 
 
 -what is total revenue 

2\ customer segmentation

 -how much did each customer spend
 
 -classifing customers into high-- medium -- low value groups 

How to use

import the SQL script into your SQL server

run the database ' e_commerce " in your server

run the analysis queries

Technologies used -SQL server 'ssms'