Course 50263: Introduction to Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007
Fully leverage your existing technologies!
This five-day instructor-led 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, Excel Web Services, and Business Intelligence with Excel 2007 and Visio 2007
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.
After completing the 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 2.0
- Load and Manage Reports with SharePoint
- Understand and Create a Shared Service Provider in SharePoint
- Understand and Create a Business Data Catalog in SharePoint
- Set permissions on objects within SharePoint
- Utilize the Business Intelligence add-ins for Excel 2007
- 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
- Module 1: Course Overview
- Module 2: Microsoft Business Intelligence Stack
- Module 3: Unified Data Model
- Module 4: SharePoint Server 2007
- Module 5: SQL Server Integration Services SQL 2008 R2
- Module 6: SQL Server Analysis Server SQL 2008 R2
- Module 7: SQL Server Reporting Server SQL 2008 R2
- Module 8: Excel Services
- Module 9: Business Data Catalog
- Module 10: Performance Point Server 2007 Monitoring and Analysis
- Module 11: SharePoint Business Data Catalog
- Module 12: Data Mining
- Module 13: Office 2007
- Module 14: Security
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.