Home >
SQL Server >
Data Warehouse Development for SQL Server 2005
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%).
|
Detailed Outline |
|