I have worked on a number of data warehousing, business intelligence and analytic projects over the last 20 years. Some have been a resounding success and some of the others while they delivered a successful outcome, they never felt like they were delivered well.
I spent a bit of time trying to determine why.
One of the reasons for success has been dependent on the team that is doing the work. Often the really successful projects would have a strong experienced team lead, who had done many similar projects before.