Intro to PowerPivot and its Analysis Services Roots (Andrew Brust)

in SQL Server

Thursday, June 9, 2011, 6:00 PM to 8:30 PM

Download Presentation Material

  • Part I: Learn the basics of building and querying a PowerPivot model, and publishing it to SharePoint
  • Part II: Learn about VertiPaq, PowerPivot’s in-memory BI engine, how it works, and how it’s related to SQL Server Analysis Services
  • Part III: Explore how to query PowerPivot models from any Analysis Services client, how to open PowerPivot models in BIDS (the BI Developer Studio – i.e. the Analysis Services project designers in Visual Studio) and how to reverse engineer the differences and commonalities between PowerPivot and SSAS.
  • Part IV: Discuss PowerPivot and SSAS futures.

Andrew Brust is Founder and CEO of Blue Badge Insights, an analysis, strategy and advisory firm serving Microsoft customers and partners.  Brust also serves as CTO for Tallan, a Microsoft National Systems Integrator; is a Microsoft Regional Director and MVP; an advisor to the New York Technology Council; and co-author of “Programming Microsoft SQL Server 2008” (Microsoft Press, 2008). A frequent speaker at industry events, Brust is co-chair of the Visual Studio Live! family of conferences and a columnist for Visual Studio Magazine. Brust has been a participant in the Microsoft ecosystem for over almost 20  years, and has worked closely with both Microsoft’s Redmond-based corporate team and its field organization for much of the last 10. He is a member of the Microsoft Partner Advisory Council and several “insiders” groups that supply him with insight around important technologies out of Redmond.

Leave a Comment

Previous post:

Next post: