Data warehouse real-world examples
The data warehousing tutorial illustrates two real Data Warehousing scenarios. The first business case is a design of a real world data warehouse for Levis Strauss. Another is a hypothetical classic retail example which is represented as a series of scenes...

http://philip.greenspun.com/sql/data-warehousing.html

ETL and data warehousing tutorial
Typical ETL real life scenarios with solutions. The section depicts typical datawarehousing problems and shows how to handle them in various ETL environments using different approaches: Datastage, Pentaho Data Integration (PDI), SAS, Oracle and SQL....

http://etl-tools.info/data-warehousing_tutorial.htm

Implementing Slowly Changing Dimensions
The tutorial shows how to implement Slowly Changing Dimensions in a data warehouse. It lists all the major differences between different types of SCD (SCD Type 0 through to Type 4) and shows how to implement it in a real life data warehouse. The portal also...

http://etl-tools.info/en/scd.html

LearnDataModeling
The LearnDataModeling site is aimed to help learning data warehousing. It contains information and learning materials about business intelligence, data modelling, database design for a data warehouse, ETL and metadata management. The examples are clear and...

http://www.learndatamodeling.com/

DW Architecture
Data Warehouse architecture and concepts explained with examples. The site contains comparisons between different DW designs (Star, Snowflake and Fact Constellation schema) and overview of the multidimensional data modelling and managing slowly changing...

http://etl-tools.info/en/bi/datawarehouse_architecture.htm

Data warehouse training articles
Data warehousing training and tutorial articles on the pages of Kimball Group. The data warehouse architecture articles cover all the relevant areas a data warehouse architect need to have in mind when building a data warehouse. The tutorials take into...

http://www.kimballgroup.com/html/articlesArchitecture.html