Signed mean error
Forecast bias by category (STATISTICAL): AVG(forecast - actual). Show category and bias.
| Column | Type | Key |
|---|---|---|
| actual_id | INT | PK |
| sku_id | INT | FK → dim_skus |
| location_id | INT | FK → dim_locations |
| period_date | TEXT | |
| units_sold | INT | |
| revenue | REAL |
| Column | Type | Key |
|---|---|---|
| forecast_id | INT | PK |
| sku_id | INT | FK → dim_skus |
| location_id | INT | FK → dim_locations |
| version_id | INT | FK → dim_forecast_versions |
| forecast_period_date | TEXT | |
| forecast_generated_date | TEXT | |
| forecast_qty | INT |
| Column | Type | Key |
|---|---|---|
| sku_id | INT | PK |
| sku_code | TEXT | |
| sku_name | TEXT | |
| category | TEXT | |
| lifecycle | TEXT | |
| abc_class | TEXT | |
| xyz_class | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Bias is the signed average of forecast minus actual. Roll it up to category by joining the SKU dim.
Filter version 1.
AVG(forecast - actual).