Systems and methods for processing data to identify relational clusters

A system for generating and displaying a predictive analysis, the system including:

• at least one data storage device that stores instructions for generating and displaying a predictive analysis;
• and
• at least one processor configured to execute the instructions to perform operations comprising:
• receiving prior event data, the prior event data comprising a plurality of fields, the plurality of fields corresponding to a plurality of columns and a plurality of rows;
• determining column field value correlations between the plurality of fields in the plurality of columns;
• determining a first column of the plurality of columns with a column field value correlation beyond a predetermined threshold with a second column of the plurality of columns;
• determining and filling in at least one missing field value of the plurality of fields in the first column based on at least one completed field value of a corresponding row in the second column to generate infilled prior event data;
• determining whether any of the infilled prior event data is not in a predetermined format;
• in response to determining that the infilled prior event data is not in a predetermined format, normalizing the infilled prior event data in accordance with the predetermined format to generate a prepared prior event data set;
• determining a plurality of relational clusters, using the prepared prior event data set, each relational cluster corresponding to a plurality of related columns of the plurality of columns, wherein the related columns in each cluster of the plurality of relational clusters are associated with a column field value correlation beyond the predetermined threshold;
• receiving a request for a risk analysis for an individual;
• receiving user event data associated with the individual;
• determining, based on a relationship between the user event data and at least one of the plurality of relational clusters, the risk analysis for the individual;
• and
• after a predetermined period of time or after a predetermined event, determining an updated risk analysis for the individual, wherein the risk analysis and updated risk analysis comprise a rating of the individual for at least one indicator, the at least one indicator being determined based on at least one of the plurality of relational clusters.

A non-transitory computer-readable medium storing instructions that, when executed by a computer, cause the computer to perform operations for generating and displaying a predictive analysis, the operations comprising:

• receiving prior event data, the prior event data comprising a plurality of fields, the plurality of fields corresponding to a plurality of columns and a plurality of rows;
• determining column field value correlations between the plurality of fields in the plurality of columns;
• determining a first column of the plurality of columns with a column field value correlation beyond a predetermined threshold with a second column of the plurality of columns;
• determining and filling in at least one missing field value of the plurality of fields in the first column based on at least one completed field value of a corresponding row in the second column to generate infilled prior event data;
• determining whether any of the infilled prior event data is not in a predetermined format;
• in response to determining that the infilled prior event data is not in a predetermined format, normalizing the infilled prior event data in accordance with the predetermined format to generate a prepared prior event data set;
• determining a plurality of relational clusters, using the prepared prior event data set, each relational cluster corresponding to a plurality of related columns of the plurality of columns, wherein the related columns in each cluster of the plurality of relational clusters are associated with a column field value correlation beyond the predetermined threshold;
• receiving a request for a risk analysis for an individual;
• receiving user event data associated with the individual;
• determining, based on a relationship between the user event data and at least one of the plurality of relational clusters, the risk analysis for the individual;
• and
• after a predetermined period of time or after a predetermined event, determining, using the at least one processor, an updated risk analysis for the individual, wherein the risk analysis and updated risk analysis comprise a rating of the individual for at least one skill, the at least one skill being determined based on at least one of the plurality of relational clusters.