SharePoint 2010 Business Intelligence Training

Microsoft SharePoint 2010 Training

Zielgruppe SharePoint 2010 Business Intelligence Training: Business Intelligence Architects and Consultants, Sr Business Analysts, anyone responsible for implementing BI with SharePoint.

Seminarziele This 5-day instructor-led course explores how to use SharePoint as your platform for Business Intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point and PowerPivot to implement your BI Strategies and enable your decision makers to see data in new and dynamic ways! This course will take you down a path of building a BI environment from scratch to full interactive dashboards using the Microsoft BI Stack.
After completing this course, students will be able to explore the new Business Intelligence Center, Analysis Services, Excel Services, Business Connectivity Services, Visio Services, Access Services, Power Pivot, Performance Point and Bing Maps.

Vorkenntnisse Before attending this course, students must have an understanding of SharePoint 2010 User Interface, database reporting concepts and familiarity with Data Marts and Data Warehouses.

Schulungsinhalt Module 1: Overview

Module 2: Business Intelligence

Lessons
  Business Intelligence

Lab : Business Intelligence Worksheet
  Answer Business Intelligence Questions

Module 3: Business Intelligence Center

Lessons
  Business Intelligence Center

Lab : Business Intelligence Center
  Explore SharePoint Business Intelligence Center
  Explore Dashboard Designer

Module 4: Data Mart and Data Warehouses

Lessons
  Understanding Data and Data Formats
  Building Data Marts and Data Warehouses

Lab : Data and Data Formats
  Explore Data Formats

Lab : Build A Data Warehouse
  Create a Simple Data Warehouse

Lab : Extract and Load
  Explore the Extract stage

Lab : Transform and Load
  Explore Transform and Load stages
  Realize the importance of primary/unique keys

Lab : Granularity
  Create Data Warehouse Granularity Levels

Lab : Build A Data Mart
  Create a Data Mart

Lab : SQL Server to SharePoint Lists
  Populate a SharePoint List with SQL Server data

After completing this module, students will be able to:
  Differentiate between multiple data formats
  Understand differences between data warehouse and data marts
  Be able to describe what happens in an Extract, Transform and Load (ETL) process

Module 5: Business Connectivity Services

Lessons
  Business Connectivity Services

Lab : BCS Basics
  Explore External Content Types
  Create a new External Content Type
  Create an External List

Lab : BCS With Data Warehouse
  Create an Large External List using ECTs
  Using Filters and External lists
  Creating and Configuring Entity Profile Pages

Lab : Office and BCS for BI
  Explore Office and BCS Integration

After completing this module, students will be able to:
  Understand how BCS works
  How to build new BCS applications
  How to Upgrade your older BDC applications

Module 6: Analysis Services

Lessons
  Analysis Services

Lab : Analysis Services
  Create Dimension and Fact tables with SSIS

Lab : Building An Analysis Services Database
  Create a Analysis Services Database
  Create a Cube
  Create Dimensions
  Create Fact Tables
  Create a KPI

After completing this module, students will be able to:
  Describe OLAP terms
  Understand how to navigate Analysis Services
  How to build a simple cube
  How to write simple MDX queries
  How to use data mining models

Module 7: Filter Web Parts

Lessons
  Filter Web Parts

Lab : Filter Web Parts
  Use each of the Filter Web Parts

Lab : UserProfiles and Filters
  Integrate User Profiles with Filters and Reports

After completing this module, students will be able to:
  Describe what Filter Web Parts are
  Work with Filter Web Parts
  Understand how to integrate Filter Web Parts into other BI technologies

Module 8: Excel Services

Lessons
  Excel Services

Lab : Create An Excel Report
  Create An Excel Report

Lab : Excel Services
  Learn to use Excel Services
  Create/Publish to Excel Services
  Configure Excel Services
  Shared Data Connections

Lab : MDX
  Explore Excel 2010 MDX features
  Create a Slicer
  Create an MDX Set

Lab : Sparklines
  Use Excel 2010 Sparklines

Lab : Filters and Excel Services
  Explore Filter Web Parts and Excel Services

Lab : REST and Web Services
  Explore REST features of Excel ServicesExplore the Excel Services Web Service

Module 9: PowerPivot

Lessons
  PowerPivot For SharePoint
  PowerPivot For Excel

Lab : Install Power Pivot
  Install PowerPivot for Excel
  Install PowerPivot for SharePoint 2010
  Configure PowerPivot for SharePoint

Lab : Use PowerPivot
  Explore PowerPivot Functions
  Use Basic PowerPivot
  Use PowerPivot with Large DataSets
  Create PowerPivot Linked Tables
  Publish to SharePoint
  Automating Data Refresh
  Analyzing Usage Data

Module 10: Reporting Services

Lessons
  Reporting Services
  Reports

Lab : Install Reporting Services
  Configure Reporting Services
  Create a Reporting Services Report
  Configure Reporting Services Web Part

Lab : Building Reports with Reporting Services
  Create Advanced Reporting Services report
  Filter Web Parts and Reports

Lab : Automating Reports with Reporting Services
  Create Report Part Gallery
  Create a Report Library
  Create Report Parts
  Create a Report using Report Parts
  Automated Report Delivery

Lab : Reporting Services and PowerPivot
  Setup Reporting Services RSS Feed
  Create and Use Data Feed Library
  Utilize Reporting Services data in PowerPivot
  Utilize PowerPivot data in Reporting Services

Module 11: Performance Point

Lessons
  Performance Point

Lab : Performance Point
  Explore Performance Service Application
  Explore the Dashboard Designer
  Create A Scorecard
  Create A PP KPI
  Explore Time Intelligence
  Create Performance Point Reports
  Create Filters
  Create A Dashboard

Module 12: Visio and Access Services

Lessons
  Visio Services
  Access Services

Lab : Visio Services
  Use Visio Services
  Publish a Visio to SharePoint
  Tie report process to Visio

Lab : Access Services
  Explore Access Services
  Publish Access Database To SharePoint

Module 13: GeoSpatial Data with Charts and Maps

Lessons
  Charts and Maps
  GeoSpatial Data

Lab : GeoSpatial Data with SQL Server
  Populate a SQL Server Database using Shape2SQL
  Utilize the new Spatial Data Types in SQL Server
  Create a Reporting Services Report using Geospatial Data
  Publish Geospatial Data to SharePoint 2010

Lab : Bing Maps
  Utilize Bing Maps API
  Create a Simple Map With Content Editor Web Part
  Create an Advanced Map with Data Views
  Explore Filters, Data Views and Bing Maps integration
  Integrate Geospatial Customer data into SharePoint Sites

Lab : NET Charts
  Utilize NET Charts

Preis € 1.940,00 (zzgl. ges. USt.)

Seminardauer 5 Tage

Termine 11.06.2012, 23.07.2012, 20.08.2012, 10.09.2012, 22.10.2012, 19.11.2012, 03.12.2012