Category Archives: Data warehouse

Business Intelligence/Data Warehouse Assessment

When I am tasked to do a business intelligence or data warehouse assessment, the steps I take to do that depend on the amount of time and the number of people I have.  The result of the assessment will be … Continue reading

Posted in Business Intelligence, Data warehouse, SQLServerPedia Syndication | 2 Comments

I’m presenting at the PASS Business Analytics Conference

I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA on May 7-9.  My presentation will be on Thursday, May 8th from 1:30-2:30pm.  Below is my presentation abstract along with … Continue reading

Posted in Data warehouse, PASS, Presentation, Session, SQLServerPedia Syndication | 3 Comments

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Summit 2013.  The abstract is below.  It was a packed room with many people having to stand.  Maybe next year I’ll get a bigger room  I hope … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Data Warehouse Maturity Model

I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into one area and talk about the Data Warehouse Maturity Model.  The graphic below, from Wayne Eckerson, is very accurate based on my … Continue reading

Posted in Data warehouse, SQLServerPedia Syndication | 1 Comment

Does Business Intelligence equal Data Warehousing?

I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably.  In reality, these are two separate disciplines. This is especially true for enterprise data warehouses due to an EDW’s scope, complexity, and large volumes … Continue reading

Posted in Business Intelligence, Data warehouse, SQLServerPedia Syndication | Leave a comment

Data Warehouse vs Master Data Managment

Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM).  Below is a good list of how they differ.  Note the typical scenario is the data in a MDM database is fed into … Continue reading

Posted in Data warehouse, MDS/MDM, SQLServerPedia Syndication | Leave a comment

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the Houston Area SQL Server User Group Monthly Meeting.  The abstract is below.  I hope you enjoyed it! Here is the PowerPoint presentation: Building an Effective Data Warehouse Architecture Building … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter.  The abstract is below and the recording of the session will be available soon here.  I hope you enjoyed it! Here is the … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | 1 Comment

Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals Virtual Chapter.  Info about watching the presentation online is here, and the abstract for my session is below.  I hope … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | 2 Comments

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for 24 hours of PASS, PASS Summit Preview.  The abstract is below and the recording of the session is available here.  I hope you enjoyed it! Here is the PowerPoint … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment