First Release Full File package

Rating: No reviews yet
Downloads: 767
Released: Dec 11, 2010
Updated: Jan 12, 2011 by grphillips
Dev status: Stable Help Icon

Recommended Download

Example Holistic Data Warehouse Template files package
example, 2068K, uploaded Dec 12, 2010 - 601 downloads

Other Available Downloads

Documentation Holistic Data Warehousing book extract
documentation, 9134K, uploaded Dec 12, 2010 - 166 downloads

Release Notes

The Holistic Data Warehouse Files package includes the following components of the working Holistic Data Warehouse Template for SQL Server 2008

#HolisticDW.Bak - MS SQL Server 2008 Holistic Data Warehouse Template - database backup
#HolisticDWStaging.bak - MS SQL Server 2008 Holistic DW Staging database Template - database backup
#HolDWlog.txt.txt - the Adventure Works Demonstration loads Log file
#Holistic Adventure Works loads Folder - with the Visual Studio Demonstration SSIS load files used to load Adventure works data into the Holistic DW
#prime report new 20100627.xlsm - Microsoft Excel 2007 Main report generator spreadsheet for the Holistic DW (requires a populated Holistic DW and ODBC setup "DataWSQL")
#Bottom Up.xlsm - Microsoft Excel 2007 "Bottom Up" report generator spreadsheet for the Holistic DW (requires a populated Holistic DW and ODBC setup "DataWSQL")
#top down alt format.xlsm "Top Down" report generator spreadsheet for the Holistic DW (requires a populated Holistic DW and ODBC setup "DataWSQL")

All these are documented in the book Holistic Data Warehousing by the Authors and Holistic Data Warehouse Template designers Gerry Phillips and Jane McCarthy
An extract from the book is available to download as part of this project

Full Book available from Amazon. There is no other additional cost associated with this multi-purpose ready made template. It needs only to be populated according to our guidlines and demonstration loads from the Adventure Works sample databases.

42sight Blog: http://42sight.blogspot.com/
Book link - Amazon - ISBN 978-0980874242 - http://www.amazon.com/Holistic-Data-Warehousing-Microsoft-Server/dp/0980874246/ref=sr_1_1?ie=UTF8&s=books&qid=1292118352&sr=1-1

PLEASE NOTE - that the above demonstration loads from Adventure Works to the Holistic DW Template were designed to work with the "Case Insensitive" versions of Adventure works. See this post on the Microsoft forums for some information on the "Case Insensitive" version of Adventure Works:
http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/4d27ff3a-7895-4e68-8e03-fff10f6c189d/

Reviews for this release

No reviews yet for this release.