Data Warehouse Process

Source DB --> SSIS --> SSAS --> SSRS

• Application Database (Source DB).

• Definition of needs and requirements
• Design the Data Warehouse
• Construction of dimensions
• Construction of fact tables
• ETL
• Extract relevant data.
• Transform data to DWH format.
• Load data into DWH.
• Relational Data Warehouse Management.

• DATA Analysis
• Dimensions and cubes in an Analysis Services solution.

• Data Presentation – Reports.

SQL Server 2008 Data Warehousing
http://www.microsoft.com/sqlserver/2008/en/us/data-warehousing.aspx
Best Practices for Data Warehousing with SQL Server 2008
http://msdn.microsoft.com/en-us/library/cc719165(v=sql.100).aspx
An introduction to SQL Server data warehousing concepts (presentation)
http://searchsqlserver.techtarget.com/video/An-introduction-to-SQL-Server-data-warehousing-concepts
SQL Server Data Warehouse Cribsheet
http://www.simple-talk.com/sql/learn-sql-server/sql-server-data-warehouse-cribsheet/