MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition

Forecasting using periodic cycles

Linear trend, covered in the recipe Forecasting using linear regression, is just an overview of how the business is going. The regression line serves us merely as an indicator of where we will be in the future if everything continues in the same way. What it doesn't tell us, at least not well enough, is what the individual values on that path will be. The values that method returns are too simplified, too imprecise.

Of course, there are other ways of forecasting the future values, such as by using polynomial curves or similar, which, generally speaking, will fit better to the shape of achieved business values and therefore represent future values more precisely. However, we won't make an example using them; we ...