Stakeholder needs a dashboard that provide all the key metrics. MoM growth, comparative metrics, Target vs Actuals also presented. The dashboard should be dynamic including time filters daily, weekly, monthly, and quarterly. Key insights and observations from dataset and recommendation.
A single xlsx table that consist of several columns
Data head
First page of dashboard, shows all key metrics at top (scorecard). Sales target and achievement shows as progress barchart. Sales growth also using color that contrast the increase or decrease growth. The month and city can be filtered for specific date or region.
This section shows the customer related growth and customer aquisition based on region and store. Provided geospatial map for region rank based on sales and customers.
Time series for each store performance in aquisition of new customer. Location performance shows related each store sales, transaction, AOV, and new customer. Also provided AOV and avg basket size through time for selected city or store.
Provided insights and recommendation for stakeholder for further decision.