Facebook Twitter LinkedIn YouTube E-mail RSS
Home Microsoft Archive for category "PowerPivot"
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

How to Master PowerPivot

Share

Time and time again, our customers ask us where they can find more resources and training on Microsoft’s PowerPivot. PowerPivot is an extremely powerful and dynamic tool used for data modeling and exploration that brings self-service BI to everyone through Excel 2013. One suggestion we give to our customers is to visit powerpivotpro.com and explore

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on How to Master PowerPivot  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 
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