Skip to main content
DD-RET-004 Enterprise Retail Profitability and Inventory Optimisation Get the data →
DD-RET-004-Q053 Very Hard Time series

Most seasonal category

Build a seasonal index (calendar month sales divided by the average month) per category. Which category has the strongest peak month?
Expected
Category seasonality table; leading row · Seasonal line chart
Tables
FactSalesTransactions, DimDate, DimProduct · columns
  • FactSalesTransactions
  • DimDate
  • DimProduct
  • NetSalesSAR
  • TransactionDateKey
  • MonthNumber
  • CategoryName

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.