Excel - PowerPivot and PowerView for Reporting & Analysis

Welcome back from the holidays!

I wish I could say I put all work behind me, but instead I spent some time working on a few projects I've had on the burner, including exploring how Power Pivot and Power View might affect our work with Jet Enterprise and 'formal' BI projects.

Through blogs and interactions with customers and partners, we're hearing murmurs questioning whether data warehouses can be replaced by Excel's Power BI family.  In this blog I demonstrate that since Power Pivot can recreate a lot of the functionality that Jet Enterprise's dimensional projects leverage, instead of fearing or demonizing the disruptive potential of Power Pivot, we can welcome it into our workflow.  This tool can empower business analysts to prototype the cube customizations they desire, as well as act as a stop gap for analysis and reporting while cube customizations are implemented.