Mediterranean Camera Sales Dashboard

Reports Required :

Executive overview of the Company Sales performance YTD report

Products Data Analysis and Time Intelligence report.

Business Goals:

Any trends/seasonality of sales

Weekend or Weekdays Sales high or low

Particular product selling better

Country having better sales /profit

Key Insights :

• Sales and Profit for the year Total profit of $13 million was generated in 2021. October and December months generated high sales. November month generated lowest sales with $5 million. Overall Q4 showed better sales compared to other 3 quarters. Total revenue of $92 million was generated during the year.

• Product wise Sales Camera 3 was the best-selling product, generating $27 million sales for the year.

• Country wise Sales UK was the bestselling country, with $19.9 million.

• Country wise Profit France generated highest profit with $2.9 million

• Discount Band "Low" discount band generated better profits.

• Day wise Sales Weekdays are giving better sales than weekends.

• Featured Buyers "Institutions" were the biggest buyers, with $39.42 million in purchases.