I disagree with #9. Maybe Bill was on vacation, broke his arm and stayed in hospital for a full month. Of course he's underperforming.
The data is there for you to query. There should be pointers to begin with, but the software should never make business decisions for you.
If the business analyst needs an hour to find the data, then the interface is too complicated, or the analyst did not learn how to use the software in the first place.
Please don't make me write software that can replace your business analyst.