[SQL Server Data Warehousing] Forms templates for documenting DW analysis & design, + naming conventions

you need to check some structural principles like how they implemented Slowly Changing Dimension, Incremental Load, Late Arriving Fact tables ... and any other challenge-able parts of data warehouses. you will get some good ideas about how these concepts should be considered after reading Kimball books (the Data Warehouse toolkit , and ETL book)

for naming conventions, there are some naming conventions that you might find by googling. for example this is good naming convention for SSIS:

http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

and for SSAS:

http://cwebbbi.wordpress.com/2010/04/07/naming-objects-in-analysis-services/

---

http://www.rad.pasfu.com

.

social.technet.microsoft.com/Forums