I hate to admit that I’m behind the curve in this area, but I just saw a demonstration of PowerView today and was very impressed.
Because we’re still on SharePoint 2010 and SQL Server 2008, it’s not available, so I guess that’s why I missed it. It requires SQL Server 2012. To put it succinctly in a short phrase, it’s a simple drag and drop BI interface. In the words of Microsoft, it’s “an ad-hoc visualization experience in SQL Server Reporting Services”.

I won’t waste your time here – – just go to:
http://www.microsoft.com/en-us/bi/Products/PowerView.aspx
There are several videos which demonstrate the power in PowerView..