If Analysis workspace can have the ability to import data from excel or other databases, so I can directly display in the dashboard. This will be a big win for the analysts. Right now, I have the site performance data in Analysis workspace showing the trends that business wants to know. What is missing is the 'projected growth' which usually lives in some excel maintained by another team. Also, the 'spend$' lives in another excel. If I can marry all the 3 components- acutal, projects, spend, etc. that would be huge.
This will heavily decrease if not eliminate, the usage of yet another visualization tool like Tableau to do such reporting. The development process of taking data out of omniture, putting it into some sql database, making the connections in tableau and charting it, takes weeks. All this burden could be eliminated.