Data Warehouse Development for SQL Server 2005/2008
Course
In Gatwick
Description
-
Type
Course
-
Location
Gatwick
-
Duration
3 Days
Upon completion of this course, the delegate should understand how to deal with BI/DW design issues as they relate to SQL Server 2005/2008. Suitable for: Data warehouse analysts, ETL specialists, data warehouse administrators.
Facilities
Location
Start date
Start date
About this course
Completion of our course Data Warehousing Terms, Concepts & Architecture and and 6 months experience of Microsoft SQL Server 2005 or equivalent knowledge.
Reviews
Course programme
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
Data Warehouse Development for SQL Server 2005/2008