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.

Learning Objectives
After completing this course, students will be able to:

• Describe the Microsoft Business Intelligence stack.
• Explain the Unified Dimension Model and when it can and cannot be used.
• Use the new Business Intelligence Features in SQL 2008.
• Create a SSAS Project using the Microsoft Unified Dimension Model.
• Create a Data Mart using Business Intelligence Studio.
• Create a Integration Services project and load a Data Mart.
• Load a Data Mart from a flat file.
• Model Dimensions, Measures and Cubes.
• Understand the pros and cons of Integration into SharePoint.
• Create a Report using Report Builder 3.0.
• Load and Manage Reports with SharePoint.
• Create Report Subscriptions in SharePoint.
• Create and customize the SharePoint Report Center.
• Realize the importance of and customize SharePoint Content Types.
• Explain the differences in workflows in SharePoint.
• Understand and Create a Shared Service Provider in SharePoint.
• Understand and Create a Business Data Catalog in SharePoint.
• Utilize the Business Intelligence add-ins for Excel 2007.
   

Length
5 Days