SQL Server 2014 Has Arrived!
Like many of you I have been waiting for SQL Server 2014 to be released to market for quite a while. Now that it has
Don’t Miss These Critical ETL Considerations
Anyone who has been involved with data warehousing knows that there are plenty of things that can go wrong. Mistakes can be made when researching
Dealing with Deletes in the Data Warehouse
Data warehousing has a clear set of objectives such as data persistence, single easy to navigate data model, fast query performance, etc… While it is
Why Dimensional Modeling?
In a requirements gathering session I was asked a question that I should have knocked out of the park. A subject matter expert asks, “Why
6 Source System Data Mart Built in 2 Days
Over the past few weeks Alan & I have had the pleasure of working with a small team to build an AR data mart. The
TDWI Conference – Agile Data Warehousing 101
I’m happy to be attending the TDWI Agile BI conference in San Diego this week. Today, Sunday, kicks off a series of great learning sessions.
How to Avoid Business Intelligence Catastrophe – Part 1
Part 1: Start from a Data Driven Culture This is the first in a series of posts about the often-overlooked elements of successful BI. Why
Planning Poker & Data Warehousing
Teams that choose to take an agile approach to data warehousing will be faced with a planning meeting at beginning of each iteration. The goal
Forget about Tools. Agile DW Means…
Agile software development has become the preferred methodology of countless teams worldwide. The principles behind the agile manifesto serve as the rule book for those of us
ETL Design Patterns – The Foundation
Data warehouses provide organizations with a knowledgebase that is relied upon by decision makers. ETL (extract, transform, load) is the process that is responsible for