I have often found myself in the past facilitating groups of less experienced individuals in building data warehouses.
One thing I have found the most challenging was trying to convince some of those involved that the way they wanted to do things was not the best way. For example ignoring some of Kimball's basic guidelines such as snowflaking when it's not necessarily required, making everything type 2 scds as no one wants to spend time doing the analysis or doing it this way 'because that's the way we've always done it'
Unfortunately the people offering up these things are the ones who have been at the company the longest and have the loudest voice!
Sometimes though it is difficult to find a specific reason why you shouldn't do something one way over another. Often these are the fundamentals seasoned dw developers take for granted and are never brought into question.
Have you guys had similar experiences? And if so what have you found is the best strategy to adopt in these scenarios?