Small Business Needs
"bringing all of the complexity and technical overkill with them"
I think this is already happening, I work for a small company which employs around 15 people. Yet our internal BI system has 2 full time programmers working on it, and we've just installed a cluster of 8 very high end servers to process all the data. Admittedly we're not your everyday company, but as companies become more niche I can only see this trend growing.
Our biggest challenge is working with data in so many formats, it seems every different company we work with offers their data in its own unique format and each require there own custom handling code (so the slightest change can cause the biggest headaches) - the panacea which XML and Webservices promised has never materialised, while it improved data-interchange it also brought a raft of new problems and now we have the added layer of SOA.
The whole idea of interchangeable data and warehousing needs to be rethought out and simplified, a starting point would be to get all the biggest API providers to standardise their systems and report formats.