User friendly solutions now exist that allow end users the ability to gain real time insight into their data.  SAP & Business Objects has the whitepaper below which discusses some options including their new Polestar end user product.

Business Intelligence