Facebook Twitter LinkedIn YouTube E-mail
Home Microsoft Archive for category "SQL Server 2012" (Page 3)
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

Proud Gold Sponsor of TechFuse 2013

Share

GNet Group is a proud gold sponsor of TechFuse tomorrow, Thursday, March 21, at the Minneapolis Convention Center. There will be several informative and innovative sessions for IT professionals, including two sessions presented by GNet Group. Paul Doyle’s presentation is, “Real Time Analytics with Power View and SSAS Tabular in Direct Query Mode” in the SQL/Business

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Proud Gold Sponsor of TechFuse 2013  comments 
formats

Starting Your Journey with SQL Server 2012 Data Quality Services (DQS)

Share

Data Quality Services (DQS) Introduction Data Quality Services (DQS) is a native component in SQL Server 2012. The data-quality solution provided by DQS enables a data steward or IT professional to maintain the quality of their data and ensure that the data is suited for its business usage. DQS is a knowledge-driven solution that provides

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Starting Your Journey with SQL Server 2012 Data Quality Services (DQS)  comments 
formats

SharePoint, SQL and Office together – Part 1

Share

With the recent releases of software products from Microsoft, there have been many questions about compatibility and deployment for SQL Server, SharePoint Server and the Microsoft Office suite. The questions of particular interest are whether a particular version of SQL Server will work with a particular version of SharePoint Server, and then will Office work

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on SharePoint, SQL and Office together – Part 1  comments