Level: Introductory to Intermediate
Andrew Brust
Senior Director, Market Strategy and Intelligence
Datameer
In the realm of IT, the use of Excel as a data analysis tool is a near certainty. The downside is that data modeling, collaboration and manageability in Excel, historically, has been lacking. That ends now. PowerPivot, a feature of SQL Server 2008 R2, provides Excel with a powerful and lightning fast BI engine. Excel Services, a SharePoint Enterprise feature, allows spreadsheets to be secured and shared on the server, and used in the browser. Put the two together and you’ve got self-service BI power for business users, along with manageability and security for IT. See how all this comes together in Microsoft BI expert Andrew Brust’s comprehensive session.