I did a post on the new features in Excel / Excel Services 2010 from a BI point-of-view but notice that people also want to know this for SharePoint 2010. So apart from the Excel Services improvements which are mentioned here let me try to give you an overview of the other additions. to SharePoint 2010
If you feel like decorating your wall with something nice you can find a poster with the BI services in SharePoint 2010 at http://blogs.msdn.com/b/performancepoint/archive/2009/10/30/new-business-intelligence-services-in-sharepoint-server-2010.aspx.
As you know Visio has been an interesting tool to visualize many things and even with connectivity to backend information. Just like Excel with Excel Services we have extended Visio to come with a Visio Services capability. More information Visio Services can be found at http://blogs.msdn.com/b/visio/archive/2009/10/30/introducing-visio-services.aspx
Of course there are some important changes to PerformancePoint Server too, it is now known as PerformancePoint Services and really is part of SharePoint. This means no more separate installation required, it’s just there like Excel Services and all other SharePoint Services. So what exactly has changed in PerformancePoint Services? My friends from the PerformancePoint team have made an excellent blog post on the changes at http://blogs.msdn.com/b/performancepoint/archive/2009/11/05/new-features-in-performancepoint-services-2010.aspx. I know it is mentioned in the previous post but you should definitely look at the new “Decomposition Tree” at http://blogs.msdn.com/b/performancepoint/archive/2009/11/19/decomposition-tree-contribution-analysis-presentation.aspx.
We have built-in support for upgrading PerformancePoint Server 2007 to PerformancePoint Services 2010. An explanation of the options can be found at http://blogs.msdn.com/b/performancepoint/archive/2010/02/25/upgrading-performancepoint-server-2007-to-pps-2010.aspx.
Additionally we also improved the install experience of Reporting Services in SharePoint integrated mode and it is the reporting platform for Access Services. Please check http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/reporting-services-in-sharepoint-2010-access-services.aspx for more information on this.