To add another technology than VBA- try implementing Metabase. With that the end users can get data fast and easy. Even Analysts can work with it since it supports native SQL.