You are not saying that the analysis and decision making should be automated each and every time, are you :w00t: ? Maybe you could possibly do that with the scripting...
Take a look at Stonefield Query, a powerful application to extract intelligent management information from your company's databases. I use it all day and it is a dream to work...