While it's true some DW are more complicated to build (I hear "3
months to getting any new data in it" a lot) and they are largely
overnight batch, etc., the solution may be to fix those items with
a modernization process. I've see a lot of throwing the baby out
with the bathwater from organizations that seem to link the data
warehouse to its problems and go with an alternative (i.e., Hadoop)
that may fix a problem out of the gate, but maybe adding some
process around the warehouse and/or doing ETL a different way for a
new feed (i.e., real-time streaming) is best.
Others are doing things all sorts of ways and they tend to put
the best front on whatever they're doing, but I see the true
effectiveness of actions, sometimes down the line, and I would not
want to follow too many out there. Most organizations are maturity
level 1 or 2 with data and all need to be a 3 to survive the next
Some warehouses are too far down a legacy path and need to stay
in a contain mode, but I advise not to go there too quick. Think
out of the box and you might see more value there. Also when adding
around a legacy warehouse that is in contain mode, it's not out of
the question that another data warehouse shouldn't be built - to a
higher standard (i.e., cloud, real-time, agile, etc.) of course!
The DW idea is a strong one.