Table-Based Visualization for Multidimensional Data Navigation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Displaying and navigating multidimensional business data in a two-dimensional user interface is challenging, as users often face difficulties in effectively visualizing and making decisions from large raw data tables that require scrolling and formatting across multiple screens.
Innovation Solution
A method and system for defining and generating customizable table-based visualizations of multidimensional data sets, allowing users to view data as a highly customizable table with various chart and representation options, including text, images, and charts, by selecting dimensions for the row scope and configuring column properties to display data content effectively.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If large raw data tables are displayed in traditional formats, then complete data coverage is achieved, but user navigation becomes difficult and time-consuming due to extensive scrolling across multiple screens
Solution Approach 1:
The patent introduces hierarchical organization and collapsible/expandable row groups that add a temporal and structural dimension to data display. Users can collapse unrelated rows to jump between data sections without scrolling through intermediate content, effectively adding a 'skip' dimension to navigation while preserving complete data coverage.
Solution Approach 2:
The patent segments large data tables into logically grouped rows with hierarchical structure. Related rows are organized into expandable/collapsible groups, allowing users to focus on specific segments of data without being overwhelmed by the entire dataset. This segmentation enables selective viewing while maintaining access to all data.
2Loss of information
If traditional table formats are used to display multidimensional data, then data completeness is maintained, but data comprehension and decision-making become difficult due to lack of visual context
Solution Approach 1:
The patent merges tabular data with visual elements by embedding images, icons, and graphical indicators directly within table rows. This combination allows users to comprehend data relationships and patterns at a glance while maintaining the complete structured data for reference and analysis.
Solution Approach 2:
The patent employs color coding, background shading, and visual highlighting to indicate data relationships, anomalies, and hierarchical structures within the table. These visual cues enable rapid comprehension of data patterns without altering the underlying complete data set.
3Loss of information
If data is formatted across multiple sheets and screens, then all data can be displayed, but user interaction and analysis become complex and inefficient
Solution Approach 1:
The patent creates a universal data view that consolidates multiple data sheets and screens into a single unified table interface. This universal view provides navigation, filtering, sorting, and visualization capabilities in one location, eliminating the need to switch between multiple screens while displaying all relevant data.
Solution Approach 2:
The patent introduces an intermediary hierarchical structure with expandable/collapsible row groups that mediates between the user and the complete data set. This intermediary layer allows users to navigate large datasets efficiently by expanding only the sections of interest while maintaining access to the complete underlying data through the unified interface.
Data Source
AI summary
A method, system, and computer-readable medium to define a row scope for a table-based visualization of the multidimensional data set, the row scope specifying a number of dimensions of the multidimensional data set; selectively define at least one data selection of the multidimensional data set to connect to the defined row scope to be visualized in the table-based visualization; and generate an instance of the table-based visualization based on the defined row scope and the defined at least one data selection.