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/
You shared us a very detailed information regarding the process of a warehouse making. It looks so effective for me that is why I copy, paste and save it for future reference. Expect me to share this to others too.
ReplyDelete