Here is a post on one of the coolest BI features in SQL 2012. Power View !!! Leverages BI Semantic Model (BISM). Very Cool!

http://channel9.msdn.com/posts/SQLShorts-SQL-2012-Power-View-on-SharePoint-2010