SQL Server

TH04 Excel, Power BI and You: An Analytics Superhub

05/08/2014

8:00am - 9:15am

Level: Intermediate

Andrew Brust

Senior Director, Market Strategy and Intelligence

Datameer

In this session, you will look at the analytics capabilities in the core Excel product and the combination of Excel 2013 Data Model, Power Pivot, Power View, Power Query and Power Map and learn how to use them together.

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