PerformancePoint is a pretty good dashboarding tool, but I believe requires Sharepoint. If you are going to be using 2012 you might also want to look into PowerView. It is considered a data visualization tool, not sure if it is what you want but it might be worth a look.