Written by Ashvini Sharma, Principal Program Manager Lead, Microsoft Corp. SQL Server 2008 R2 empowers business users to create and share rich, compelling BI solutions through familiar tools such as Excel 2010 and SharePoint 2010. While we’ve mentioned PowerPivot in the past, this post describes the overarching themes.