O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Forecasting using the linear regression

This recipe illustrates the method of estimating the future values based on the linear trend. The linear trend is calculated using the least-square distance, a statistical method of determining the line that fits the best through the set of values in the chart, as displayed on the image below:

Forecasting using the linear regression

There are two characteristics that describe the trend line: the slope and the intercept. They are the necessary ingredients in the regression line equation: y = a ∙ x + b. The "a" in the equation is the slope, growth rate or the gradient. When positive, the line progresses with values with every increase of the "x" in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required