The importance of Excel 2010 in conjunction with SQL Server 2008 R2 lies in the PowerPivot feature that incorporates extensive column compression technology named “VertiPaq”.

Master Excel's Power Query, Power Pivot, and DAX to transform data, ... For example, you can use Power Pivot to integrate sales data from a SQL database with customer demographics stored in Excel.