SQL Server for the Developer

LTH13 Excel, Power BI and You: An Analytics Superhub


9:30am - 10:45am

Level: Intermediate

Andrew Brust

Senior Director, Market Strategy and Intelligence


With Microsoft's announcement of its "Power BI" self-service cloud Business Intelligence offering, Excel steps into the BI mainstream. The combination of the Excel 2013 Data Model, Power Pivot, Power View, Power Query (formerly "Data Explorer") and Power Map (formerly "GeoFlow") means the ability to do serious, sophisticated analytics in Excel is here, right now. In this session, we'll look at the analytics capabilities in the core Excel product and the aforementioned add-ins, as well as investigate how to use these tools together. We'll also see how to extend these capabilities into Office 365 and the Windows 8 modern app environment with Power BI.

You will learn:

  • About the Excel Data Model and the BI Semantic Model
  • The four Excel analytics add-ins: Power Pivot, Power View, Power Query and Power Map
  • Publishing your Excel analytics to SharePoint and Office 365
  • Integrating Excel analytics with Big Data technology from Microsoft and other vendors