If you are not already looking at PowerPivot from Microsoft for Business
Intelligence now is the time to start. PowerPivot is designed to support end
user/power user BI, including millions of records, from inside of Microsoft
Excel. It works great with Dynamics GP tables, views or analysis cubes as a data
source. Even better, it’s free.
PowerPivot required Microsoft Excel 2010 at a minimum and gains even more
power with SQL Server 2008 R2 and Sharepoint PerformancePoint Services. If you
need a compelling reason to start upgrading to Excel 2010, this is it.
You can find out more about PowerPivot and Dynamics GP here. The main PowerPivot page to
download from is http://powerpivot.com/.