Designing a BI Solution Architecture for the Enterprise Using MS SQL Server 2005 (M2794)

Voraussetzung:
Before attending this course, students must:
Have observed all phases of the BI project lifecycle:
Collecting requirements
Developing ETL
Creating OLAP solutions
Developing reports
Supporting deployed solutions
Have foundational conceptual understanding of data warehousing, data marts, and Business Intelligence. Students must be well versed on the subjects of data warehousing, data marts, and BI, and preferably have read at least one book by Ralph Kimball or Bill Inmon.
Practical experience with OLAP, ETL, and Reporting on the Microsoft SQL Server Platform. For example, constructing cubes, developing packages, and writing reports.
Conceptual understanding of the components of SQL Server 2005. For example, changes to the OLAP, ETL, and reporting technologies.
Have foundational understanding of Microsoft Windows security. For example, how groups, delegation of credentials, and impersonation function in a security context.
Have foundational understanding of Web-based architecture. For example, SSL, SOAP, and IIS-what they are and what their role is.
Must understand the difference between replication and ETL.
Already know how to use:
Microsoft Office Visio
Microsoft SQL Server Business Intelligence Development Studio
Microsoft SQL Server Management Studio
Report Builder and Report Manager
Microsoft Visual SourceSafe
Microsoft Office Project
Be familiar with SQL Server 2005 features, tools, and technologies.
Themen:
Capture the business and technical requirements for a Business Intelligence solution architecture, Describe the major stages and requirements of a Business Intelligence project lifecycle, determine Business Intelligence development requirements and implement a Business Intelligence development project, Assess and design a Business Intelligence infrastructure, describe and plan Business Intelligence operations and their management.
Inhalt:
Introduction to Business Intelligence Architecture
Identifying Business Intelligence Solution Requirements
Overvie- of the Business Intelligence Project Lifecycle
Planning a Business Intelligence Project
Introduction to Business Intelligence Development
Developing a Business Intelligence Solution
Designing Business Intelligence Infrastructure
Supporting Business Intelligence Infrastructure growth
Managing Business Intelligence Operations
Using Microsoft Operations Framework (MOF) to Manage Business Intelligence Operations