Thanks for stopping by. Here are few examples of my work.
- md1.p_ssa_Rebuild
- A stored procedure used to build a dataset used in forecast accuracy analysis. For example:
- There is a record for each item and week for the last (lead-time)+26 weeks,
- Each record has: ItemId, date (Sundays), lead-time, actual and forecast for that week and the sum (rolling) of actual and forecast for the last x weeks (x=lead-time)
- md1.ssa_ItemStatistics
- A view that calculates a number of statistics for each population (ItemId). For example:
- There is a record for each item and week for the last 26 weeks,
- Each record has: ItemId, date (Sundays), lead-time, the sum (rolling) of actual and forecast, delta of actual-forecast, standard score, min, max, mean, median, standard deviation, skewness and kurtosis