PowerPivot Deep Dive with Rob Collie (2/3)

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 2:

Temp Mashup Demo (Continued from part 1)

• Loading Data
• Simple Pivot
• Mashup with Internet data
• Calc columns and relationships
• DAX Measures

DAX Measure Golden Rules

- Home Table = Fact Table

• Wherever the column to be aggregated lives

- No naked columns!

• Sum([Quantity]), never just [Quantity]
• Measures themselves are also ok

- Calculations happen against the TABLES

• Ex: Sum of a column in a PowerPivot table
• NOT a sum of PivotTable cells
• NOT a navigation of dimensional space

- Two Phases:  Filter, then Aggregate
- During Filter, think “Cell-by-Cell”
- Filters flow from One to Many, NEVER vice versa

Movie Explaining the Golden Rules

• http://bit.ly/ambRrv 
• http://bit.ly/bv7tBo

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/