Supermart-SQL-Data-Analysis

In this project, I have analyzed the dataset related to a super market using dataset such as customer, sales, profit, product tables by solving 20 analysis questions


Steps to do this project:

1. Create a database with the tables (csv files)
2. Create the sql file by writing code and calculations for the given analysis questions
   
   
   Results Obtained:
3. Total Sales Amount by region
4. Total Sales ech customer segment contribute :--- Consumer >> 1161401.344 Corporate >> 706146.366 Home Office >> 429653.145
5. Top 5 Customers in terms of total sales is analyzed :--- Customer ID -- SM-20320 Tops the Chart
6. Ranking the products by sales
7. Calculating cumulative sales and running total by date
8. Percentage of Sales by each region (North, South, East, West)
9. Top 3 Customers by Profit
10. Calculating Total Sales for each product subcategories