Facebook Twitter LinkedIn YouTube E-mail RSS
Home Archive for category "Project Management"
formats

Managing Deliverable Expectations for Business Intelligence Project Success

Share

Business Intelligence (BI) projects are usually intended to meet a hybrid of different needs, frequently including standardized reports and dashboards, self-service reporting, and data discovery tools. Quite often, unexpected relationships and architectural challenges are found in data during the course of a project. Experienced BI teams are not strangers to mid-project discoveries such as many-to-many

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
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

BI Development: Working with Source Control

Share

Source control systems, such as Team Foundation Server (TFS), provide an extensive level of flexibility for development. Occasionally a developer can get lost in that flexibility, and the results can be painful. When the team grows beyond one or a few developers, a misstep in the source management process can result in challenges that can take

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

PowerPivot as a Documentation Browsing Tool Using CMS EHR Data

Share

PowerPivot is a versatile tool that can be used for many purposes.  Mash-up data from different sources, rapidly create BI dashboards, or use PowerPivot as a data modeling tool for development of an Enterprise Data Warehouse.  This post will focus on another use that can be useful for PowerPivot, a tool for optimizing the browsing

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments