If you are designing a data warehouse, you need to map out all the areas where there is a potential for your project to fail, before you begin.
Conclusion
A data warehouse can fail even before you begin designing. If the foundation for your data warehouse is flawed, then your business intelligence can't be reliable. By looking to the future for your design, having the correct team, protecting the integrity of the metadata layer and prioritizing speed over visual appeal, you can create an almost flawless data warehouse design.