Data analyzing device and data analyzing method

A data analyzing device which receives an input of tables of analysis target data including a plurality of attributes, defines a relation between the tables by specifying one attribute respectively for the tables, receives a selection of an objective variable being predicted, and generates a prediction model for predicting the objective variable using at least one attribute of the tables, the device comprising a processor in communication with a memory, the processor being configured to execute instructions stored in the memory that cause the processor to:

• recognize whether a type of an attribute value of each attribute of the analysis target data is a numeric type indicating that it is a numeric value or a category type indicating that it is a category,
• set at least one attribute of an aggregation unit that is used to define the relation between the tables, the attribute of the aggregation unit being recognized as the category type,
• set at least one attribute of an aggregation target, the attribute of the aggregation target being recognized as the numeric type
• aggregate, for each category value of the attribute of the aggregation unit, a numeric value of the attribute of the aggregation target based on a previously prepared aggregation function to generate a plurality of new objective variable candidates, the plurality of new objective variable candidates not being included in the attributes of the tables and being generated by using the attribute of the aggregation unit that is used to define the relation between the tables,
• display the plurality of new objective variable candidates,
• receive a selection of one new objective variable by a user from among the plurality of displayed new objective variable candidates, and
• generate a new prediction model for predicting the selected new objective variable.