Step 1. Compare sales dynamics of stores.
Display
sales charts for all stores, covering a minimum period of one year.
Compare the dynamics of store performance, such as revenue, number of purchases, average purchase amount, units per transaction, and so on. Clustering algorithms can help identify stores with similar performance. When there are only a few stores,
visually identifying stores with similar dynamics is also possible.
To
uncover hidden trends, analyze sales dynamics over
several years. As previously mentioned, hidden trends involve cases where a store is experiencing slow but consistent growth or decline.
Example 3 at the beginning of the article (regarding the impact of a new residential complex on sales during the pilot) demonstrates why considering trends is essential for pilot evaluation: