2794A Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005
Before attending this course, students must:
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.
Have conceptual understanding of the components of SQL Server 2005. For example, the online analytical processing (OLAP), extract, transport, and load (ETL), and reporting technologies.
Have practical experience with OLAP, ETL, and Reporting on the SQL Server 2005 Platform. For example, constructing cubes, developing packages, and writing reports.
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.
Already know how to use:
Microsoft Office Visio
Microsoft SQL Server Business Intelligence Development Studio
Microsoft SQL Server Management Studio
Performance Monitor
Report Builder and Report Manager
Microsoft Visual SourceSafe