🔳 Local Store Sales Analysis ${\color{blue}(using\ SQL-SERVER)}$

${\color{red}Go\ to}$ 🔗 SQL Queries

◻️ Objective

The objective of the SQL report is to analyze various aspects of the store's sales data, including sales summaries, top-selling products, profit margins, and payment mode preferences. Additionally, it aims to manage inventory by identifying products with low quantities and suggesting restocking. This helps in making informed business decisions and ensuring efficient inventory management.

◻️ Tech Stack

• SQL Server
• Microsoft Excel

◻️ Steps includes

• Data Refinement
• Creating a Database and a Table
• Importing Excel Dataset to SQL Server
• Data Analysis by various SQL queries

◻️ Analysis includes

• Sales Summary Analysis
• Top-Selling Products Identification
• Profit Margin Calculation
• Profitability Categorization
• Payment Mode Popularity Analysis
• Inventory Level Monitoring
• Restocking Suggestions
• Aggregation of Sales Data
• Product Category Performance Analysis
• Transaction Count Analysis

◻️ Key Insights

• Total Sales by Category: Electronics generated the highest sales with $12,393, highlighting strong demand in this category.
• Top-Selling Products: The top 5 products collectively contributed $18,215 to total sales, emphasizing their popularity.
• Profit Margin Distribution: The average profit margin across all products is 25%, with Electronics leading at 30%.
• High vs. Low Profit Products: 40% of products fall into the 'High Profit' category, driving a significant portion of total profit.
• Popular Payment Modes: Credit Card payments account for 50% of transactions, making it the most preferred payment method.
• Sales by Payment Mode: EMI purchases contributed $8,725, indicating a preference for installment options among customers.
• Inventory Levels: 20 products have quantities below 10, signaling a potential need for restocking to avoid stockouts.
• Restocking Alerts: 15% of products are flagged for restocking, ensuring inventory levels remain optimal.
• Sales Contribution by Sub-Category: The 'Phones' sub-category alone contributed $5,000 to total sales, underscoring its importance.
• Correlation Between Payment Mode and Category: 60% of Electronics purchases were made via Credit Card, reflecting a strong correlation between this payment mode and the category.