For many years now, I have urged readers to stay away from a "turn key" data warehousing solution. Throughout most of data warehousing history, the turn key data warehouse solution was a myth, and it pretty much still is today.
The truth is that without integrating your own data from multiple sources, without building the right data model and without understanding the requirements for your queries, your warehouse is useless. However, what has become much more "turn key" is the underlying platform for data warehousing. That's right, the "out of the box" data warehouse complete with database, storage, processors and systems management is a growing market.
The concept of the data warehouse in a box is not a new one. First, there was Red Brick that was really the first commercial data warehouse in a box, and then there is Teradata, which of course is the modern day version of the all-in-one data warehouse platform. Teradata has been hugely successful, as the "real" data warehousers have mainly used Teradata as the underlying platform due to its performance, scalability and lower TCO. While a separate data warehouse platform will create yet another platform to manage, there have been obvious benefits to deploy a totally integrated platform like Teradata.
For many years, Teradata was the only game in town around a unified data warehousing platform, but two key trends