MOC 50263 Intro to MS BI from SQL 2008 through SharePoint and Office 2007

    

Summary:
This course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and Visio 2007.

Duration:
5 Days/Lecture & Lab

Audience:
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.

Topics:

• Overview of the Microsoft BI Stack
• Unified Data Model
• SQL Server Integration Services
• SQL Server Analysis Server
• SQL Server Reporting Services
• SharePoint Server 2007
• SharePoint Business Data Catalog
• SharePoint Excel Services
• Data Mining and Excel

Prerequisites:
Before attending this course, students must 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

Last Update: May 23, 2012