Data Warehouse Development for SQL Server 2005

Course Code: SQSDWD
Duration: 3 days
Level: Intermediate
Audience: Data warehouse analysts, ETL specialists, data warehouse administrators.
Prerequisites: Completion of our courses Data Warehouse Terms, Concepts & Architecture and SQL Server 2005 Integration Services Fundamentals or equivalent knowledge.
Features: Data warehouse/data mart and multidimensional cube development using realistic scenarios.
Summary: Designed to emphasise SQL Server 2005's features specific to business intelligence (BI) and data warehousing (DW), this scenario and hands-on presentation details the following:
  • Data mart design and load
  • Business Intelligence Development Studio (BIDS)
  • SQL Server Management Studio
  • Building dimension tables
  • Building fact tables
  • Developing dimensions
  • Hierarchies
  • ETL via SQL Server 2005 Integration Services (SSIS)
  • Security
  • SQL Server 2005 Analysis Services (SSAS)
  • Performance and good practices
Objectives: Upon completion of this course, the delegate should understand how to deal with BI/DW design issues as they relate to SQL Server 2005.
Format: Lecture and hands-on (about 60%).
View full outline in PDF formatDetailed Outline

print  |  top of page