Systems and methods for visualizing one or more datasets

A system comprising:

• a processor;
• and
• memory storing instructions that, when executed by the processor, causes the system to perform a set of operations, the set of operations comprising:
• obtaining a joined dataset based on a plurality of root objects, that comprises, for each of the plurality of root objects, a plurality of rows of related attribute data linked to each root object as a result of a join operation, each root object of the plurality of root objects comprising a join cardinality;
• providing a user interface to present aggregation type selection data that allows a user to select one or more aggregation types from a plurality of different types of aggregation operations to apply to the plurality of rows of related attribute data;
• performing an aggregation computation of the one or more selected aggregation types on the plurality of rows of related attribute data corresponding to each root object of the plurality of root objects to produce a corresponding single aggregation row of consolidated data for each root object, the consolidated data comprising an average of the plurality of rows of related attribute data corresponding to each root object or a first attribute data from the plurality of rows of related attribute data appended next to a second attribute data from the plurality of rows of related attribute data;
• and
• causing presentation of the user interface that presents each root object of the plurality of root objects with the corresponding single aggregation row of consolidated data resulting from the aggregation computation, the plurality of root objects being ordered on the user interface based on the join cardinality of each root object of the plurality of root objects,
• wherein at least one of the one or more selected aggregation types comprise a concatenation operation, the concatenation operation comprising appending the first attribute data to the second attribute data, and the consolidated data comprising the first attribute data from the plurality of rows of related attribute data appended next to the second attribute data from the plurality of rows of related attribute data.

A non-transitory storage medium comprising executable instructions that when executed by a processor cause the processor to:

• obtain a joined dataset based on a plurality of root objects, that comprises, for each of the plurality of root objects, a plurality of rows of related attribute data linked to each root object as a result of a join operation, each root object of the plurality of root objects comprising a join cardinality;
• provide a user interface to present aggregation type selection data that allows a user to select one or more aggregation types from a plurality of different types of aggregation operations to apply to the plurality of rows of related attribute data;
• perform an aggregation computation of the one or more selected aggregation types on the plurality of rows of related attribute data corresponding to each root object of the plurality of root objects to produce a corresponding single aggregation row of consolidated data for each root object, the consolidated data comprising an average of the plurality of rows of related attribute data corresponding to each root object or a first attribute data from the plurality of rows of related attribute data appended next to a second attribute data from the plurality of rows of related attribute data;
• and
• cause presentation of the user interface that presents each root object of the plurality of root objects with the corresponding single aggregation row of consolidated data resulting from the aggregation computation, the plurality of root objects being ordered on the user interface based on the join cardinality of each root object of the plurality of root objects,
• wherein at least one of the one or more selected aggregation types comprise a concatenation operation, the concatenation operation comprising appending the first attribute data to the second attribute data, and the consolidated data comprising the first attribute data from the plurality of rows of related attribute data appended next to the second attribute data from the plurality of rows of related attribute data.