Ginneblog

Peter Myers of SolidQ gave a great overview of SQL Server PowerPivot to the Bay Area Microsoft Business Intelligence User Group.  The timing was good because we haven’t had an in depth discussion of PowerPivot since the  group launched in April of 2010 in conjunction with the SQL Server 2008 R2 launch events.

About 20% of the attendees had used PowerPivot so far.  Peter gave a good overview, and then walked us through an example app, step by step, using a variety of data sources, including SQL Server and Excel.  He’s a great speaker (and very fast typist!), and we learned a lot.

The timing of this meeting was ideal for me.  I had just met that afternoon with a client about how they pull data from spreadsheets, line of business applications, and other sources. Their process is tedious, labor intensive, prone to error, and needs to be repeated weekly.  I could clearly see how we could solve their problems with PowerPivot and easily distribute the information across their global organization via Access Services and their SharePoint 2010 portal.  Thanks again for a great talk, Peter!

Popularity: unranked [?]

 Send to Twitter