3D Conditional Formatting for Tabular Data Visualization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional systems for data analysis are inefficient and require manual, multi-step processes, making it difficult for users to perform rapid and effective data manipulation and visualization, especially in handling complex data analysis tasks, which often leads to a disconnect between users and the data resources they interact with.

Innovation Solution

A system that enables three-dimensional conditional formatting and automatic visualization of tabular data, allowing for animated presentations and the creation of scenes to facilitate storytelling with data, thereby enhancing user interaction and understanding through three-dimensional chart-based visualizations.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If manual and multi-step input processes are used for data manipulation and visualization, then users can perform detailed data analysis, but the process becomes time-consuming and inefficient

Engineering Contradiction:
Improvedata analysis efficiencyVSAvoidtime for manual operations
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The system pre-configures visualization templates and data connection settings before users need them. When users select a template, the data sources, chart types, and formatting options are already prepared, eliminating the need for manual step-by-step configuration and significantly reducing the time required for data analysis tasks.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system automatically connects data sources to visualizations and adjusts parameters based on user selections without requiring manual intervention. The automated data connection service performs tasks such as data retrieval, transformation, and chart generation autonomously, freeing users from time-consuming manual operations while maintaining high productivity.

Inventive Principle:
Principle #25Self-service

2Adaptability or versatility

If conventional query platforms are used, then basic data retrieval is possible, but they cannot meet expansive and growing data analysis needs of modern users

Engineering Contradiction:
Improvedata analysis capabilityVSAvoidsystem functionality
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system provides a single visualization template that can adapt to multiple data sources and analysis scenarios. By making the template universally applicable across different data types and analysis needs, the system expands its versatility without proportionally increasing complexity, allowing users to perform diverse data analysis tasks using the same interface.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The system separates the complex data analysis functionality into modular components: pre-configured templates handle common analysis patterns, while users can selectively activate specific data sources and visualization parameters. This segmentation allows the system to offer extensive adaptability for different analysis needs while keeping the user interface simple and manageable.

Inventive Principle:
Principle #1Segmentation

3Productivity

If automatic data connection service is implemented, then data retrieval efficiency improves, but system complexity increases

Engineering Contradiction:
Improvedata retrieval efficiencyVSAvoidautomation infrastructure
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The system introduces an intermediary automatic data connection service that acts as a bridge between users and complex data sources. This intermediary handles the complexity of data retrieval, transformation, and connection management automatically, providing users with simple template selections while maintaining high data retrieval efficiency. The intermediary absorbs the infrastructure complexity away from the user-facing interface.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS10067635B2Three dimensional conditional formatting
Publication Date: 2018.09.04 MICROSOFT TECHNOLOGY LICENSING LLC
  • US10067635B2 patent drawing
  • US10067635B2 patent drawing
  • US10067635B2 patent drawing

AI summary

Three dimensional, conditional formatting based data visualization is provided. Received underlying data may be analyzed and one or more portions of the underlying data that are of interest to a user determined. The portions may be selected actively by a user of automatically determined based on a variation of values in each portion, values of data points in each portion, a usage history of the user, and/or a credential of the user. A background image may be generated by converting the tabular data into a three dimensional image or selecting and image or a graphic associated with the underlying data. The visualization(s) may then be displayed over the background. Scenes may be selected for animated slide shows or movies.