Query Wizard

Query Wizard is the easiest way to obtain Statistics, and Decision Rules or Decision Trees in a few steps. The wizard can be started by pressing "Query Wizard" button or selecting a corresponding menu item in the "Query Forming" menu.

Note: All controls, displayed within the wizard are also placed all together on the "Manual Query Creation" page.

 

Step 1. Class/Examined Field Selection

  
  • "Class/Examined Field Selection" list - a list of fields from the table, currently selected on the Data Set Input page. Determine the Class field by selecting a field from the list. It is recommended to select fields, containing the most important data. For example: it could be a field, that contains information marking loyal or fraudulent customers, some important financial data.

Step 2. Class Values Settings

  
In case if the type of the selected Class/Examined Field is:
  • Integer(Small Integer, Byte)
  • Text
  • Logical

the corresponding page will be shown. All Classes will be displayed in the "Classes List" control. Select Classes  for analysis from the list of detected Classes.

Total number of Classes is shown below the "Classes List".
If the type of the selected Class/Examined Field is float (for example - "Cash"), you will be asked to create Classes manually with the help of "Float Classes Creation" controls.

You can easily add, edit or remove Classes before their Creation, or recreate them in case if you've made some mistakes.

  • "From(min)" edit - put in the minimum value for the created Class.
  • "To(max)"  edit - put in the maximum value for the created Class..
  • "Add Class to the List" button - adds the values (from "From(min)" and "To(max)" controls) to the "Classes List".
  • "Classes List" control - displays the list of Classes to be created. The content of this control can be edited with the help of buttons on the right: "Delete from the List" and "Clear "Classes List"" buttons.
  • "Delete from the List" button - pressing this button will remove the selected Class from the "Classes List".
  • "Clear "Classes List" button - removes all Classes from the "Classes List".
  • "Create Classes" button - press this button to create the Classes you have inputed into the "Classes List". After this step the Query can be continued.

 

Step 3. Fields Selection
Next step is selecting the fields to be used for analysis. For example: if fields "Company Name" and "Address" are not selected, then no Decision Rules or Decision Trees will be created with the use of these fields.

It is important to mark fields, that might contain important information.

For example: "Company Name" field can be marked, but it is expected, that it will contain unique text values that do not correlate with other values. More important in this case are fields that contain economic data.

Step 4. Query Type Selection
Select the type of Query you want to process. It can be either Decision Rules or Decision Tree Query.

Step 5. Query Settings
Depending on the Type of the Query you have selected you will be asked to form Query Settings.

In case if you have selected Rules Query, the"Rules Query Settings"  page will be shown.

  • "Element belongs to class(%)" - input the probability for Decision Rules.
  • "Minimum number of cases for a Rule" - the rules, describing less than minimum  number of cases, will be ignored by the program.
  • "Float fields minimum value" - determines minimum float values that Estard Data Miner will use for the analysis.
  • "Create Full Rules" control - selecting this option will make Estard Data Miner to  find all Decision Rules, even if they partly dublicate each other.
  • "Create Minimized Rules" control - will make the program to perform Rules dublication analysis.
  • "Maximum Rules number for a Class" - this control allows to limit the number of created Rules. For example, if setting controls value to 10, the program will create no more than 10 Rules for each Class.

 
If you have selected Decision Tree Query, the "Decision Tree Query Settings" page will be displayed .

Decision Trees can be created in various ways.

  • "Build Automatically" control- mark it if you want the program to decide how to create the Decision Tree.
  • "Build Tree for Each Field" control - mark it if you want to recieve a Decision Tree for each Field, marked in the "Selection of Fields" control. Time, necessary to obtain Decision Trees is proportional to number of Fields used in analysis processing.
  • "Build starting with Field" control - mark it to create a concrete Decision Tree, strarting with the Field selected in the list below the control.
  • "Build a Single Tree"  - in case if some Classes were not defined after building the first Tree, Estard Data Miner will try to build a new Tree. Marking this control will make Estard Data Miner to create a single Decision Tree.
  • "Stop After defining All Classes" control - will stop Decision Trees creation in case if all Classes were defined.

Decision Tree Output Settings:

  • "Clear previous Trees before adding new ones" option - clears up the displayed Decision Trees before adding new Decision Trees.
  • "Add new Decision Trees to previously created"  - if some Decision Trees are displayed in the control on the "Decision Tree Output" page, they won't be removed when creating a new Tree.

Step 6. Finishing

 
Press the "Finish" button to start the data mining process.