Check out an article in The Architecture Journal by Ken Withee.
Increasing Productivity by Empowering Business Users with Self-Serve BI
Ken Withee
December 2009 Issue
Summary: Enabling end-user self-serve business intelligence (BI) is a critical step in modern business. The latest wave of Microsoft products enable self-serve BI by using tools and technologies such as Office SharePoint, PowerPivot, Business Connectivity Services (BCS), Office Excel, and Report Builder.
