Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Building Business Intelligence Data Warehouses Expand / Collapse
Posted Friday, June 27, 2003 12:00 AM


Group: General Forum Members
Last Login: Thursday, September 16, 2010 9:01 AM
Points: 148, Visits: 132
Comments posted to this topic are about the content posted at

Post #13677
Posted Monday, July 14, 2003 9:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 6, 2007 11:16 AM
Points: 34, Visits: 8
Definitely a high level (somewhat academic) review of Data Warehouses. The clients my company interacts with don't have "steering committees" but do have business needs that we are solving.

Sometimes the road to the Enterprise or large Departmental Data Warehouse is through Data Marts that conform through dimensions.

I am not slamming the article but Practical Experience and providing incremental, short-term value through multiple marts is what has made my company successful.

I applaud the effort here and look forward to the next article from this author.

Trey Johnson
Principal Architect
BI Practice
Encore Development
VP of Marketing
Professional Association for SQL Server (PASS)

Trey Johnson | Chief Business Intelligence Architect | Cizer Software (

Who? - Cizer - - Blog -
What? - Products enhancing Microsoft Business Intelligence -
Wow! - Empower your Developers.... NEW Drop In Reporting -
How? - BI Training - - Cizer Solutions -
Post #68607
Posted Tuesday, July 15, 2003 12:14 PM



Group: Administrators
Last Login: Today @ 10:11 AM
Points: 34,362, Visits: 18,573
I work with Tom and the "stovepipe" problem is something I've seen here as well as other places. Having projects like this centralized, even with a steering committee of one can help to prevent inconsistencies.

Also, a good look at some of the pitfalls. ETL is a great tool, but not the solution for bad data.

Steve Jones

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #68608
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse