FP20 Analytics Challenge 1

Situation: San Martins’ CEO Mr. Kevin Pastor-Franco is expecting a report with no more than 2 pages with a simple navigation menu.

Task: To create a report as per the following requirements,

• Page 1 should be an Executive overview of the January 2021 Sales with weekly KPI on Sales, Cost, and Profit accompanied by other relevant visuals.
• Page 2 should be dedicated to a Geographical view of San Martins's Store operations; a Json Map of Spain is included in the datasets. Must highlight 2 best performing Sales Agents and information about what product these Sales Agents sell more and where (Location). San Martins' CEO would also like to know his worth-performing Sale Agent.

Action:

Created two sheets sharing the following insights,

• Executive summary - describing the Sales, Profit, and Cost (on a weekly basis) along with the top stores, products, and customers (all based on sales revenue).
• Geographical View & Analysis - The second report describes the analysis based on the geographical location of the stores which comprises of sorting and highlighting top agents (based on sales), top 10 products and their profit %, the region with the total product sold along with their profit (drill down included) and the categorization of order based on no. of items ordered.
• Included slicers that enable the user to easily get a sales insight based on product category and region, and the slicers are linked between pages for consistency.

Result:

A report has been generated as per the user's request and as a result, my first submission in the FP20 Analytics Challenge group has been made.