PowerPivot Deep Dive with Rob Collie (2/3)

41 minutes, 38 seconds


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

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/


Follow the discussion

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.