Check out my EasyMorph (http://easymorph.com). It's a hybrid between data prep and ETL -- you manipulate data interactively, yet it can work as an automated workflow. You can even build custom data profilers with it, tailored to your particular metrics of interest.