The Microsoft Business Intelligence 2010 Stack

Delivery Options

• Customized Onsite Training (5 days): Request a Proposal

Class Description

Class Overview

Class Goals

• Learn to describe the entire Microsoft Business Intelligence stack and the role of each component so that a better informed estimate of resources might be made in the BI project.
• Learn to explain the concept of the Unified Data Model, understand its limitations and practical implementations and when it might be appropriate to use in a fast and low cost BI deployment.
• Learn to explain what SQL 2008 and the R2 release change in Microsoft BI and how best to leverage these technologies.
• Gain a good working knowledge of SQL Integration Services and with that knowledge understands why the Extract Transform and Load process may go through 40 percent or more of the entire project budget.
• Finally get an explanation of Multidimensional space in SQL Server Analysis Services that can be comprehended by us mere mortals and with that knowledge learn how to get the domain experts such as HR or Marketing to communicate what they really need to know about the business.
• Learn to plan for the on-going maintenance and changing nature of BI projects and then their rapid expansion across the enterprise.
• Learn the terrific new report design interface Report Builder 3.0 and also the PerformancePoint Services one-click application Dashboard designer.
• Learn to use these tools to design reports in either ad-hoc mode or for distribution once or scheduled on subscriptions.
• Explore the Dashboard designer and see the ease of which you can create scorecards, filters, KPIs and dashboards.
• Understand the roll of PowerPivot in Microsoft BI. PowerPivot is the big development with Excel 2010 and SQL Server 2008 R2. You will learn where it fits, how to use it and what effect it will have on the present and future of your Microsoft BI investment.
• Learn about Excel Services 2010 and you will be able to successfully implement a "Single version of the Truth workbook" deployment.
• Learn where to use which Microsoft Algorithm to solve which type of a business problem.

Class Outline

1. The Business Intelligence StackLessons
   1. SQL 2008R2 Business Intelligence Platform
   2. SQL Analysis Services
   3. SQL Reporting Services
   4. Performance Management Tools
   5. SharePoint 2010
   6. Multidimensional Space
   7. MDX
   8. Data Mining
   9. Understanding the Terminology
   10. Lab: The Business Intelligence Stack
       1. Explore Business Intelligence Development Studio
       2. Connect into a SQL Server Analysis Services Cube
       3. Use SQL Server Management Studio
       4. Explore SharePoint 2010
2. Unified Data ModelLessons
   1. UDM Defined
   2. User Experience: Relational vs. UDM
   3. Advantages
   4. Trouble in River City
   5. Lab: Unified Data Model
      1. Creating a Data Mart using Business Intelligence Development Studio.
      2. Enabling Table Compression
3. SQL Server Integration ServicesLessons
   1. Major Components
   2. New or Changed Features
   3. Script Task
   4. SSIS and ETL
   5. Transformers
   6. Best Practices 1
   7. Best Practices 2
   8. Lab: Lab SSIS Projects
      1. Create A SSIS Project
      2. Add a Data Source
      3. Create A Data Flow
      4. Create Another Data Flow
      5. Load Data via a SQL Statement
      6. Populating the Fact Table
      7. Loading Manufacturing Facts
      8. Handling Errors
      9. Inventory Fact Flow
4. SQL Server Analysis ServicesLessons
   1. Key Concepts
   2. Schemas
   3. Measures
   4. Dimensions
   5. Cube Processing
   6. Partitions
   7. Proactive Caching
   8. Aggregations
   9. Lab: Lab SQL Server Analysis Services
      1. Define an OLAP Cube
      2. Working with Measures and Measure Groups
      3. Time and Hierarchies
      4. Relating Dimensions
      5. Build Deploy and Browse the Cube
      6. Multiple Partitions
      7. Set Storage
      8. Design Aggregations
      9. Default Members
5. SQL Server Reporting ServicesLessons
   1. Integration with SharePoint
   2. Report Builder 3.0
   3. Differences Between Environments
   4. Tablix
   5. Charts
   6. Lab: Lab SQL Server Reporting Services
      1. SSRS Projects Report Wizard
      2. Report Builder 3.0
      3. Creating Charts
6. MDX (0ptional)Lessons
   1. What is MDX?
   2. MDX Query Editor
   3. Select Statement
   4. Key Concepts
   5. Sets
   6. Functions
   7. Time Intelligence
   8. Lab: MDX (Optional Module)
      1. Understand the Cell
      2. Write a Tuple
      3. MDX Sets
      4. Write a SELECT statement
      5. Write a Function
      6. Implement Time
7. PerformancePoint Services 2010Lessons
   1. Integration with SharePoint Server 2010
   2. Common Service Application Framework
   3. New PerformancePoint Features
   4. Storage Security
   5. Time Intelligence and Dynamic Filters
   6. Linking of Web Parts
   7. KPI Details Report
   8. Retired Features
   9. Scorecards in PPS
   10. KPI Collections
   11. Dashboard Design Guidelines
   12. Dashboard Designer Internals
   13. Dashboard Designer Interface
   14. First Class Objects
   15. Main Window
   16. Properties
   17. Dashboard Designer Features
   18. Lab: PerformancePoint Services 2010
       1. Use SharePoint to create a site collection
       2. Configure Central Administration for PerformancePoint Services
       3. Create and Explore a PerformancePoint Business Intelligence Center
       4. Create a Basic Dashboard
       5. Deploy the Dashboard
       6. Explore the Dashboard in PPS
8. Excel Services, Business Connectivity ServicesLessons
   1. Integration with SharePoint Server 2010
   2. Storage Security
   3. Single version of the truth
   4. Excel Web Services
   5. New capabilities in Excell Services
   6. Business Connectivity Services
   7. Lab: Excel Services 2010
      1. Deploy a Excel spread sheet for a single version of the truth
      2. Utilize Excel Web Services
      3. Business Connectivity Services
9. Excel PowerPivotLessons
   1. Integration with SharePoint Server 2010
   2. Understanding Modeling
   3. Lab: PowerPivot 2010
      1. Explore Excel PowerPivot
10. Data MiningLessons
    1. Key Terms in Data Mining
    2. Types of Data Mining Algorithms
    3. The Algorithm
    4. Excel and The BI Extensions
    5. Visio 2010
    6. Lab: Lab Excel 2010 and Data Mining BI
       1. Utilize the Excel Data Mining Tools

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following areas is required:

• 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.

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Onsite course technical requirements and setup instructions.