FNP faces challenges in understanding its sales performance across diverse products, occasions, and regions, hindering its ability to make data-driven decisions for maximizing revenue and operational efficiency. With datasets encompassing customer demographics, product details, and order history, there was a need for a centralized system to visualize key metrics such as revenue trends, best-selling products, and geographical performance. Seasonal spikes during festivals like Diwali and Raksha Bandhan highlight opportunities for inventory optimization, while underperforming categories like Plants require targeted strategies for growth. To address these gaps, the FNP Sales Analysis Dashboard was developed using Excel, incorporating interactive filters, pivot tables, and visualizations to empower stakeholders with actionable insights and facilitate effective decision-making.
The Sales Analysis Dashboard is designed to provide actionable insights into key performance metrics across products, occasions, cities, and categories, facilitating informed decision-making for maximizing revenue and operational efficiency.
The project utilizes the following datasets from FNP:
- FNP Customers: Contains customer details, including demographics and purchasing history.
- FNP Products: Includes information about products offered, their categories, and pricing.
- FNP Orders: Captures order details, including order date, delivery date, revenue, and associated products.
- Total Orders: 1,000
- Total Revenue: ₹3,520,984
- Average Delivery Time: 5.53 days
- Average Spend per Customer: ₹3,520.98
These figures reflect strong consumer engagement and an opportunity to optimize delivery time for better service standards.
The dashboard showcases sales performance across various occasions, identifying the highest and lowest revenue-generating periods.
- Top Occasions:
- Anniversary (₹674,634)
- Raksha Bandhan (₹631,585)
- Diwali (₹574,682)
- Lowest Occasion: Birthday (₹313,783)
Insight: Special promotions or campaigns targeting lower-performing occasions like birthdays can enhance overall revenue.
The revenue segmentation shows Cakes and Colors dominate sales.
- Top Revenue Contributors:
- Colors (₹1,005,645)
- Soft Toys (₹740,831)
- Sweets (₹733,842)
Recommendation: Expand inventory in high-performing categories while exploring opportunities to increase sales in underperforming categories like Plants (₹21,281).
Analyzing revenue by city, Mumbai leads in sales performance:
- Top-Performing Cities:
- Mumbai (₹29,000)
- Delhi (₹27,000)
- Ahmedabad (₹24,000)
Opportunity: Strengthen marketing efforts in emerging cities with potential to maximize returns.
- The revenue graph reveals spikes in September and festive seasons. This aligns with high-performing occasions like Diwali and Raksha Bandhan.
- Recommendation: Align promotional strategies and stock availability for peak months to handle increased demand seamlessly.
The five best-selling items have been identified, indicating customer preferences:
- Magnum Set: ₹121,905
- Quia Gift: ₹114,476
By leveraging this data, the business can curate product bundles and combos targeting the best-selling products for future campaigns.
The dashboard incorporates user-friendly filters, empowering the end user to refine the analysis:
- Order Date Filter: Enables time-specific sales analysis.
- Delivery Date Filter: Highlights logistical efficiency.
- Occasion Filter: Segments insights to focus on individual special occasions.
- Microsoft Excel: To create the interactive dashboard.
- Pivot Tables and Charts: For data summarization and visualization.
- Slicers: To enable easy filtering and exploration of data.
-
Open the Excel file containing the dashboard. Download the FNP Sales Analysis Dashboard
-
Explore the pre-built charts and graphs for a holistic view of sales performance.
-
Use the provided slicers to filter data based on your desired parameters, such as time periods, occasions, or product categories.
-
Analyze insights from the metrics displayed to understand trends and performance.
- Seasonal Trends: Peak revenue during festive occasions such as Diwali and Raksha Bandhan indicates the need for optimized inventory planning during these periods.
- Geographical Opportunities: Cities like Mumbai and Ahmedabad have strong performance. Focused regional campaigns could yield better results.
- Underperforming Categories: Explore strategies to improve sales in categories like Plants.
- Customer Behavior: High average customer spending suggests potential for introducing premium product bundles.