Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Simplified Data Calculation Editor with Building Blocks for Business Users

IP.com Disclosure Number: IPCOM000238392D
Publication Date: 2014-Aug-22
Document File: 8 page(s) / 252K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a visual approach to simplify data calculation in self-service business analytics applications for business users. Calculations are composed of building blocks, modules, or slots that can be replaced by data columns, functions, and constants.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 01 of 8

Simplified Data Calculation Editor with Building Blocks for Business Users

Self-service applications are a current trend in the business analytics field. Business users want to be able to navigate the data and quickly find answers to questions without the help of analysts and information technology (IT) personnel. When analyzing data, in particular, users may need to perform calculations. However, many expression editors in business analytics (BA) tools are very complex. Some use terminology and syntax that intimidate and confuse users who do not have a technical background .

Current applications do not enable calculation involving both data columns and visualizations.

The novel contribution is a visual approach to simplify data calculation for business users. With this approach, calculations are composed of building blocks, modules, or slots that can be replaced by data columns, functions, and constants. Values from a calculation step are reused in other steps so that complex calculations are broken down into a series of simple steps . Links between values indicate that changes in one end affect the other end . The level of complexity is gradual and adjusted by the user. The more steps and links the user creates the more complex the calculation becomes . No specific syntax or parentheses are used. The editor enables calculations with data columns and in visualizations.

Following are the components and process for implementing the visualization solution in a preferred embodiment .


1. Building blocks comprise the calculation editor; each slot type has a unique visual identity

Figure 1: Building blocks, each has a unique visual identity

1


Page 02 of 8

A. The result of the calculation is a new column, which the system adds to the data table

B. A and B can be replaced by a data column, a function, a number or a text, or a value from a previous calculation step


C. + can be replaced by other operators such as -, *, and /

D. The 5 allows the user to add slots to the calculation

2. Assign a name to calculation

A. User taps on the Ente...