Facebook Twitter LinkedIn YouTube E-mail
Home Microsoft Archive for category "Excel" (Page 2)
formats

Video: Forecasting using Regression Analysis in Microsoft OLAP Cubes

Share

A few weeks ago I published a couple of articles that walk through the process of creating a linear regression line using MDX in a Microsoft OLAP cube.  The articles can be found at the links below: Create a Regression Line in an SSAS OLAP Cube with the LinRegPoint MDX Function Forecasting with an MDX

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Video: Forecasting using Regression Analysis in Microsoft OLAP Cubes  comments 
formats

Forecasting with an MDX Linear Regression in an SSAS OLAP Cube

Share

A few days ago I published an article detailing a method to create regression line calculations in an Analysis Services OLAP cube using MDX.  The article can be found by clicking here.  It is the starting point for this article.  My instructional video detailing the entire regression line and forecasting process can also be found

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Create a Regression Line in an SSAS OLAP Cube with the LinRegPoint MDX Function

Share

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, but since I had never used them I replied “You should be

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments 
formats

Using Data Quality Services to Cleanse Source Data in Integration Services

Share

So far we’ve seen various methods of cleansing source data using Data Quality Services. One of the main applications of DQS is in SQL Server Integration Services. This is where source data can be cleansed using the knowledge bases maintained in the DQS client by launching the DQS cleansing transform available in Integration Services. This blog gives

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Using Data Quality Services to Cleanse Source Data in Integration Services  comments 
formats

Healthcare BI Summit Presentation Links

Share

This post is a follow-up to today’s presentation at the Healthcare BI Summit in Minnesota.  The following links provide additional details and reference materials for both the demonstrations and methodologies discussed during the presentation, and for the GNet Group SightN2 for Healthcare: GNet Group Links and References GNet Group’s Agile BI On-Demand Webinar Video Preview

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Healthcare BI Summit Presentation Links  comments