Store Performance Dashboard: KPIs, Chart and Red Flags
This lesson is part of the course
In this lesson
You complete the monthly store dashboard: conversion, ATV and growth vs last year, a column chart of sales vs last year and a red flag on every store that shrank.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Footfall by Hour and Day with AVERAGEIFS Locked
- Conversion Rate: Transactions ÷ Visitors Locked
- Average Transaction Value and Units per Transaction Locked
- Sales = Traffic × Conversion × ATV: Explaining a Sales Change Locked
- Staff-to-Traffic Ratio and Conversion by Staffing Level (CORREL) Locked
- Store Comparison and Best-Practice Gaps Locked
- Weather and Event Effects on Traffic and Conversion Locked
- Store Performance Dashboard: KPIs, Chart and Red Flags Locked