What is a data warehouse?
What exactly is a data warehouse? Why create a data warehouse? This short video provides non-technical answers that are easily understood by anyone.
Now Hiring ETL Developers – $7.25 per hour
We have all seen the job postings. “Immediate hire… ETL developer with 10 years’ experience.” Regardless of fast changing technologies there will be a need
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 oft -overlooked elements of successful BI.