FP20 Analytics Challenge 2

Situation: CFO Toni Hewlett of The Mediterranean Camera Company anticipates a report with a horizontal navigation menu and no more than two pages.

Task: To Create a report that includes an executive summary of the company's sales performance on the first page and attention to product data on the second page.

Action:

1. Executive Overview: Its purpose is to describe the sales of the Mediterranean Camera Company by analyzing the sales, costs, profit percentage, profit margin percentage, and their relationship with the discount provided and the rolling sales percentage (month-to-month comparison), among other things.

2. Product Analysis: To find the performance of different products by means of their strong relationship with buyers (with a decomposition chart), with discount bands, and further analysis with the day of purchase to know the trend in product purchase.

Result:

Have created a report with the interaction between two pages by enabling global filters and letting the visuals present the data accordingly.