Chris Gideon Architect Microsoft Introduction to Excel Services Webbased interactive reporting and sharing Powerful analytics with the built in PowerPivot SQL Server 2012 required A platform for building business applications ID: 701302
Download Presentation The PPT/PDF document "Excel Services in SharePoint 2013" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Excel Services in SharePoint 2013
Chris Gideon
Architect
MicrosoftSlide2
Introduction to Excel Services
Web-based interactive reporting and sharing
Powerful analytics with the built in
PowerPivot SQL Server 2012 required A platform for building business applicationsSlide3
Excel Services Architecture
Excel Web Access
Excel Web Services
JSOM
REST API
Excel Proxy
User-Defined Functions
Excel Calculation Service
XLSX/b/m
SharePoint Content Database
External Data
Sources
Web Front End
Application Server
BackendSlide4
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 controlCalculated measures and members supported in web renderingEnhanced timeline controls for renderingApplication BI Servers support
Business Intelligence Center update
Touch and Device Support
New features for Excel Services in SP2013Slide5
Mobile devices support for BI – including excel
Delivering great touch-based data exploration and visualization capabilities in a browser on
iOS
, Android and Microsoft platformsExcel Services 2013PerformancePoint 2013
Reporting Service 2012Slide6
Excel Services Topology
SharePoint
Excel Services
SQL Server
Analyses 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/ODBCSlide7
Web Part
Web Service API
Authenticated
JSOM/REST/APIs
Windows-
auth
based
External Data
Edit documents
New documents
Co-authoring
View
Un-AuthenticatedJSOM/RESTUser DefinedFunctionsConnection stringUnattended accountExternal data*EmbeddingExcel Services vs. Office Web Apps Server
Office Web Applications
SharePoint 2013Slide8
Excel Services is all about BI, and you get it as part of SharePoint Enterprise
Dashboards with web parts on SharePoint
External data connectivity and refresh ability
Advanced BI functionality like PowerView integrationExcel Web App is part of the Office Web Apps
Browser 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 AppSlide9
SQL Server Analysis Services for advanced analytics
SQL Server
Analysis Services
SharePoint
Excel ServicesSlide10
Generates Excel table and chart views on-the-fly from
an HTML table hosted on a web
page
Export to Excel Web App or Excel file for further analysesAssociated to any html tableNot only in SharePoint, available cross platform
Excel Interactive ViewSlide11
Demo
Excel Interactive View with SharePointSlide12
© 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.