Project Overview
The Festival Economy Insights project explores how cultural events such as Diwali influence local and national economies through data-driven analysis. Festivals often act as powerful economic catalysts, leading to significant changes in consumer behavior, business sales, and market activity. The objective of this project was to analyze real-world Diwali sales data to identify patterns in consumer spending, demographic preferences, and regional economic impact during the festival season.
The dataset used, Diwali Sales Data, contained over 11,000 transaction records with information on customer demographics, product categories, locations, and purchase amounts. The data was cleaned by handling missing values, removing irrelevant columns, and standardizing features for accurate analysis. Key performance metrics such as total sales, total orders, and average order value were computed to understand overall market performance. The total sales during the Diwali period amounted to over ₹106 million, with an average order value of around ₹9,452, reflecting high consumer engagement during the festival.
Through detailed exploratory data analysis (EDA) and visualization using Python libraries like pandas, matplotlib, and seaborn, several insights were uncovered. Maharashtra, Delhi, and Karnataka emerged as top-performing states, while food, sweets, and home décor were among the most popular product categories. Gender- and age-based segmentation revealed that customers aged between 25 and 34 years contributed the highest share of total sales, and female customers accounted for a larger portion of spending compared to males. Zone-based heatmaps further showed that urban regions favored electronics and gadgets, while tier-two and tier-three cities preferred home décor and sweets, indicating diverse consumer behavior patterns across regions.
The project also explored correlations between order quantities and spending behavior, along with visualizations like pie charts, bar plots, and heatmaps to present findings clearly. Key insights emphasized that festive periods significantly influence consumer purchase decisions, product demand, and regional sales patterns.
In conclusion, the Festival Economy Insights project effectively demonstrates how data analytics can quantify the economic impact of cultural festivals. By translating raw transactional data into meaningful insights, it enables retailers, marketers, and policymakers to optimize inventory planning, targeted marketing, and logistics strategies during high-demand festive periods. The project combines strong data cleaning, visualization, and storytelling techniques to reveal how festivals act as both cultural celebrations and economic growth drivers.