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

Introduction to a SQL Server 2012 “ColumnStore” Index (Part II)

Share

Overview In Part I, I introduced the new index structure in a SQL Server 2012 “ColumnStore” index, examined the storage mechanism, and illustrated how this index helped us to boost the query performance in a data warehouse. (http://blog.gnetgroup.com/bi/2012/10/22/introduction-to-sql-server-2012-columnstore-index-part-i/)  Today, some related topics will be covered, including considerations in loading data into the “ColumnStore” index-enabled table,

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Introduction to a SQL Server 2012 “ColumnStore” Index (Part II)  comments 
formats

PowerPivot Dashbords with DOE Fukushima Incident Radiological Air Sample Data

Share

Welcome to the third installment of a series demonstrating the use of PowerPivot with Fukushima Incident Radiological Air Sample Data from the US Department of Energy.  Following is a recap of the installments in this series: Design of the data model (click here to read) Development in PowerPivot for a dashboard (click here to read) Deployment

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on PowerPivot Dashbords with DOE Fukushima Incident Radiological Air Sample Data  comments 
formats

Development in PowerPivot with DOE Fukushima Incident Radiological Air Sample Data

Share

Let’s move forward with development in PowerPivot for Fukushima Incident Radiological Air Sample Data.  This is the second post in a series: Design of the data model (click here to read) Development in PowerPivot for a dashboard (this post) Deployment of the data to a dashboard A start-to-finish video The purpose of this series is

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Development in PowerPivot with DOE Fukushima Incident Radiological Air Sample Data  comments