Level: Introductory to Intermediate
Prerequisite: None
Andrew Brust
Senior Director, Market Strategy and Intelligence
Datameer
Andrew Brust is Senior Director, Market Strategy and Intelligence at Datameer and writes for ZDNet’s "Big on Data" blog. Andrew is co-author of Programming Microsoft SQL Server 2012 (Microsoft Press); has several Pluralsight courses on Big Data and NoSQL, serves as Microsoft Regional Director and is a Microsoft Data Platform MVP.
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.