COMUNIDAD SHAREPOINT DE COLOMBIA SharePoint Saturday Quito

Marzo 7, 2015 El poder del BI (Power View, PowerPivot y PowerMap)

Andrés Rojas MVP SharePoint Server @arojaspa [email protected]

arojaspa http://arojaspa.blogspot.com

Patrocinadores

Agenda Overview Excel Services Overview Performance Point Overview Visio Services Planeación de un Dashboard con Performance Point

Overview Excel Services

New features for Excel Services in SP15 Data exploration improvements with additional commands • Better 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

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 15 • PerformancePoint 15 • Reporting Service 2012

SQL Server Analysis Services for advanced analytics SQL Server Analysis Services SharePoint Excel Services animated

Excel Services vs. Office Web Apps Web Part SharePoint 15 Web Service API View Un-Authenticated JSOM/REST Authenticated JSOM/REST/APIs User Defined Functions Office Web Apps Edit documents New documents Windows-auth based External Data Connection string Unattended account External data* Embedding

Other Excel Services or Excel related functionalities Excel Forms • Simple forms for collecting entries which are stored in excel • Access Forms engine in back ground Excel Everywhere • “Inject Excel to any html table”

Overview PerformancePoint Services Context-driven dashboards across systems • Provides transparency and accountability • Interactive access using browser • Can be created/updated by power-users/professionals Bring together data from multiple data sources Visualization your data with charts & graphs Drill into your data with Decomposition Trees

Changes in SharePoint 15 Architecture and general model has remained the same as in previous version Key changes and new capabilities • Filter Enhancements and Filter Search • Cascading Filters* • PerformancePoint support on iPad • Support for Analysis Services Effective User • BI Center Update • Dashboard Migration

Filter Enhancements and Filter Search Filter Enhancements

Data connectivity - specific account with SSO animated

Analyses Services Effective User option animated

Dasboard Migration process SharePoint QA SharePoint Prod animated

Planning a Performance Point Dashboard Decide what the dashboard should containTipo de información Identify important factors for implementation Create data sources Create reports and scorecards Assemble the dashboard Preview the dashboard and make adjustments Deploy the dashboard 17 | 9/27/2014 | SQL Saturday #343 – Medellín, Colombia

Overview Visio Services • • • •

Visio Changes in SP15 Commenting in drawing supports • Users can add comments to a Visio Drawing (*.vsdx) collaboratively on the web via Visio Services in full page rendering mode.

• Comments are embedded to actual visio file – Available in client as well Data Connectivity • Refresh data from BCS External List, SQL Azure • Recalculate all shapes and shape sheet formulas based on underlying data • Optimized for windows touch devices New configuration option s for Maximum Cache Size • Health Analyzer rule to reflect the new cache size parameter

Credentials: Used by Visio client SQL access Used by Visio Services SQL access Used by Visio Services No SQL access Diagram Author needs direct access to data source for Visio client Secure Store Service maps Diagram Consumers to

Data Access Account

for Visio Services Secure Store Property Target Application ID Target Application Administrator Target Application Members Target Application Credentials Meaning Identifier referenced by Visio Services Typically farm administrator Diagram Consumers Data Access Account

Commenting from browser

Visio & SharePoint Designer new features • • • • • • • • • Save workflow as Visio 15 file from Designer side Open workflow in SharePoint Designer SharePoint Designer hosts Visio ActiveX control for full visual editing • New workflow template with support for Windows Workflow Foundation 4.0

Supports Stages, Steps and Loops

Support for custom actions in visual designer Visual parameterization in SharePoint Designer Can easily switch between declarative and visual design in SharePoint Designer Validation of diagram logic in Visio Validation of program logic in SharePoint Designer

New and Improved SharePoint Workflows

Patrocinadores Diamante

Patrocinadores Gold

Patrocinadores de Premio

Q&A

Recuerda Evaluar la sesión

Nombre de la Session

Gracias