Facebook Twitter LinkedIn YouTube E-mail
Home Posts tagged "MN"
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

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

Dynamic MDX for when the Last Day of Data isn’t Always “Day-1”

Share

When building a report or a dashboard, have you ever encountered a situation where the last day of data in a cube isn’t a consistent distance from the current day?  For example, what if “Yesterday” is sometimes “Two Days Ago”?  When building a KPI that displays the last day of data for a scorecard on

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Dynamic MDX for when the Last Day of Data isn’t Always “Day-1”  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