[Update 9/3/11 - both charts have been edited to reflect Derek's input (see comments)]
I've been wanting to share this SharePoint resource for a while: two different views of the options for Business Intelligence / Data Visualization on the 2010 platform. Both views break down the options in terms of dataset size and dynamic vs. static presentation; you can choose the format that works best for you:
My thanks to Chris McNulty, whose matrix of different BI options in SP 2010 provided the seed for these visualizations (the matrix can be seen on slide 28 of our joint presentation "See Beyond The Numbers"), and to Matt Jackson, who suggested the quadrant view and provided input on both views.
As always, I welcome feedback and suggestions.