©2012 microsoft corporation. all rights reserved
TRANSCRIPT
©2012 Microsoft Corporation. All rights reserved.
Excel Services in SharePoint 2013Chris GideonArchitectMicrosoft
©2012 Microsoft Corporation. All rights reserved.
Introduction to Excel ServicesWeb-based interactive reporting and sharing
Powerful analytics with the built in PowerPivot
SQL Server 2012 required
A platform for building business applications
©2012 Microsoft Corporation. All rights reserved.
Excel Services Architecture
Excel Web Access
Excel Web Services
JSOMREST API
Excel Proxy
User-Defined Functions
Excel Calculation Service
XLSX/b/m
SharePoint Content Database
External Data Sources
Web
Front End
Applicati
on Server
Backend
©2012 Microsoft Corporation. All rights reserved.
Data exploration improvements with additional commandsBetter integration with SQL Server Analyses Services data or PowerPivot models
Field list and field well support added to excel services for easier PivotChart and PivotTable control
Calculated measures and members supported in web rendering
Enhanced timeline controls for rendering
Application BI Servers support
Business Intelligence Center update
Touch and Device Support
New features for Excel Services in SP2013
©2012 Microsoft Corporation. All rights reserved.
Mobile devices support for BI – including excel Delivering great touch-based data exploration and visualization capabilities in a browser on iOS, Android and Microsoft platforms Excel Services 2013 PerformancePoint 2013 Reporting Service 2012
©2012 Microsoft Corporation. All rights reserved.
Excel Services Topology
SharePoint Excel Services
SQL ServerAnalyses Services
Office Web Apps
Admins or UI designer get to choose:• View workbooks using Excel Services on SP; or• View workbooks using Office Web Apps Server
(and potentially loose functionality)
WOPI
OLEDB/ODBC
©2012 Microsoft Corporation. All rights reserved.
Web Part
Web Service API
AuthenticatedJSOM/REST/APIs
Windows-auth basedExternal Data
Edit documents
New documents
Co-authoring
View
Un-AuthenticatedJSOM/REST
User DefinedFunctions
Connection stringUnattended account
External data*
Embedding
Excel Services vs. Office Web Apps Server
Office Web Applications
SharePoint 2013
©2012 Microsoft Corporation. All rights reserved.
Excel Services is all about BI, and you get it as part of SharePoint EnterpriseDashboards with web parts on SharePointExternal data connectivity and refresh abilityAdvanced BI functionality like PowerView integration
Excel Web App is part of the Office Web AppsBrowser based spreadsheet for viewing and editing Excel documents
If you have both at the same time, then you get both BI and editing of the excel files
Excel Services and Excel Web App
©2012 Microsoft Corporation. All rights reserved.
SQL Server Analysis Services for advanced analytics
SQL Server Analysis Services
SharePointExcel Services
©2012 Microsoft Corporation. All rights reserved.
Generates Excel table and chart views on-the-fly from an HTML table hosted on a web pageExport to Excel Web App or Excel file for further analyses
Associated to any html tableNot only in SharePoint, available cross platform
Excel Interactive View
©2012 Microsoft Corporation. All rights reserved.
Demo
Excel Interactive View with SharePoint
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.