Microsoft End to End Business Intelligence Boot Camp

FECHA INICIO:
26/09/2016
FECHA FIN:
30/09/2016
HORA INICIO:
09:00 h
HORA FIN:
15:00 h
LUGAR:
Barcelona
REFERENCIA:
MOC 55045
  • PERFIL

    Orientado a usuarios con perfil técnico que quieran desarrollar soluciones de Business Intelligence con la plataforma Microsoft.

  • OBJETIVOS

    Enseñar a los usuarios cómo construir un almacén de datos y modelos analíticos con SQL Server 2012 y cómo explotar y visualizar la información utilizando los distintos servicios de Business Intelligence de Excel y SharePoint 2013.

  • 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: SQL Server Integration Services (SSIS) 2012

    • What’s New?
    • Overview of Extract, Transform, and Load (ETL)
    • SSIS Tools
    • Change Data Capture
    • SQL Server Integration Services Scripting
    • Variables, Parameters, and Expressions
    • Package Deployment

    Lab : SQL Server Integration Services (SSIS) 2012

     Module 4: SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)

    • The Data Warehouse/Data Mart
    • The Tools
    • Key Concepts
    • Data Sources
    • Data Views
    • Cubes
    • Data Profiler
    • Proactive Cache
    • Wizards

    Lab : SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)

     Module 5: Microsoft Multidimensional Expressions

    • Concepts in Multidimensional Space
    • Basic MDX Statements
    • SQL Server Management Studio MDX Query Editor
    • Navigating Hierarchies
    • Working with Time
    • Microsoft Multidimensional Expressions

    Lab : Microsoft Multidimensional Expressions

     Module 6: SQL 2012 Business Intelligence Semantic Model (Tabular Mode)

    • The Tabular Model
    • Data Analytic Expressions (DAX)
    • The Editor
    • Data Connections
    • Creating a Tabular Project
    • Relationships
    • Measures and Calculated Columns
    • Hierarchies
    • Perspectives
    • KPIs
    • Partitions
    • Processing
    • Deployment

    Lab : SQL 2012 Business Intelligence Semantic Model (Tabular Mode)

     Module 7: SQL Server 2012 Reporting Services

    • Report Lifecycles
    • Installation Modes
    • Report Creation Tools
    • Data Sources
    • Datasets
    • Basic Reports
    • Graphics
    • Maps
    • Report Parts

    Lab : SQL Server 2012 Reporting Services

     Module 8: Master Data Services

    • What is Master Data Management?
    • System Roles
    • Master Data vs. Transactional Data
    • Master Data Services ETL
    • Master Data Services Key Concepts

    Lab : Master Data Services

     Module 9: Data Mining/Predictive Analytics

    • Definitions for Our Purpose
    • Problems Addressed
    • Business Analytics
    • CRISP-DM
    • Key Concepts
    • Microsoft Data Mining Process
    • Data Mining Tasks
    • Microsoft Algorithms
    • Matching the Tasks to the Algorithm
    • Data Mining Add-in for Excel

    Lab : Data Mining/Predictive Analytics

     Module 10: 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 11: 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 12: 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 13: SharePoint 2013 Visio Services

    • New 2013 Visio Services Features
    • Visio Graphics Service
    • Visio Drawings in the Browser
    • Visio Web Access Web Part
    • SharePoint 2013 Visio Services

    Lab : SharePoint 2013 Visio Services

     Module 14: PowerPivot

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

    Lab : PowerPivot

     Module 15: SharePoint 2013 Business Connectivity Services

    • 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 16: 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