PowerPivot Deep Dive with Rob Collie (3/3)
- Posted: Feb 16, 2010 at 4:16 AM
- 7,684 Views
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
- WMV (WMV Video)
- MP3 (Audio only)
- MP4 (iPod, Zune HD)
- 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
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.