Retailers and manufacturers need to know how stores perform under various conditions, including during product promotions.
The screen above compares promoted sales at 57 participating stores during a 9-week promotion. Each store is in one of three classes: A, B, or C. The table in the upper left-hand corner of the screen ranks stores by unit volume. The table in the lower left corner of the screen aggregates sales by weekday.
The next graph to the right groups stores by store class, and the 7 circles to the right of each store aggregates unit sales for each day of the week over 9 weeks. Stores are sorted by unit sales in descending order within each store class, which makes it easy to identify "problem stores" within each store class. The next graph to the right compares total sales for each day of the week for each store to average total unit sales for each store for all 7 weekdays. The resulting calculation is named "absolute DSI" (for absolute daily sales index). The table in the upper right-hand corner of the screen aggregates unit sales by store class.