Code Samples

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