M50491: End to End Microsoft Business Intelligence. An exploration of the entire stack.

Version: A
Length: 5 Days 
Published: November 15, 2010 
Language(s): English 
Audience(s): IT Professionals, Developers 
Level: 200 
Technology: Microsoft SQL Server 2008 R2 
Type: Course 
Delivery Method: Instructor-led (classroom)

About this Course
This instructor-ledcourse 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 introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Reporting Services, Report Builder 3.0, SharePoint 2010 Integration, Reporting Services Content Types, PerformancePoint Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining 
Audience Profile
This course is intended for DBAs, Developers and Business Intelligence Professionals seeking an introduction to the Microsoft BI Stack whether for new or existing projects or migration to the Microsoft environment or having a desire to view the new features in the entire stack. 
At Course Completion
After completing this course, students will be able to:
oDescribe the Microsoft Business Intelligence stack
oExplain the Unified Dimension Model and when it can and cannot be used.
oUse the new Business Intelligence Features in SQL 2008 R2
oCreate a SSAS Project using the Microsoft Unified Dimension Model
oCreate a Data Mart using Business Intelligence Studio
oCreate a Integration Services project  and load a Data Mart
oLoad a Data Mart from a flat file.
oModel Dimensions, Measures and Cubes
oUnderstand the pros and cons of Integration into SharePoint
oCreate a Report using Report Builder 3.0
oLoad and Manage Reports with SharePoint
oUtilize the Business Intelligence add-ins for Excel 
oDiscover, design and implement KPIs
oUnderstand the role of SQL Server Analysis Services in measurement for KPIs
oImplement Time Intelligence features to query such as Year-To-Date, Last 6 Months etc.
oUse Excel Services and Excel Workbooks in Scorecards or as a data source
oUtilize the document management capabilities of SharePoint 2010 for objects for versioning, document retention and reverting.
oUse Dashboard Designer 
oGain a generalized understanding of MDX to write basic queries
oGenerate Visual Reports and tie them into Dashboards
oUtilize decomposition trees
oUnderstand what the advantages of having SharePoint as the platform are.
oUse dynamic hierarchies in Scorecards
oImplement User Menus in Scorecards

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

Course Outline
Module 1: The Business Intelligence Stack
Lessons 
oSQL 2008R2 Business Intelligence Platform
oSQL Analysis Services
oSQL Reporting Services
oPerformance Management Tools
oSharePoint 2010
oMultidimensional Space
oMDX
oData Mining
oUnderstanding the Terminology
Lab : The Business Intelligence Stack
oExplore Business Intelligence Development Studio
oConnect into a SQL Server Analysis Services Cube
oUse SQL Server Management Studio
oExplore SharePoint 2010
Module 2: Unified Data Model
Lessons 
oUDM Defined
oUser Experience: Relational vs. UDM
oAdvantages
oTrouble in River City
Lab : Unified Data Model
oCreating a Data Mart using Business Intelligence Development Studio.
oEnabling Table Compression
Module 3: SQL Server Integration Services
Lessons 
oMajor Components
oNew or Changed Features
oScript Task
oSamples
oSSIS and ETL
oTransformers
oBest Practices 1
oBest Practices 2
Lab : Lab SSIS Projects
oCreate A SSIS Project
oAdd a Data Source
oCreate A Data Flow
oCreate Another Data Flow
oLoad Data via a SQL Statement
oPopulating the Fact Table
oLoading Manufacturing Facts
oHandling Errors
oInventory Fact Flow
Module 4: SQL Server Analysis Services
Lessons 
oKey Concepts
oSchemas
oMeasures
oDimensions
oCube Processing
oPartitions
oProactive Caching
oAggregations
Lab : Lab SSAS Key Concepts
oDefine an OLAP Cube
oWorking with Measures and Measure Groups
oTime and Hierarchies
oRelating Dimensions
oBuild Deploy and Browse the  Cube
oMultiple Partitions
oSet Storage
oDesign Aggregations
oDefault Members
Module 5: SQL Server Reporting Services
Lessons 
oIntegration with SharePoint
oReport Builder 3.0
oTablix
oCharts
Lab : Lab SQL Server Reporting Services
oManaging Reports with SharePoint 2010
oCreating Subscriptions
oViewing Reports via SharePoint 2010
oReport Builder 3.0
Module 6: MDX (Optional)
Lessons 
oWhat is MDX?
oMDX Query Editor
oSelect Statement
oKey Concepts
oSets
oFunctions
oTime Intelligence
Lab : MDX (Optional Module)
oUnderstand the Cell
oWrite a Tuple
oMDX Sets
oWrite a SELECT statement
oWrite a Function
oImplement Time
Module 7: PerformancePoint Services 2010
Lessons 
oIntegration with SharePoint Server 2010
oCommon Service Application Framework
oNew PerformancePoint Features
oStorage Security
oTime Intelligence and Dynamic Filters
oLinking of Web Parts
oKPI Details Report
oRetired Features
oScorecards in PPS
oKPI Collections
oDashboard Design Guidelines
Lab : PerformancePoint Services 2010
oUse SharePoint to create a site collection
oConfigure Central Administration for PerformancePoint Services
oCreate and Explore a PerformancePoint Business Intelligence Center
oCreate a Basic Dashboard
oDeploy the Dashboard
oExplore the Dashboard in PPS
oDashboard Designer Internals
oDashboard Designer Interface
oFirst Class Objects
oMain Window
oProperties
oDashboard Designer Features
Module 8: Excel and Visio Services 2010
Lessons 
oIntegration with SharePoint Server 2010
oStorage Security
oSingle version of the truth
oExcel Web Services
oNew capabilities
Lab : Excel Services 2010
oDeploy a Excel spread sheet for a single version of the truth
oUtilize excel Web Services
oCreate a Strategy map with Visio Services
Module 9: Excel PowerPivot
Lessons 
oIntegration with SharePoint Server 2010
oUnderstanding
oModeling
Lab : PowerPivot 2010
oExplore Excel PowerPivot
Module 10: Data Mining
Lessons 
oKey Terms in Data Mining
oTypes of Data Mining Algorithms
oThe Algorithms
oExcel and The BI Extensions
oVisio 2007
Lab : Lab Excel 2010 and Data Mining BI
oUtilize the Excel Data Mining Tools
 
Additional Reading
To help you prepare for this class, review the following resources:
Delivering Business Intelligence with Microsoft SQL Server