Facebook Twitter LinkedIn YouTube E-mail RSS
Home Archive for category "Business Intelligence" (Page 4)
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

The Cobra Effect in BI: Part 3

Share

In my previous two posts I have tabled the concept of the Cobra Effect in BI and taken a closer look at Excel spread marts—the Cobras of BI, and the incentive EDW, aka the single version of the truth. This week, let’s walk through the journey of creating and rolling out this single version of

(More)…

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

The Cobra Effect of BI: Part 2

Share

Last week we started to look at the concept of the cobra effect in BI. This week I want to dive in further and explore exactly what the cobras are in the case of business intelligence. The Cobras of BI or the Excel spread mart: Within each organization, groups of analysts spend endless hours of

(More)…

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

The Cobra Effect in BI

Share

The cobra effect occurs when an attempted solution to a problem actually makes the problem worse. I came across this term in a Freakanomics podcast by Stephen J. Dubner and Steven D. Levitt. The term is used to illustrate the causes of incorrect stimulation in economy and politics. There is also a 2001 book with the

(More)…

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