Data mining tools

I've been tasked with adding "data mining" capabilities to our app that
tracks student performance across the district (grades, test scores,
attendance, discipline, etc).

They would like it to be somewhat graphical in nature and be able to be
used/understood by people from school board members to the classroom teacher
so no SQL syntax, no creating the joins between tables, etc. Those I would
need to create underneath. Basically they want a tool where a person could
ask "Show me all of the 9th grade male Asian students that didn't do well in
math and had more than 10 absences during the year".

I've looked at some of the SQL query tools out there but wanted to get some
feedback on what people have used and what your experience has been. Since
I have a particular need perhaps I should just code this myself?

js


.