External Data Mashup
Some of the most challenging data warehousing situations come in the form of external data mashups. Because the term “data mashup” has taken on a
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