Retail Orders
Data Analysis
Downloading Data
Data Analysis using SQL
Data Cleaning Loading
and Processing Data
-By Deepanshu
1. Introduction
2. Objectives and Scope
3. Workflow
Table of 4. Data Collection and Loading
Contents 5. Data Cleaning
6. Data Analysis
7. Insights and Results
This project focuses on a comprehensive
analysis of sales data to uncover key
performance insights. Utilizing Python for data
cleaning ensured the accuracy and reliability of
the results. The analysis covers revenue
generation, sales performance, and profit
growth, providing valuable information to guide
strategic decisions.
Identifying top revenue-generating products.
Assessing regional sales performance.
Comparing year-over-year sales growth.
Highlighting profit growth trends.
Data Cleaning: Used Python for thorough data cleaning to ensure accuracy.
Performance Analysis: Assessed revenue generation, regional sales, and profit growth trends.
Data Sources
•Orders dataset containing information about order id, order
date, product id, cost price, listed price, discount etc.
Data Loading Process
•Data was initially loaded into Python for preprocessing and then
imported into the raw data layer of SQL.
Null Handling
To ensure data consistency and accuracy, we implemented null value handling by
replacing occurrences of "unknown" and "Not Available" with NaN (Not a Number)
in the "Ship Mode" column. This approach streamlines data preprocessing,
enabling clearer insights during our analysis phase.
Standardizing Column Names
To ensure uniformity and ease of access, we standardized column names in our
dataset. The transformation involved converting column names to lowercase and
replacing spaces with underscores for consistency.
Product Id product_id
Addition of New Columns
To further enhance our dataset for comprehensive analysis, we introduced the
following new columns:
Discount per Unit: Calculated as a percentage of the list price.
Sale Price: Derived by subtracting the discount per unit from the list price.
Profit: Determined by subtracting the cost price from the sale price.
Conversion of Order Date to
Datetime
To enhance analysis and ensure consistency in date handling, we converted
the "order_date" column to datetime format . This transformation enables
accurate date-based calculations and insights within our dataset.
[Link] top 10
highest
revenue
generating
products.
[Link] 10
highest
revenue
generating
products.
[Link] top 5
highest
selling
products in
each region.
[Link] 5
highest
selling
products in
each region.
[Link] month
over month
growth
comparison
for 2022 and
2023 sales.
[Link] month
over month
growth
comparison
for 2022 and
2023 sales.
[Link] each
category
which month
had highest
sales.
[Link] each
category
which month
had highest
sales.
[Link] sub
category had
highest
growth by
profit in 2023
compare to
2022.
[Link]
category had
highest
growth by
profit in 2023
compare to
2022.
Technology Leads Growth:
Categories like Machines and Phones saw significant growth in 2023, with increases of
64.54% and 21.21% respectively.
Declines in Traditional Categories:
Furniture categories such as Chairs (-4.37%) and Tables (-31.94%) faced challenges in
sales growth.
Rising Demand in Office Essentials:
Office Supplies, including Supplies and Binders, showed strong growth, indicating
increased demand driven by evolving work environments.
Focus on High-Growth Technology:
Prioritize products like Machines and Phones to capitalize on substantial growth
opportunities.
Strategic Pivot in Furniture Categories:
Address declines in traditional segments like Chairs and Tables through targeted
adjustments and resource reallocation.
Expand in Office Supplies:
Seize opportunities in growing categories such as Office Supplies (Supplies, Binders)
to enhance market presence and meet evolving consumer demands.
Adapt to Remote Work Trends:
Tailor product offerings to support remote work environments, ensuring alignment with
changing consumer behaviors and needs.
Thank You!
Your engagement and attention
are greatly appreciated.
Have a great day!
