Data Warehousing and Dimensional Modeling

Data Warehouse Fundamentals http://it.toolbox.com/wiki/index.php/Data_Warehouse_Fundamentals and http://www.rkimball.com/html/articlesFundamental.html

Kimball Group http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/

Data Warehouse Toolkit Collection http://www.amazon.com/Kimballs-Data-Warehouse-Toolkit-Classics/dp/0470479574

Best Practices for Data Warehousing with SQL Server 2008 http://msdn.microsoft.com/library/cc719165.aspx

DWMantra.com http://www.dwmantra.com/dwconcepts.html

Data Warehouse Maturity Level http://sharepoint/sites/bpdcxstg/SQLCAT/Documents/Tier%201%20DW%20Toolbox/Data%20Warehouse%20Maturity%20Model.pptx

ETL

Data Loading Performance Guide: This guide covers bulk loading design patterns and best practices. It also talks about how the TPCH ETL World Record was achieved. A MUST READ for every Microsoft data warehouse ETL developer. http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx

Data Quality Services and Master Data Management

Microsoft Master Data Management http://msdn.microsoft.com/en-us/library/ff487016.aspx

Check out all the good free videos on the upcoming SQL Server brand new Data Quality Services features to learn both the “What and How” of this addition to SQL Server. http://msdn.microsoft.com/en-us/sqlserver/hh323832.aspx

SQL Server 2008R2 Data Quality and Master Data Management: free ebook from Solid Quality Mentors at
http://www.solidq.com/ce-en/AboutUS/Documents/DQMDM_SQL2008R2.pdf.

Metadata

There are multiple ways to manage Microsoft BI metadata, impact analysis, dependency analysis and lineage. A current option fan favorite is the low cost BI Documenter by Pragmatic Works: http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Overview.aspx. BI Documenter works with the full BI stack – database, SSIS, SSAS, SSRS – with versions 2005 and up. It has many nice features such as a metadata editor, object change compare viewer, dependency graphing, workflow and totally automated solution documentation.

Another current option is the Microsoft Metadata 2008 Toolkit at http://sqlmetadata.codeplex.com. The metadata toolkit tracks data lineage, technical metadata, and performs impact analysis for SSIS, SSAS, SSRS, and SQL. Features include:

-Database Repository to store the metadata

-Stand-alone Dependency Analyzer program to view dependencies

-Report model for ad hoc reporting on technical metadata.

-Reports on impact analysis, dependency analysis, lineage

Additional Metadata Management Resources

SQL Server Metadata Toolkit http://archive.msdn.microsoft.com/SqlServerMetadata/Release/ProjectReleases.aspx?ReleaseId=1174

Managing Metadata in SQL Server http://msdn.microsoft.com/en-us/library/cc966384.aspx http://channel9.msdn.com/Events/TechEd/Europe/2010/BIN308 http://ecn.channel9.msdn.com/o9/te/Europe/2010/pptx/bin308.pptx