50511: The Microsoft Business Intelligence 2010 Stack

Can’t find the right date? Consider a self study option. Get immediate access to online training videos, course materials and exam prep guides. Check out our Microsoft Self Study Courses >>>.

All Prices Are in Candian Dollars

Price :

  • Notify me

    Please leave your email and date you wish to take a course.
    • Date Format: DD slash MM slash YYYY



About this Course

This instructor-led 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 SharePoint2010 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, and the Business Intelligence Center, PerformancePoint Services, Business Connectivity Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining.


Audience Profile

BI Project managers, BI Developers, I.T. Professionals, end-user ombudsman, BI analyst

This course was designed from the perspective of team immersion drawing on the authors 20 plus years in IT Andover 10 years in Business Intelligence/OLAP Reporting and dashboard design. This course will expose team members to all aspects of the Microsoft BI stack from the source data through the reporting of the data be it in a subscribed report or through an interactive digital dashboard.


Elevator Pitch:

The intention of this course is tallow a business to more accurately understand the scope of a BI project, the resources, the potential pitfalls, and the state of the art and perhaps most importantly understand why it may produce for an organization an unmatched competitive edge.


At Course Completion

After completing this course, students will be able 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.
  • 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.
  • 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.
  • Data without visualization is of limited value. In this course you will experience the terrific new report design interface Report Builder 3.0 and also the PerformancePoint Services one-click application Dashboard designer.
  • You will learn to use these tools to design reports in either ad-hoc mode or for distribution once or scheduled on subscriptions.
  • You will explore the Dashboard designer and see the ease of which you can create scorecards, filters, KPIs and dashboards.
  • Understand the roll of Power Pivot 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.
  • Excel rules the land of the MBA! Here we will explore Excel Services 2010 and you will be able to successfully implement a Single version of the Truth workbook deployment.
  • The course ends with a walk through Data Mining which could easily be a standalone five day course. You will learn where to use which Microsoft Algorithm to solve which type of a business problem.



Before attending this course, students should have:

  • 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


Course Outline


Module 1: The Business Intelligence Stack



  • SQL 2008R2Business Intelligence Platform
  • SQL Analysis Services
  • SQL Reporting Services
  • Performance Management Tools
  • SharePoint2010
  • 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


Module 2: Unified Data Model



  • 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


Module 3: SQL Server Integration Services



  • Major Components
  • New or Changed Features
  • Script Task
  • SSIS and ETL
  • Transformers
  • Best Practices1
  • Best Practices2


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



Module 4: SQL Server Analysis Services


  • Key Concepts
  • Schemas
  • Measures
  • Dimensions
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations


Lab: Lab SQL Server Analysis Services

  • 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


Module 5: SQL Server Reporting Services



  • Integration with SharePoint
  • Report Builder3.0
  • Differences Between Environments
  • Tablix
  • Charts


Lab: Lab SQL Server Reporting Services

  • SSRS Projects Report Wizard
  • Report Builder3.0
  • Creating Charts


Module 6: MDX (0ptional)



  • 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


Module 7: PerformancePoint Services 2010



  • Integration with SharePoint Server 2010
  • Common Service Application Framework
  • New Performance Point 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

  • Use Share Point 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


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
  • Deploy a Excel spread sheet for a single version of the truth
  • Utilize Excel Web Services
  • Business Connectivity Services


Module 9: Excel PowerPivot



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

Module 10: Data Mining



  • Key Terms in Data Mining
  • Types of Data Mining Algorithms
  • The Algorithm
  • Excel and TheBI Extensions
  • Visio 2010

Lab: Lab Excel 2010 and Data Mining BI

  • Utilize theExcel Data Mining Tools


All search results