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

Integrating Social Networking Sites with a #SharePoint Internet Site #spc11 @kieferconsult

Presented By Microsoft
Brian Rodriguez, Ryan Sockalosky

• Facebook OpenGraph Protocol
• Tag your page with meta tags to generate image, summary, etc.
• Twitter
• Javascript code
• AddThis
• Like box with most social networking plugins
• Demo using the Facebook api in a Web Part
• Use the additional page header content zone to add meta tags, pulling from the page properties
• OAuth via secure store service
• Demo of developing a workflow to publish a post to twitter via an oauth token

Performance Testing and Optimizing SharePoint Websites #spc11 @kieferconsult

Brian Rodriguez and Ryan Sockalosky
Microsoft Presentation

• Plan for all consumers
• Browsers
• Office apps
• Search and Services
• 3 hardest server calls
• SQL
• Authentication
• Blob
• Agents
• Use a 75/25% Read/Write ratio
• CPU around 50%
• Data-driven test within Visual Studio team test
• Use a web test project
• Data: Add users, sample docs, search terms, and configuration elements
• Watch for timer jobs
• Verify load balancing
• sample rate: 5 sec for an hour, 15 seconds for 4 hours, 60 seconds for a 24 hour+
• Use Performance Monitor
• Run load test and make 1 change at a time while monitoring performance
• Optimize
• Blob cache
• Blob cache fill ration should be < 90%
• web.config configuration per WFE
• SQL
• Disk I/O wait time
• asp.net wait time
• latency
• CPU
• SQL IOPS
• Fix with TempDBs storage device upgrades
• See slide deck for other optimization techniques
• Output Cache
• Don't output cache search results
• Configure at: Site Collection, Site, or Page Layout
• Object Cache
• Memory
• Use for cross list queries

If you don't know how much it's going to cost, it'll cost a lot.
If you aren't testing it, your measurements are wrong. If you aren't measuring, you can't make it faster.

What's new in SSRS Denali #spc11 @kieferconsult

Carolyn Chau
Presented by Microsoft

• Recent upgrades to SSRS in 2008 SP2
• Shared DataSets
• Report Parts
• Visualizations
• Ajax Report viewer
• Customer DCRs
• Cuts
• Adhoc reporting
• Alerting
• Updates to SQL Server
• AlwaysOn
• Easily configurable readable clustered mirrored environments
• Denali Reporting and Alerting features
• SSRS will be include a SharePoint Service for integrated mode
• BIDS will be in Dev10
• The new SharePoint integrated mode
• One administration location: SharePoint Service config
• WCF and Claims support
• PowerShell Cmdlets
• ULS logging
• Scalable and load balanced
• Alerting
• SharePoint mode only
• One report per alert and conditions on data sources within report
• Only work against BIDS created (operational) reports
• Crescent (ad-hoc reporting)
• SharePoint mode only
• No alerting
• Silverlight 5 required
• Supports Chinese characters
• Supports Printing
• Integrated with PowerPivot
• RDLX files
• includes an rdl file plus others
• IT Experience
• Install RS add-in on SP WFEs
• Create and configure Central admin Service Application
• PowerShell Enabled

Excel and PerformancePoint Services Administration #spc11 @kieferconsult

Session: Deep Dive: Excel Services and PerformancePoint Services Administration and Troubleshooting

Left session.  Same info as TechNet

Mobile: Office 2010 EndPoints #SPC11 @KieferConsult

Session: iPads, Android tablets, smart phones, and Windows devices? Managing Office 2010 Endpoints in an Interoperable and Multi-device world
Microsoft Presentation
Jeremy Chapman
Sr. Product Mgr

• Need to secure remote access
• Does mobile device have BitLocker?
• Is PIN enabled?
• Is there device encryption?
• Feature/Managability Matrix
• Low/Low - Windows Phone 7
• High/Low - Mac Office 2011
• High/High - Office Pro Plus 2010
• Med/High - Remotely Hosted Office Pro Plus 2010
• Mobile
• Low/High - Office Web Apps
• Mobile
• Mentioned iPhone OneNote app
• Main Workload: Exchange ActiveSync
• Citrix
• Hardening the Attack Surface
• Exchange ActiveSync settings
• Mobile Device Management Server for iOS
• Office 2010 client configuration
• MSP file
• Install-time config
• Use Microsoft Office Customization Tool
• Config.xml
• Overrides MSP
• Install-time config
• Group Policy
• Dynamic
• Reduce the Attack Surface
• Mac Office 2011
• IRM
• Security preferences
• Limited policy control
• IRM in Exchange
• UAG
• Policies
• MacOS
• IIS Block rules
• Ipad UserAgent string
• Using Remote Desktop Services or Citrix on a mobile device
• Windows Color and Appearance settings to make things larger
• Ribbon configuration

MS Vision and Strategy for BI #SPC11

SharePoint Conference 2010
Presented by Microsoft
Steve Tullis - Principal Group Program Manager
Kamal Hathi - General Manager

• Microsoft Business Intelligence Market Position
• Most Recognized (Gartner)
• Strongest Growth
• Most Widely Deployed
• MS BI
• Familiar
• Collaborative
• Complete
• On Your Terms
• Mediterranean Shipping Company
• 22 TB data
• Mash-up with 33m rows internal data
• Twitter Analytics for Excel
• Via PowerPivot for Excel
• Demonstrating real-time analytics
•  PowerPivot Management Dashboard
• SSRS (Reporting Services)
• SQL Server (Danali) dynamic charting demos
• SSRS - Project Crescent

SharePoint Conference 2011

The Kiefer Consulting team and I will be attending SPC 2011 in Anaheim. 
Be sure to get your SharePoint Overview posters at the Axceler booth!
Connect with me here, FaceBook, Twitter (@robertrfreeman), or LinkedIn.

Cool Stuff

• Pick up your SharePoint Overview posters at the Axceler booth

Conference Links

• Website
• Facebook Page
• Twitter #SPC11

Kiefer Links

• Website
• Facebook Page
• Twitter @KieferConsult

Sessions

• Monday
• 8:30 am: Keynote - Jared Spataro, Jeff Teper, Kurt Delbene
• 11:00 am: MS Vision and Strategy for the Future of Business Intelligence
• Lunch - Steve Tullis, Kamal Hathi
• 2:00 pm: Mobile: Managing Office 2010 endpoints in an Interoperable and multi-device world - Jeremy Chapman
• 3:45 pm: SharePoint Administration Part 2 - Todd Klindt and Shane Young
• Tuesday
• 9:00 am: Claims Authentication Configuration
• 10:30 am: What's new in SSRS Denali - Carolyn Chau
• 3:15 pm: Solving Agile and PMO Problems by Integrating Project server 2010 with Team Foundation Server 2010 - Christophe Fiessinger
• TFS & PS Integration Feature Pack
• 5:00 pm: What's new for SQL Server "Denali" Analysis Services and PowerPivot v2
• Wednesday
• 10:30 am: Performance Testing and Optimizing SharePoint Websites
• 1:45 pm: Integrating Social Newtorking Sites with a SharePoint Internet Site - Brian Rodriguez, Ryan Sockalosky
• 3:15 pm: Building Visually Compelling BI Experiences with PowerPivot
• Thursday
• 9:00 am: Access Services - Everything You Wanted to know - Greg Lindhorst
• 10:30 am: The End to End Guide to Upgrading Custom Code from 2007 to 2010 - Rebecca Isserman
• 12:00 am: Packaging SharePoint Branding Elements for Deployment - Christina Wheeler
• DONE!!!!  See you in Vegas for SharePoint Conference 2012!!!

Events

• Monday: HiSoftware Cocktail Party, Idera, Yammer, MS Party, Club SPC, AvePoint RED party at the UltraLounge
• Tuesday: Disneyland
• Wednesday: