The Analyst client, Information Designer, and Administration Tools should be better integrated. There needs to be more productivity featured added. Here are some examples of features that would make authoring and troubleshooting much easier and less cumbersome:
Easier way to modify column data types and column names.