Retail Sales Analytics : 2-Wk Proof of Concept

Create a roadmap to build intuitive dashboards with this Proof of Concept to analyse profit margins for retail outlets. Enable real time visibility at stock keeping unit level in terms of velocity.

The pilot implementation can be personalized to provide the right information regarding the store performance based on retail sales data.

Agenda:

Week 1

• Identifying the nature of the sales data from retail outlets
• Understand business needs from data insights
• Create roadmap to build a PoC using Power BI

Week 2

• Design build, data connections, and dashboards based on the findings of Week 1
• Regular demonstrations for feedback
• Final handover of dashboards with documentation

Deliverables

• Sales comparison and collection dashboard; YoY, QoQ, and MoM
• Solution architecture for store data analytics
• Data model to manage retail transactional data at store level
• Connection with one point-of-sale data source
• 3 - 4 dashboards, each dashboard with 5 - 6 visuals

Pre-requisites

• Sales performance indicators (SPIs) and dashboard ideas gathered through discussion with stakeholders
• Sample data stream for the SPIs