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/.