M50491: Microsoft End-to-End Business Solutions using SQL Server 2008 R2 with SharePoint 2010 and Office 2010

5 Day Course
Hands On
Official Microsoft Curriculum
Code M50491

This course has been retired. Please view currently available Microsoft SQL Server Training Courses.

Modules

Hide all

The Business Intelligence Stack (14 topics)

  • SQL 2008R2 Business Intelligence Platform
  • SQL Analysis Services
  • SQL Reporting Services
  • Performance Management Tools
  • SharePoint 2010
  • Multidimensional Space
  • MDX
  • Data Mining
  • Understanding the Terminology
  • Lab: The Business Intelligence Stack
  • Explore Business Intelligence Development Studio
  • Connect into a SQL Server Analysis Services Cube
  • Use SQL Server Management Studio
  • Explore SharePoint 2010

Unified Data Model (7 topics)

  • UDM Defined
  • User Experience: Relational vs. UDM
  • Advantages
  • Trouble in River City
  • Lab: Unified Data Model
  • Creating a Data Mart using Business Intelligence Development Studio.
  • Enabling Table Compression

SQL Server Integration Services (18 topics)

  • Major Components
  • New or Changed Features
  • Script Task
  • Samples
  • SSIS and ETL
  • Transformers
  • Best Practices 1
  • Best Practices 2
  • Lab: Lab SSIS Projects
  • Create A SSIS Project
  • Add a Data Source
  • Create A Data Flow
  • Create Another Data Flow
  • Load Data via a SQL Statement
  • Populating the Fact Table
  • Loading Manufacturing Facts
  • Handling Errors
  • Inventory Fact Flow

SQL Server Analysis Services (18 topics)

  • Key Concepts
  • Schemas
  • Measures
  • Dimensions
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations
  • Lab: Lab SSAS Key Concepts
  • Define an OLAP Cube
  • Working with Measures and Measure Groups
  • Time and Hierarchies
  • Relating Dimensions
  • Build Deploy and Browse the Cube
  • Multiple Partitions
  • Set Storage
  • Design Aggregations
  • Default Members

SQL Server Reporting Services (9 topics)

  • Integration with SharePoint
  • Report Builder 3.0
  • Tablix
  • Charts
  • Lab: Lab SQL Server Reporting Services
  • Managing Reports with SharePoint 2010
  • Creating Subscriptions
  • Viewing Reports via SharePoint 2010
  • Report Builder 3.0

MDX (Optional) (14 topics)

  • What is MDX?
  • MDX Query Editor
  • Select Statement
  • Key Concepts
  • Sets
  • Functions
  • Time Intelligence
  • Lab: MDX (Optional Module)
  • Understand the Cell
  • Write a Tuple
  • MDX Sets
  • Write a SELECT statement
  • Write a Function
  • Implement Time

PerformancePoint Services 2010 (24 topics)

  • Integration with SharePoint Server 2010
  • Common Service Application Framework
  • New PerformancePoint Features
  • Storage Security
  • Time Intelligence and Dynamic Filters
  • Linking of Web Parts
  • KPI Details Report
  • Retired Features
  • Scorecards in PPS
  • KPI Collections
  • Dashboard Design Guidelines
  • Lab: PerformancePoint Services 2010
  • Use SharePoint to create a site collection
  • Configure Central Administration for PerformancePoint Services
  • Create and Explore a PerformancePoint Business Intelligence Center
  • Create a Basic Dashboard
  • Deploy the Dashboard
  • Explore the Dashboard in PPS
  • Dashboard Designer Internals
  • Dashboard Designer Interface
  • First Class Objects
  • Main Window
  • Properties
  • Dashboard Designer Features

Excel and Visio Services 2010 (9 topics)

  • Integration with SharePoint Server 2010
  • Storage Security
  • Single version of the truth
  • Excel Web Services
  • New capabilities
  • Lab: Excel Services 2010
  • Deploy a Excel spread sheet for a single version of the truth
  • Utilize excel Web Services
  • Create a Strategy map with Visio Services

Excel PowerPivot (5 topics)

  • Integration with SharePoint Server 2010
  • Understanding
  • Modeling
  • Lab: PowerPivot 2010
  • Explore Excel PowerPivot

Data Mining (7 topics)

  • Key Terms in Data Mining
  • Types of Data Mining Algorithms
  • The Algorithms
  • Excel and The BI Extensions
  • Visio 2007
  • Lab: Lab Excel 2010 and Data Mining BI
  • Utilize the Excel Data Mining Tools

Prerequisites

Before attending this course, students should have an understanding of the benefits of business intelligence.

Course PDF

Print

Sections