FactFactPurchases5 columns
Columns
- DateDimDate.Date
- CustomerIDDimCustomer.CustomerID
- ArticleIDDimArticle.ArticleID
- ChannelKeyDimChannel.ChannelKey
- Price

This saved chart from the H&M retail report breaks sales changes into buyer numbers, items per buyer, price and product mix. It compares 1 January to 22 September 2020 with the same dates in 2019, excluding leap day.
Sales fell 10.9% even as the number of buyers grew 1.6%. The largest downward bar shows that fewer items per buyer outweighed the gain from additional buyers. Changes in prices and the mix of products sold offset part of the fall.
Explore the data model ↓Aggregate analysis of the H&M fashion recommendations data. Competition data terms.
One row represents one purchased article. Article, customer, date and channel describe the purchase; price sits on the fact table.