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

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.

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

---

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

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.