SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Archives: August 2011

SSIS - Inferred Member Insert in Fact Table Load

Recently while working on a different solution for loading inferred member solution in our fact table load I ran into this article on SQL Server Central article.  This article explains very well what an inferred member is.
This is a great article and I started using it…

Read more

0 comments, 2,912 reads

Posted in Devin Knight on 16 August 2011

PowerPivot – Commonly Used DAX Expressions

Today I will be presenting in a webinar, which by the way is recorded for later viewing, on Commonly used DAX Expressions.  You can register (or if you miss it live watch the recording) for this webinar here.  I thought it would be great if I could push out… Read more

0 comments, 1,651 reads

Posted in Devin Knight on 11 August 2011

PowerPivot – Creating KPIs

Probably one of the most anticipated additions to the latest version of PowerPivot is the ability to create KPIs. PowerPivot has made what was once a task that was done purely done by developers now something that anyone can do now.

KPIs (Key Performance Indicator) are an executive favorite that… Read more

0 comments, 2,787 reads

Posted in Devin Knight on 8 August 2011

PowerPivot – Perspectives

PowerPivot – Perspectives

Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split up your cube so users can find what they want faster.  A perspective is similar to a TSQL view because it will take a larger object (the cube)… Read more

0 comments, 4,341 reads

Posted in Devin Knight on 5 August 2011