saurabhpatel98 / sql-power-bi-clothify

SQL-Power-BI-Clothify

PROJECT PROPOSAL

The objective of this project is to gain insights into the Clothify business by quering and analysing the database using SQl and creating interactive visualizations with power BI. The project aims to answer questions related to customer behaviour, distributor performance, inventory management, order trends, and payment analysis. Clothify is an imaginary clothing database that I created, and the database contains several key tables, including customer, distributor, order, order item, product, product category, inventory, and payment.

TOOL USED:

Microsoft SQL Server Management Studio POWER BI

METHODOLOGY:

DATABASE - Clothify

CREATED TABLES :

1. Customer - it contains customer details including customerID, name, email, address, phone-no, gender, age
   
2. Distributor - it contains distributor details including DistributorID, Name, Email, Address, Phone-No, Gender, Age
   
3. Order Table - it contains order details including orderID, order date, customerID, status, order-no, total amount
   
4. Product Category - it contains details of product category which includes categoryID, name
   
5. Product - it contains details of product which includes productID, product name, description, price, distributorID, categoryID
   
6. Inventory - it contains inventory details including InventoryID, ProductID, Quantity
   
7. Order Item - it contains details of all order items which includes orderitemID, orderitem quantity, price, orderID, productID
   
8. Payment - it contains details of payment made by customer inculding tax amount which includes paymentID, payment date, amount, orderID, customerID
   

INSERTED RECORDS

PERFORMED ANALYSIS:

CUSTOMER

1. How many customers are there in total?
   
2. How many customers are male and female?
   
3. What is the average age of all the female customer?
   
4. How many customer placed the order and among them which customer placed the maximum order?
   
5. What is the distribution of customers by age group?
   
6. What is the lifespan of customer gretaer than 5 months?
   

DISTRIBUTOR

1. What is the distribution of distributors by gender?
   
2. Which distributor have the highest number of product?
   

ORDER

1. How many orders have been placed in total?
   
2. What is the total revenue generated from orders?
   
3. What is the Average Revenue Per order?
   
4. How many orders are in each status category?
   
5. What is the revenue distribution by product category?
   
6. How many order have placed per date by customer detail?
   

PRODUCT

1. What is the average price of products?
   
2. What are the top selling product?
   
3. What is the product distribution by category?
   
4. How many products supplied by each distributor?
   
5. What is the total revenue generated per product?
   

INVENTORY

1. How many items are in the inventory for each product?
   
2. Which products have low inventory quantities?
   
3. How many items are in the inventory for each distributor?
   
4. How does the inventory quantity change over time?
   
5. What is the average inventory quantity per product category?
   
6. What is the total value of inventory for each product?
   

ORDER ITEM

1. What is the average price of items per order and product?
   
2. How many items are in each order?
   
3. Which products have the highest quantity ordered?
   
4. How does the price of items vary across different orders?
   

PAYMENT

1. What is the total amount after 10% Tax?
   
2. how many payment made on each payemnt date?
   

DATA INJECTION INTO POWER BI USING DIRECT QUERY

DATA MODELLING

CREATED DASHBOARD USING DIFFERENT FEATURES AND VISUALIING CHARTS OF POWER BI

SQL-Power-BI-Clothify