I just completed an MSDN article that focuses on making the Excel Services experience more like the Excel client experience when importing two-dimensional data for analysis. The idea was to provide similar capabilities in Excel Services for importing, analyzing, and displaying imported data. If you're looking to use Excel Services as a reporting platform or as the basis for dashboards, check out this article.