Scribd
Upload
8 views

EDA on Sales Data using MySQL and Power BI

Uploaded by

Ramesh chaudhary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views

EDA on Sales Data using MySQL and Power BI

Uploaded by

Ramesh chaudhary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 14

Exploratory Data

Analysis (EDA)
Project
Sales - MySQL Analysis
Project Overview
• Objective:
• Analyze customer behavior, sales trends, and product
performance.

• Datasets:
• - Category
• - Order_Details.csv
• - Orders
• - Users
Database Design
Schema Definition:

Category: CategoryID, CategoryName, Description

Order_Details: OrderDetailID, OrderID, ProductID, Quantity, UnitPrice, Total

Orders: OrderID, UserID, OrderDate, OrderStatus

Users: UserID, UserName, Email, RegistrationDate, Location

Relationships:

- Foreign keys link Orders to Users and Order_Details.


Key Questions:
1. Sales Performance:
• Total sales by category and
product.
Data
Exploration 2. Customer Insights:
- Key • Active locations and top
buyers.
Questions
3. Operational Insights:
• Order status breakdown
and trends.
SQL Queries

1. Total Sales by Category:

Result:
2. Monthly Sales Trends:

Result:
3. Find the top 5 users who have spent the most amount of
money.

• Result:
4. Calculate the monthly revenue for the year 2019.

Result:
5. Identify the category with the highest average profit per order.

Result:
6. Find the user who has placed orders in the most number of
different categories.

Result:
7. Calculate the total profit for each user and categorize them into 'High',
'Medium', and 'Low' profit groups.

Result
Result:
8. Find the top 3 cities with the highest average order amount.

Result:
Visualization using Power BI
Insights
1. Total Sales by Category: Identifies which categories generate the most revenue.
2. Monthly Sales Trends: Shows sales trends over time, highlighting any seasonal
patterns.
3. Top 5 Users by Spending: Recognizes the top 5 users who have spent the most
money.
4. Monthly Revenue for 2019: Analyzes financial performance month by month for
2019.
5. Category with Highest Average Profit per Order: Identifies the most profitable
category.
6. Monthly Order Count for 2019: Understands order volume trends throughout 2019.
7. User with Most Diverse Orders: Recognizes users with diverse purchasing habits.
8. Total Profit by User and Profit Group: Segments users based on their profitability.
9. Top 3 Cities by Average Order Amount: Identifies the most lucrative markets.

You might also like