Interactive Drilldown Analysis for Business Intelligence Data
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Business intelligence systems require users to manually combine and modify analytical steps for complex data analyses, leading to time-consuming and inefficient processes, as users need to retrace and propagate changes across multiple steps.
Innovation Solution
A data analysis framework that allows users to select and sequence analytical functions as 'chips' to apply to business intelligence data, with the ability to limit subsequent functions to selected data points, modify functions based on selections, and display results in a user-friendly interface, enabling efficient modification and recall of analysis paths.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If users manually combine and modify analytical steps for complex data analyses, then the analysis can be performed with flexibility, but the process becomes time-consuming and inefficient
Solution Approach 1:
The system automatically records and stores the sequence of analytical steps and their parameters as the user performs them. This preliminary recording action enables the system to automatically retrieve and reapply the entire analysis sequence without requiring the user to manually retrace steps, thus resolving the time loss while preserving flexibility through programmable automation
Solution Approach 2:
The system creates a digital copy or representation of the analysis path (sequence of analytical steps) that can be stored, retrieved, and modified independently. This copying mechanism allows users to save their analysis sequences and reuse them, eliminating the need to manually reconstruct analyses and reducing time loss while maintaining adaptability
2Stability of the object's composition
If users manually propagate adjustments or modifications to one analytical step to other steps, then consistency across the analysis is maintained, but the process becomes burdensome and inefficient
Solution Approach 1:
The system implements automatic feedback mechanisms where changes to analytical steps are automatically detected and propagated to dependent steps. The system monitors the analysis path and automatically updates subsequent steps when modifications are made, maintaining consistency without requiring manual intervention from the user
Solution Approach 2:
The system performs self-service by automatically managing the propagation of modifications across analytical steps. When a user modifies one step, the system autonomously identifies affected downstream steps and applies necessary updates, eliminating the manual burden while ensuring consistency across the entire analysis
Data Source
AI summary
Analytical functions to be applied to business intelligence data may be sequentially selected from a set of chips, each corresponding to a different function. A function associated with a selected chip may be applied to the business intelligence data and the selected chip may be added to an analysis path with other selected chips in a sequential order of selection. A result, which may include at least two selectable data points, may be displayed. Once a data point selection is made, the selection may be used to limit the functions associated with subsequently displayed chips to the selected data points. The chips listed in the analysis path may be used to change prior data point selections, the changes of which may be automatically propagated to any subsequently selected chips as indicated in the analysis path.