I am working as a consultant in the field for some time. The approach what I found that works very well is to create a BI org that is driven by the business needs and only have data for what you actually need.

Less is more.