PowerPivot Deep Dive with Rob Collie (3/3)

52 minutes, 5 seconds


Right click “Save as…”

  • WMV (WMV Video)
  • MP3 (Audio only)
  • Low Quality MP4 (approx. 500-800kbps)
  • Mid Quality WMV (Lo-band, Mobile)

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

Part 3:

The Great Football Project

Real Project! (2006)
- Professional BI consultant

  • $50k, 3 months
  • Top-notch SSIS/SSAS pro

- Professional data!

  • $100k license to STATS Inc.
  • "Professional" only meant "Expensive"

Football Demo #1:  Measures

The CALCULATE() Function

  • Your new best friend
  • Like SUMIF(), modernized


Football Demo #2:  Cube Formulas

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


Follow the discussion

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.