Ranking Visualization Types by Data Fitness

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Users face difficulties in selecting the most suitable visualization type for their data sets due to a lack of knowledge about available options and optimal configuration, leading to frustration in data visualization with desktop productivity applications.

Innovation Solution

A desktop productivity application ranks visualization types based on their fitness for a particular data set using generated metadata and rules, presenting a user interface with ranked options and automated configuration, allowing users to easily select the best visualization type and avoid tedious configuration processes.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If a desktop productivity application provides many visualization types, then the versatility of data representation is improved, but the difficulty of selecting the appropriate visualization type increases

Engineering Contradiction:
Improvevisualization type optionsVSAvoidselection difficulty
Core Design Contradiction:
Adaptability or versatilityVSEase of operation

Solution Approach 1:

The system performs preliminary analysis of the data set characteristics (data types, relationships, distributions) before the user needs to select a visualization type. By pre-evaluating the data and pre-ranking suitable visualization types based on the data's inherent properties, the system eliminates the need for users to understand the nuances of many visualization types, thereby maintaining versatility while reducing selection difficulty

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system enables the data itself to 'select' the appropriate visualization type by automatically analyzing data characteristics and ranking visualization types based on fitness. The data's own properties (types, relationships, distributions) drive the selection process, freeing users from the burden of making informed choices among many options

Inventive Principle:
Principle #25Self-service

2Manufacturing precision

If the application asks the user to configure the visualization type, then the precision of data mapping can be improved, but the time and complexity of the process increases

Engineering Contradiction:
Improvedata mapping accuracyVSAvoidconfiguration time
Core Design Contradiction:
Manufacturing precisionVSLoss of time

Solution Approach 1:

The system performs preliminary data mapping automatically by analyzing data characteristics and matching them with appropriate visualization type requirements. It pre-configures the mapping between data columns and visualization elements based on data types and relationships, providing a ready-to-use configuration that maintains high mapping accuracy while eliminating manual configuration time

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system enables the data to self-configure the visualization by automatically determining how data columns should map to visualization elements based on data characteristics. The data's own properties drive the mapping configuration process, eliminating the need for user intervention while maintaining appropriate mapping accuracy

Inventive Principle:
Principle #25Self-service

3Ease of operation

If the application provides automated mapping, then the ease of operation is improved, but the precision of data mapping may deteriorate

Engineering Contradiction:
Improveconfiguration easeVSAvoidmapping precision
Core Design Contradiction:
Ease of operationVSManufacturing precision

Solution Approach 1:

The system incorporates feedback mechanisms where user selections and corrections are analyzed to refine the automated mapping algorithm. The system learns from user interactions with the visualization types and adjusts its mapping recommendations accordingly, maintaining high mapping precision while preserving ease of operation through iterative improvement

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS8677235B2Ranking visualization types based upon fitness for visualizing a data set
Publication Date: 2014.03.18 MICROSOFT TECHNOLOGY LICENSING LLC
  • US8677235B2 patent drawing
  • US8677235B2 patent drawing
  • US8677235B2 patent drawing

AI summary

Technologies are described herein for ranking visualization types. In order to rank the visualization types, visualization metadata is generated for each of the visualization types and data set metadata is generated for the data set. A suitability score is then computed based upon the visualization metadata and the data set metadata through the use of data mapping rules and chart selection rules. The visualization types are then ranked according to the computed scores. A user interface may then be displayed that includes visual representations corresponding to the visualization types that are ordered according to the ranking. One of the visual representations may then be selected to apply the corresponding visualization type to the data set.