PowerPivot Deep Dive with Rob Collie (1/3)

Sign in to queue

Description

Presented at the Swedish SQL Server User Group meeting January 27th 2010 in Stockholm.

Part 1:

Why PowerPivot?

- Money
- Biz logic bottleneck

  • Time
  • Cost
  • Lack of agility

- Embrace and improve Excel

  • Manage and assist, not fight

- Supplement centralized BI

Temp Mashup Demo

  • Loading Data
  • Simple Pivot
  • Mashup with Internet data
  • Calc columns and relationships
  • DAX Measures

Rob Collie’s bio (from http://powerpivotpro.com): "Excel geek, Business Intelligence professional, all-around data enthusiast, and one of the founding engineers behind PowerPivot, Microsoft’s new self-service BI offering."

Swedish SQL Server User Group: http://www.sqlug.se

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents