SQLCAT: PowerPivot Best Practices and Enterprise Case Studies
This session provides a preview to PowerPivot best practices developed via SQLCAT’s interactions with customers as well as Rob Collie’s six months of hands-on experience using the product to solve real-world problems. This session is highly technical: Dave Wickert provides a detailed explanation of PowerPivot components and architecture, and gives an in-depth look at server-side configuration options and best practices. Rob provides a similar view of client-side practices, both from the SQLCAT perspective as well as from PivotStream LLC’s production usage of PowerPivot. Additionally, Rob describes some of the considerations and lessons learned from deploying one of the world’s first PowerPivot “software as a service” platforms. Throughout this session, the themes of High Availability, Scalability, and Robustness are emphasized.