04-01-2023 15:55 PM
Build a Dashboard for San Martins Store - Sales Analytics
Report Developer Role San Martins’ CEO Mr. Kevin Pastor-Franco is expecting a report with no more than 2 pages with a simple navigation menu.
1. Page1 should be an Executive overview of the January 2021 Sales with weekly KPI on Sales, Cost and Profit accompanied with other relevant visuals.
2. Page 2 should be dedicated to a Geographical view of San Martins Store operations; a Json Map of Spain is included in the datasets. You, as a report developer, must highly his 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.
San Martins Stores had 9 Sales Agents, and 6954 Customers present in 45 cities across Spain.
The business sales of January 2021, made
Total Revenue/Sales of 39.20 Million Euros,
Total Profit of 11.13 Million Euros,
Total Order of 14,059, and a Profit Margin of 28.29%.
Top 3 performing sales agents are
Juanito P. Quintero , Ricardo A.Casals., Evelia Carzorla