Transcript SharePoint 15 - IT Pro - Excel Services

©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
Name
Title
Company
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
Introduction to Excel Services
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
Excel Services Architecture
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
New features for Excel Services in SP15
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
Mobile devices support for BI – including excel
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
Excel 15 Topology (On-Premise)
SQL Server
Analysis Services
SharePoint Farm
Excel Services
Admins get to choose:
Office Web Apps 6
Farm
• View workbooks using Excel Services on SP; or
• View workbooks using Office Web Apps Server (and
potentially loose functionality)
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
animated
SQL Server Analysis Services for advanced analytics
SQL Server
SharePoint
Excel Services
Analysis Services
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
animated
Excel Services vs. Office Web Apps
Web Part
SharePoint
15
Web Service API
Authenticated
JSOM/REST/APIs
Windows-auth based
External Data
View
Office Web
Apps
Un-Authenticated
JSOM/REST
User Defined
Functions
Connection string
Unattended account
External data*
Embedding
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
Edit documents
New documents
Other Excel Services or Excel related functionalities
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.
©2012 Microsoft Corporation. All rights reserved. Content based on SharePoint 15 Technical Preview and published July 2012.