Course Description | Course Outline | Microsoft SharePoint | IT Training

Module 1: Overview

Module 2: Business Intelligence

• Business Intelligence

• Answer Business Intelligence Questions

Module 3: Business Intelligence Center

• Business Intelligence Center

• Explore SharePoint Business Intelligence Center
• Explore Dashboard Designer

Module 4: Data Mart and Data Warehouses

• Understanding Data and Data Formats
• Building Data Marts and Data Warehouses

• Explore Data Formats

• Create a Simple Data Warehouse

• Explore the Extract stage

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

• Create Data Warehouse Granularity Levels

• Create a Data Mart

• Populate a SharePoint List with SQL Server data

Module 5: Business Connectivity Services

• Business Connectivity Services

• Explore External Content Types
• Create a new External Content Type
• Create an External List

• Create an Large External List using ECTs
• Using Filters and External lists
• Creating and Configuring Entity Profile Pages

• Explore Office and BCS Integration

Module 6: Analysis Services

• Analysis Services

• Create Dimension and Fact tables with SSIS

• Create a Analysis Services Database
• Create a Cube
• Create Dimensions
• Create Fact Tables
• Create a KPI

Module 7: Filter Web Parts

• Filter Web Parts

• Use each of the Filter Web Parts

• Integrate User Profiles with Filters and Reports

Module 8: Excel Services

• Excel Services

• Create An Excel Report

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

• Explore Excel 2010 MDX features
• Create a Slicer
• Create an MDX Set

• Use Excel 2010 Sparklines

• Explore Filter Web Parts and Excel Services

• Explore REST features of Excel ServicesExplore the Excel Services Web Service

Module 9: PowerPivot

• PowerPivot For SharePoint
• PowerPivot For Excel

• Install PowerPivot for Excel
• Install PowerPivot for SharePoint 2010
• Configure PowerPivot for SharePoint

• 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

• Reporting Services
• Reports

• Configure Reporting Services
• Create a Reporting Services Report
• Configure Reporting Services Web Part

• Create Advanced Reporting Services report
• Filter Web Parts and Reports

• Create Report Part Gallery
• Create a Report Library
• Create Report Parts
• Create a Report using Report Parts
• Automated Report Delivery

• 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

• 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

• Visio Services
• Access Services

• Use Visio Services
• Publish a Visio to SharePoint
• Tie report process to Visio

• Explore Access Services
• Publish Access Database To SharePoint

Module 13: GeoSpatial Data with Charts and Maps

• Charts and Maps
• GeoSpatial Data

• 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

• 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

• Utilize NET Charts