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

    http://channel9.msdn.com/posts/SQLShorts-Installing-and-Configuring-PowerPivot-Power-View-and-the-BI-Semantic-Model--BISM-     This video covers the main issues that you face in installing PowerPivot and Power View on SharePoint...