Category Archives: Data warehouse

Presentation slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” for Pragmatic Works last Thursday.  The abstract for my session is below and the recording is available here.  I hope you enjoyed it. Here is the PowerPoint presentation: Modern Data Warehousing Modern Data Warehousing The … 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” at the PASS Business Analytics conference.  The abstract is below.  I hope you enjoyed it! Here is the PowerPoint presentation: Building an Effective Data Warehouse Architecture Building an Effective Data Warehouse Architecture … Continue reading

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

Hadoop and Data Warehouses

I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution.  Hadoop should not be a replacement for a data warehouse, but rather should augment/complement a data warehouse.  Hadoop and a data warehouse … Continue reading

Posted in Data warehouse, Hadoop, PDW, SQLServerPedia Syndication | 2 Comments

Presentation Slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas.  The abstract is below.  Great turnout for the last session of the day! Here is the PowerPoint presentation: Modern Data Warehousing Modern Data Warehousing The traditional … Continue reading

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

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” on Saturday at the PASS SQLSaturday Business Analytics edition in Dallas at 4:30pm CST (info).  The abstract for my session is below.  I hope you can make it! Modern Data Warehousing The traditional … Continue reading

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

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