Download this episode
Presented at the Swedish SQL Server User Group meeting January 27th 2010 in Stockholm.
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
Available formats for this video:
Actual format may change based on video formats available and browser capability.