/
Excel  Services  in SharePoint 2013 Excel  Services  in SharePoint 2013

Excel Services in SharePoint 2013 - PowerPoint Presentation

tatiana-dople
tatiana-dople . @tatiana-dople
Follow
353 views
Uploaded On 2018-10-29

Excel Services in SharePoint 2013 - PPT Presentation

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

services excel sharepoint web excel services web sharepoint microsoft server data view sql office apps part based support app

Share:

Link:

Embed:

Download Presentation from below link

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.


Presentation Transcript

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.