FP20 Mediterranean Cameras Company

The Mediterranean Camera Company’s CFO Ms. Toni Hewlett is expecting a report with no more than 2 pages with a horizontal navigation menu. This is an (EDA) Exploratory Data Analysis and product specifications have been masked.

1. Page 1 should be an Executive overview of the Company Sales performance YTD report.
2. Page 2 should be dedicated to a Products Data Analysis and Time Intelligence report. Any trends/seasonality for any of the Products and or Countries of sales. Does any product sell more over weekends?

Key Insights :

1. United Kingdom is the top country by Net Sales
2. France is the top country by Profit.
3. Camera 3 is the best selling product on Weekdays.
4. Camera 5 is the best selling product over Weekends.
5. Quarter 4 Net sales growth is more specially in the month of October & December with high profits.
6. Quarter 1 has least Net sales and profit.
7. Low Discount band has the highest Profit
8. Thursday is the best weekday.