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 =CALCULATE(<Aggregation>,<filter1>,<filter2>,…) Football Demo #2:  Cube Formulas Rob Collie’s bio (from "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: