1) How many weeks should be considered for testing any new change to a billing system in stores? Methodology to arrive at the weeks? 2) Explain ability of a model - Shapio package? 3) Intermediate SQL - moving 3 months average? Can be solved my sliding windows function.

Question

Accepted Answer

Testing duration for new changes in billing system, Shapio package model explanation, and SQL moving average calculation.

1) Consider at least 4 weeks for testing new changes in billing system in stores
2) Shapio package provides model interpretability by calculating the impact of each feature on the model's predictions
3) Use sliding windows function in SQL to calculate moving 3 months average
Example: SELECT date, value, AVG(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS moving_avg FROM table_name