基于月度数据的预测

下面的逻辑为您提供当前时间段内的支票数量、过期百分比、接近过期百分比和所有其他支票计数百分比。下一步是创建一个查询,该查询将执行3个月或12个月(或者您希望使用多少个月来获取预测)。然后,对检查总数进行趋势分析,并对每个子类别的百分比进行趋势分析。你可以用它来预测未来的金额。

SELECT
    Count(*) AS Number of Checks,
    (SUM(CASE WHEN s.ageofcheck >= 90 THEN 1 ELSE 0 END))/Count(*) AS Number of Checks AS Percent Overdue Checks,
    (SUM(CASE WHEN s.ageofcheck >= 60 AND s.ageofcheck < 90 THEN 1 ELSE 0 END))/Count(*) AS Number of Checks AS Percent Near Overdue Checks,
    (SUM(CASE WHEN s.ageofcheck < 60 THEN 1 ELSE 0 END))/Count(*) AS Number of Checks AS Percent All Other Checks   
FROM
    (
    SELECT
        c.checknumber,
        DATEDIFF(dd,GETDATE(),c.checkdate) AS ageofcheck
    FROM
        checks_table AS c
    ) AS s