Greg Beaumont's Data & Analytics Blog

Data, Analytics, AI, Business Intelligence posts and videos

Greg Beaumont is a technology professional in Minnesota working with data since B.C. (Before Cloud) and specializing in Microsoft tools.

Month: March 2013

Forecasting with an MDX Linear Regression in an SSAS OLAP Cube

March 28, 2013

This article was originally published to a blog which has been decommissioned. A few days ago I published an article detailing a method to create regression line calculations in an Analysis Services OLAP cube using MDX. It is the starting point for this article. My instructional video detailing the entire regression line and forecasting process…
Create a Regression Line in an SSAS OLAP Cube with the LinRegPoint MDX Function

March 26, 2013

This article was originally published to a blog which has been decommissioned. During a discussion about OLAP cubes for Business Intelligence data visualization and analysis, I was asked if regression lines could be added to cubes as calculations within Analysis Services. I had previously browsed the MSDN pages for the MDX functions LinRegPoint and LinRegSlope,…