This project presents an end-to-end Exploratory Data Analysis (EDA) of a Diwali sales dataset using Python. The objective was to analyze customer purchasing behavior, identify key sales trends, and uncover actionable business insights that can support data-driven marketing and sales strategies.
Using Python and its data analysis libraries, the dataset was cleaned, explored, and visualized to understand customer demographics, purchasing patterns, and product performance during the festive season.
Understanding customer behavior is essential for developing effective marketing strategies and maximizing revenue during high-demand periods. This project analyzes historical Diwali sales data to identify the most valuable customer segments, popular product categories, and purchasing trends that can help businesses improve customer targeting and increase sales.
- Perform data cleaning and preprocessing.
- Conduct exploratory data analysis (EDA).
- Analyze customer demographics and purchasing behavior.
- Identify top-performing product categories and sales trends.
- Generate business insights and recommendations to improve revenue and customer engagement.
- Python
- Jupyter Notebook
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Data Collection
- Data Cleaning
- Data Preprocessing
- Exploratory Data Analysis (EDA)
- Data Visualization
- Business Insight Generation
- Business Recommendations
The analysis includes:
- Customer Demographics
- Gender-wise Purchasing Analysis
- Age Group Analysis
- State-wise Sales Performance
- Occupation Analysis
- Product Category Analysis
- Product Performance
- Revenue Trends
- Married women aged 26–35 years represented the highest purchasing segment and contributed significantly to overall sales.
- Certain product categories consistently generated higher revenue during the Diwali season, indicating strong customer demand.
- Sales trends revealed clear seasonal purchasing patterns that can be leveraged for future marketing campaigns.
- Customer demographic analysis provided valuable insights for targeted promotions and personalized marketing strategies.
Based on the analysis, the following recommendations are proposed:
- Focus marketing campaigns on married women aged 26–35 years, the highest-value customer segment.
- Increase inventory and promotional efforts for top-performing product categories during festive seasons.
- Use demographic insights to create personalized marketing campaigns and improve customer engagement.
- Leverage historical sales trends to optimize inventory planning and demand forecasting for future festivals.
- Python Programming
- Exploratory Data Analysis (EDA)
- Data Cleaning
- Data Preprocessing
- Data Visualization
- Business Analytics
- Statistical Analysis
- Analytical Thinking
- Business Insight Generation
- Dataset
- Jupyter Notebook
- Visualizations
- Project Documentation
- README
This project demonstrates the use of Python for exploratory data analysis by transforming raw sales data into meaningful business insights through data cleaning, visualization, and analytical reporting. It showcases practical skills in Python, data analysis, and business intelligence, making it a strong portfolio project for Data Analyst, Business Analyst, and Business Intelligence roles.