Premier
SQL Server 2008

The Microsoft Intelligence 2010 Stack
(Microsoft Training Course: 50511) - 5 days - £2095 exc VAT



> Target Audience
This course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010.The course is intended for BI Project Managers, BI Developers, I.T. Professionals, end-user ombudsman and BI analysts.
> Course outline
  1. The Business Intelligence Stack
  2. Unified Data Model
  3. SQL Server Integration Services
  4. SQL Server Analysis Services
  5. SQL Server Reporting Services
  6. MDX (optional)
  7. PerformancePoint Services 2010
  8. Excel Services, Business Connectivity Services
  9. Excel PowerPivot
  10. Data Mining


Module 1: The Business Intelligence Stack
  • 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
Skills
  • Explore Business Intelligence Development Studio
  • Connect into a SQL Server Analysis Services Cube
  • Use SQL Server Management Studio
  • Explore SharePoint 2010
top
Module 2: Unified Data Model
  • UDM Defined
  • User Experience: Relational vs. UDM
  • Advantages
  • Trouble in River City
  • Lab: Unified Data Model
Skills
  • Creating a Data Mart using Business Intelligence Development Studio.
  • Enabling Table Compression
top
Module 3: SQL Server Integration Services
  • Major Components
  • New or Changed Features
  • Script Task
  • SSIS and ETL
  • Transformers
  • Best Practices 1
  • Best Practices 2
  • Lab: Lab SSIS Projects
Skills
  • 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
top
Module 4: SQL Server Analysis Services
  • Key Concepts
  • Schemas
  • Measures
  • Dimensions
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations
  • Lab: Lab SQL Server Analysis Services
Skills
  • 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
top
Module 5: SQL Server Reporting Services
  • Integration with SharePoint
  • Report Builder 3.0
  • Differences Between Environments
  • Tablix
  • Charts
  • Lab: Lab SQL Server Reporting Services
Skills
  • SSRS Projects Report Wizard
  • Report Builder 3.0
  • Creating Charts
top
Module 6: MDX (optional)
  • What is MDX?
  • MDX Query Editor
  • Select Statement
  • Key Concepts
  • Sets
  • Functions
  • Time Intelligence
  • Lab: MDX (Optional Module)
Skills
  • Understand the Cell
  • Write a Tuple
  • MDX Sets
  • Write a SELECT statement
  • Write a Function
  • Implement Time
top
Module 7: PerformancePoint Services 2010
  • 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
  • Dashboard Designer Internals
  • Dashboard Designer Interface
  • First Class Objects
  • Main Window
  • Properties
  • Dashboard Designer Features
  • Lab: PerformancePoint Services 2010
Skills
  • 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
top
Module 8: Excel Services, Business Connectivity Services
  • Integration with SharePoint Server 2010
  • Storage Security
  • Single version of the truth
  • Excel Web Services
  • New capabilities in Excel Services
  • Business Connectivity Services
  • Lab: Excel Services 2010
Skills
  • Deploy a Excel spread sheet for a single version of the truth
  • Utilize Excel Web Services
  • Business Connectivity Services
top
Module 9: Excel PowerPivot
  • Integration with SharePoint Server 2010
  • Understanding Modeling
  • Lab: PowerPivot 2010
Skills
  • Explore Excel PowerPivot
top
Module 10: Data Mining
  • Key Terms in Data Mining
  • Types of Data Mining Algorithms
  • The Algorithm
  • Excel and The BI Extensions
  • Visio 2010
  • Lab: Lab Excel 2010 and Data Mining BI
Skills
  • Utilize the Excel Data Mining Tools
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • • A working knowledge of RDBMS
  • • A working knowledge of Business Intelligence Studio
  • • A working knowledge of Excel and the Office Ribbon
  • • Understanding of the goals of Business Intelligence
> Purpose
After completing this course, students will be able to describe the role of each component in the Microsoft Business Intelligence stack so that a better informed estimate of resources might be made in the BI project; explain the Unified Data Model, understand limitations and implementations and when it is appropriate to use in BI deployment; explain what SQL 2008 and the R2 release change in Microsoft BI and how to leverage these technologies; gain a knowledge of SQL Integration Services and understand why the Extract Transform and Load process use 40% or more of the entire project budget; get an explanation of Multidimensional space in SQL Server Analysis Services; learn to plan for the on-going maintenance of BI projects and their expansion across the enterprise.