Data warehouse real-world examples
|Details:||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 and conversations between a WalMart executive and a Sybase database vendor. The business background is translated into technical SQL language and the difference between OLTP and DSS systems is clearly explained which helps understand both the business and technical aspects of data warehousing.
The tutorial walks users through the analysis of a source data, the creation of data warehouse design, building fact and dimension tables and selecting the data out of the data warehouse for reporting.
A good sense of humor presented in the article definitely helps understand the basic data warehouse concepts and makes it a great source of information.