Mediterranean Camera Company - Sales Dashboard

📄 Context The report provides an overview of insights derived from the FP20 Challenge 2 dataset, focusing on the performance of the Mediterranean Camera Company.

💼 Business problem The Mediterranean Camera Company seeks to understand its sales and profit trends to identify areas for improvement and capitalize on successful strategies.

🚀 Goal

• Undestand the patterns in net sales and profits to identify peak performance periods, enabling strategic resource allocation and planning.
• Identify key market segments to prioritize marketing efforts and strengthen relationships with profitable customers.
• Determine optimal sales timing by analyzing the distribution of product sales.
• Highlight best-selling products to guide inventory management and inform product development decisions.
• Investigate the factors driving fluctuations in profits over time to develop proactive strategies for sustaining growth and mitigating declines.

📝 Report Overview The report highlights key findings based on the FP20 Challenge 2 dataset:

1. Highest net sales and profits were recorded in October and December, indicating seasonal variations in performance.
2. Buyers from institutions in France emerged as the primary contributors to profits, suggesting the importance of this market segment.
3. Wednesdays consistently witness the highest average number of product sales, indicating a potential pattern in consumer behavior.
4. Camera 3 stands out as the best-selling product among the six different camera models, emphasizing its popularity.
5. Profits experienced remarkable positive growth from November to December but declined from February to March, warranting further investigation into underlying factors.