PowerPivot Deep Dive with Rob Collie (3/3)

52 minutes, 5 seconds

Download

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

=CALCULATE(<Aggregation>,<filter1>,<filter2>,…)

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

Tags:

Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation
    Unsubscribing
    Subscribing

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.