SharePoint 2013 Business Intelligence

FECHA INICIO:
03/10/2016
FECHA FIN:
05/10/2016
HORA INICIO:
09:00 h
HORA FIN:
15:00 h
LUGAR:
Madrid
REFERENCIA:
MOC 55042
  • PERFIL

    Orientado a usuarios con perfil técnico que quieran desarrollar soluciones de Business Intelligence colaborativas con SharePoint 2013.

  • OBJETIVOS

    Enseñar a los usuarios cómo administrar y configurar SharePoint 2013 para Business Intelligence y cómo funcionan los distintos servicios de BI.

  • TEMARIO

    Module 1: Course Overview

    • Introduction
    • Course Materials
    • Facilities
    • Prerequisites
    • What We'll Be Discussing

    Module 2: The Business Intelligence Stack

    • Business Intelligence in Three Ways
    • SQL 2012 Business Intelligence
    • New 2013 SharePoint Business Intelligence Features
    • New 2013 PowerPivot in Excel Features

    Lab : The Business Intelligence Stack

     

    Module 3: SharePoint 2013 Business Intelligence Center

    • New 2013 SharePoint Central Administration
    • New 2013 Business Intelligence Center
    • Permissions and Roles
    • Included Document Library and List Apps

    Lab : SharePoint 2013 Business Intelligence Center

     

    Module 4: SharePoint 2013 Excel Services

    • New 2013 Excel Services Features
    • Core Components
    • Excel Web Access (EWA)
    • What Excel Web Access is Not
    • Differences in the Browser vs. Desktop
    • SharePoint Libraries to Store Workbooks
    • Power View Add-in for Excel
    • The Save and Share Process
    • Excel Web App
    • Best Practices

    Lab : SharePoint 2013 Excel Services

     

    Module 5: SharePoint 2013 PerformancePoint 2013

    • New 2013 Overview of PerformancePoint Services
    • Dashboard Designer
    • Data Sources
    • Indicators
    • KPIs
    • Visual Reports
    • Filters
    • Scorecards
    • Dashboards

    Lab : SharePoint 2013 PerformancePoint 2013

     

    Module 6: SharePoint 2013 Visio Services

    • New 2013 Visio Services Features
    • Visio Graphics Service
    • Visio Drawings in the Browser
    • Visio Web Access Web Part
    • Visio Drawings with Data Connections

    Lab : SharePoint 2013 Visio Services

     

    Module 7: Power Pivot

    • New 2013 Power Pivot Features
    • Power Pivot and Excel
    • Power Pivot and SharePoint
    • Enterprise Business Intelligence and Power Pivot
    • Importing Data
    • Enriching Data
    • SharePoint Sharing

    Lab : Power Pivot

     

    Module 8: SharePoint 2013 Business Connectivity Services

    • New 2013 Business Connectivity Service Features
    • What is Business Connectivity Services?
    • BCS Terminology
    • BCS Security
    • Using SharePoint Designer 2013 with BCS
    • Surfacing the BCS Data

    Lab : SharePoint 2013 Business Connectivity Services

     

    Module 9: Dashboards

    • Dashboard Migration
    • Three Types of Dashboards
    • Successful Dashboards
    • Tables or Graphs
    • Types of Graphs
    • Choosing a Chart Type
    • Key Performance Indicators
    • Pitfalls In Dashboard Design
    • Microsoft Report Builder 3.0
    • Plan Your Reports
    • Datasets
    • New 2013 SharePoint Designer Features
    • SharePoint Web Apps

    Lab : Dashboards