If you download the AdventureWorks database and the Data Warehouse version, you'll see the difference. They're very different. I'm sure there are tutorials all over the place, but the purpose of each is different. An OLTP system has to be fast and flexible (so normalization helps a lot). In a data warehouse, the data doesn't change, and it's used for querying/summary... So the design rules are different. If you look at the two database structures (the OLTP one and the DW one) side by side, you'll see the differences. Even if you just download the really simple AdventureWorks version that Rob Collie used for his book on DAX, the differences will be really obvious. Maybe read up on dimensional modeling or star schemas.