“What is the sales value in this month? What is the increased percentage compared with the previous month? Which sales persons are among the top 10?” – The similar data analysis is mostly required in the sectors like commerce, finance, government, and scientific research. SQL usually is the only choice for such kind of analysis.

As a query language initially developed in early 70s, SQL has a relatively higher technical requirement on analysts. Lacking of…

Reporting tool is good at chart & form design, style of landscaping, query interface, entry & report, and export & print. It is one of the tools that are applied most extensively. However, there are quite often complex computations in the report, which raises a very high requirement for technical capabilities of report designers, and is one of the biggest barriers in report design. This article will introduce to ways to solve the complex computations in the report.…

Definition

Interactive analysis is a cycle analysis procedure of assumption, validation, and adjustment to achieve the fuzzy computation goal.

The interactive analysis is the real on-line analysis to solve the complex computation problem in the real world, and it is one of the key points in the business computation.

Example of Case

Let us explain the interactive analysis with a common example in the…