Below is a 40 minute video going through all the new features coming up in the new Q2 Service Update or the CRM big update as I like to refer to it.
The video goes through the new mobile functionality, which looks very good and I really like the way you can quickly call or email contacts. Below is a screenshot of the new mobile client
The demo also goes through the new multi browser functionality.
The activity feeds have been improved and the new filter functionality seems very useful.
The video goes through harnessing SQL Server 2012 which is available at the moment and it mentions the online data centres already use SQL 2012.
Importantly it does view powerview, which is the new BI tool. This is something I am very interested in and it explains powerview (which is a sharepoint added) does allow you to create Excel cubes of information.
There is a demo of Powerview which starts at minute 24 minutes.