Facebook Twitter LinkedIn YouTube E-mail
Home Posts tagged "Microsoft BI" (Page 2)
formats

Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 2

Share

This is Part Two, the final of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model. In the first part of this blog post series, which can be found at this link, I discussed the benefits of a Business (Bus)

(More)…

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

Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 1

Share

This is Part One of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model.  UPDATE: Part 2 is now published and can be viewed at this link. Have you ever spent several hours making a Business (Bus) Matrix for an

(More)…

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

SQL Saturday 332 Minnesota Follow Up and Links for Open Data & Microsoft BI Tools Presentation

Share

We had the opportunity to sponsor and participate in SQL Saturday 332 in Minneapolis this past weekend and attendance at the event was exceptional. The event was completely full with a long waiting list, so we thought a re-cap of my presentation on Open Data & Microsoft BI Tools would be helpful to those who were not

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
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

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