Project-3

Exploratory Data Analysis on Diwali Sales || Python

Conducted a comprehensive Exploratory Data Analysis (EDA) on Diwali sales data, unraveling key insights into buyer behavior and preferences across various categories.

Objective:

Conducted a comprehensive Exploratory Data Analysis (EDA) on Diwali sales data, unraveling key insights into buyer behavior and preferences across various categories.

EDA performed on following factors:

Gender Analysis:
Predominantly, female buyers drove the sales, showcasing higher purchasing power compared to male buyers. Data Highlights: Majority of transactions and purchasing power concentrated in the female demographic.

Age Group Distribution:
The age group "26-35" among females emerged as the primary buyer segment. Data Highlights: Sales were most prominent within the 26-35 age range for female buyers.

Regional Impact:
Uttar Pradesh, Maharashtra, and Karnataka stood out as the states with the highest order frequency and total sales. Data Highlights: Concentrated sales and orders from these key states drove overall performance.

Marital Status Influence:
Married women emerged as a significant buyer group, demonstrating high purchasing power. Data Highlights: Majority of purchases were attributed to married women, indicating a strong market presence.

Occupational Trends:
IT Sector, Healthcare, and Aviation occupations played a prominent role in driving sales. Data Highlights: Buyers associated with these occupations contributed significantly to overall transactions.

Top Product Categories:
The highest sales were observed in product categories like Food, Clothing, Electronics, and Footwear.

Conclusion:

The Diwali Sales Data EDA delves into buyer behavior, spotlighting key trends. Female buyers, particularly in the 26-35 age group, dominated, with married women exhibiting substantial purchasing power. Regional impact was notable in Uttar Pradesh, Maharashtra, and Karnataka. Occupationally, the IT sector, Healthcare, and Aviation were pivotal. Top-selling categories include Food, Clothing, Electronics, and Footwear. This EDA serves as a strategic tool, guiding targeted marketing and inventory planning for enhanced business outcomes.