Building Visually Compelling BI Experiences with PowerPivot #spc11 #sharepoint @kieferconsult

Presented by Peter Myers

• PowerPivot Model Development
• SQL server PowerPivot for SharePoint Add-in
• PowerPivot Window
• Select the view/table from the Table Import Wizard
• Creating lookup relationships in Excel for imported tables
• Pivot Table config
• Hide columns from Pivot Tables
• Rename columns in Pivot Tables
• Enriching with DAX calculations
• 1/10th the size of importing data into workbook
• Free-form Reports
• functions
• CUBEMEMBER
• CUBEVALUE
• CUBESET
• CUBESETCOUNT
• CUBERANKEDMEMBER
• native excel features
• conditional formatting
• sparklines
• slicers
• charts
• Fixed row/column configurations
• use top x functions (ex: top 5, last 5 years, etc.)
• PowerPivot Field List
• Search for tables and columns
• Define slicers
• etc.
• PowerPivot plugin for SharePoint
• PowerPivot Gallery is a library template
• Powerpivot.com