Re: Data mining tools

Jeff Swanberg wrote:

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

Hi Jeff

We have been using EasyQuery for many years and our users love it, they
do not need to know SQL, the tables are all linked via the pre loaded
data base structure which you get to define and ship with your
application.

We have not implemented a feature where you can define pre set
selections as a string and then this can be made part of the
application selection functions.

Have a look at http://devtools.korzh.com/eq/vcl/

Tom
.

Relevant Pages

  • Data mining tools
    ... tracks student performance across the district (grades, test scores, ... attendance, discipline, etc). ... I've looked at some of the SQL query tools out there but wanted to get some ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: compound primary key using calculated field
    ... INSERT INTO Grades (grade_description, age_limit_lower, ... INSERT INTO People (person_name, age) VALUES ... Dim sql As String ... .Execute sql ...
    (microsoft.public.access.tablesdbdesign)
  • Re: compound primary key using calculated field
    ... INSERT INTO Grades (grade_description, age_limit_lower, ... INSERT INTO People (person_name, age) VALUES ... Dim sql As String ... ..Execute sql ...
    (microsoft.public.access.tablesdbdesign)