# Interactive Analysis and Related Tools

View: 834    Dowload: 0   Comment: 0   Post by: hanhga   Category: Development Tools   Fields: Education - Schools

### Example of Case

Let us explain the interactive analysis with a common example in the business activities.

### Step 1 Set the Goal

Why the sales volume this month greatly exceeds that of the previous month?

Obviously, this is a fuzzy computation goal with several possible answers. You cannot get the result directly using any analysis mode.

### Step 2 Guess the Possible Branch

Since there are several possibilities to give rise to the sales volume increase, the analyzer has to check every possibility, such as:

• Orders numbers increase
• Appearance of large orders
• Intensive consumption of specific customer base, for example the intensive screening the movies of children in the summer holiday
• Improvement of process
• Launching a marketing campaign
• ...

Obviously, a certain level of business knowledge is required to make these assumptions and the keen sense of smell to the circumstances inside and outside the enterprise. This is a relatively personalized effort.

### Step 3 Branch validation

Based on the possibility and characteristics of data, the analyzer will choose a branch to start the analysis, such as Increase of Orders. If the number of orders does not increase through the calculating for validation, then it indicates that this assumption is not correct. You need to validate the next assumption to carry on the cyclic analysis.

For example, by going through the validation on this branch of Appearance of Large Order, the analyzer finds this is correct, and thus this branch can be justified.

### Step 4 In-Depth Exploration and Mining

These possibilities are usually the apparent cause instead of the root cause. To really settle the problem, you will have to drill down step by step to reach the core. For example, the appearance of large order may result from:

• The new salesmen is highly capable
• The new sales policy of the company boosts the large order
• Intensive procurement of clients from a certain sector...

It is obvious that the process of drill-down is a cyclic procedure. The analyzer must judge on the characteristics of data at that specific point to choose the branch of the highest possibility, so as to progress level by level, until the problem is solved.

### Step 5 Solve Problem

The procedure of exploration and mining does not require the unlimited drilling down. The whole procedure can put an end once a clear answer enough to make a decision is found. For example, through the validation, the Centralized Procurement in a Certain Sector is determined just the root cause. Then, this is enough for analyzer to make a decision: The sales volume can keep rising by simply beefing up the sales forces and efforts in this sector since the recent sales rise is the result of centralized procurement by the clients in this sector.

### Step 6 More Computations

To this step, the computation goal is achieved. However, we can realize more business values through more computation on the basis of the existing results, such as:

• Find the list of customers in this sector
• Find the list of salesman which are good at this sector
• Find the reason why the client in this sector increase the procurement quantities abruptly
• Find the abnormal actions in the sector related to this sector and the downstream/upstream sector

### Characteristics

As we can see from the above examples, the real world is far more complex than the theory. The commercial opportunity changes unpredictably and comes and goes in a moment of doze. In fact, the computation on the business activities is usually fuzzy. There are few model algorithms from textbook that can be used to solve the real situation. The analysis computation is to solve the problem in the real world. They are characterized with the following points:

### Fixed algorithm as bottom layer

Interactive analysis can be always resolved to the fixed algorithm. For example, ranking algorithm is usually used to compute the "Appearance of Large Order"; grouping algorithm is usually used to compute the "which sector sees the intensive procurement by clients".

### Focus on the Interactive Procedure

The bottom layer of interactive analysis is the fixed algorithm though, the human intervention is necessary. How to break down the target? How to set the priority of branches? Whether to carry on the mining or not? Is the existing result enough to support the decision-making? Is the further computation necessary? Theoretically speaking, the power enough computer programs can implement the above network-like branches, and thus turn it into the fixed algorithm. However, before the The Matrix and Neo born, the analyzers will have to take great effort in it.

### Focus on the Business Expert

Interactive analysis is to solve the problem in the real world. The assumption will have to make on the basis of business status, and the next step computation will be decided on the current data and business experiences. To do this, the abundant business knowledge is required. The qualified analyzer is usually the business expert. The database administer and programmer are more fit to seek the solutions to the fixed algorithm and they are able to provide the assistance in computation but hard to make the most important business decision.

### Take Massive Structural Data as the Primary Goal

The massive structural data is the data capable to be represented with a 2-dimention structure. Of the massive structural data, the typical examples are the data from database and spreadsheet, and text file. In the business activities of real world, these data are the most common and fundamental, acting as the base of business calculation.

### Requirements on Analysis Tool

Characteristics of interactive analysis determine its requirements on computation tool:

• Abundant library function or fixed algorithm
• Provide a convenient interactive procedure
• Support massive structural data

### Common Tools for Interactive Analysis

Based on the requirements on the interactive analysis tool, we can list some common tools, just name a few:

There are many other tools for interactive analysis. However, one point to note is that none of them is perfect on all aspects. For example, the analyst may find that it is easy to grasp Excel but hard to compose SQL statements; esProc lacks of the non-linear model, but it can provide a convenient interactive process; SPSS boasts the abundant fixed algorithms but is not as convenient as SQL in relation query.

The tool suitable for your needs is the correct one. Please refer to the Comparison between Interactive Analysis Tools to join us on choosing the analysis tool suitable for your needs.

nteractive 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.

Posted on 20-03-2014

#### Comment:

To comment you must be logged in members.

## Files with category

• ### Architecture with Docker for Two-tier Application

Category: Development Tools     Fields: Other

In the IT Industry, separate Virtual Machine or the Container is used for single Tier. In the traditional Virtualization where on Hypervisor we create different Virtual Machines for each Tier, whereas in Docker Engine we create different...

• ### Turing: Another Take on Algorithm and Python Development

Category: Development Tools     Fields: Other

A cross-platform algorithm/pseudocode and Python development environment with debugging features

• ### Dissecting a Flutter app folder structure

Category: Development Tools     Fields: Other

In my last article, I mentioned the step by step installation guide about how to install Flutter with Android Studio on Mac as well as Windows.

• ### A Note on Unit Test Spring MVC Applications

Category: Development Tools     Fields: News - Media

This is a note on unit test Spring MVC applications.

• ### Creating a Cursor from a Font Symbol in a WPF Application

Category: Development Tools     Fields: Other

The code has been considerably updated to fix issues with the cursor since the initial version. The image in the cursor was not properly centered so that the actual size of the cursor was not close to the value that is specified in the call. The...

• ### Switch Type WPF ToggleButton/RadioButton (On/Off) Control

Category: Development Tools     Fields: Other

• ### Android Studio The Official IDE for Android

Category: Development Tools     Fields: none

Android Studio is the official Integrated Development Environment (IDE) for Android app development, based on IntelliJ IDEA . On top of IntelliJ's powerful code editor and developer tools, Android Studio offers even more features that enhance your...

• ### Changes in Programmer Tools' Infrastructure

Category: Development Tools     Fields: Other

The article describes some observations concerning changes in the infrastructure of tools used by programmers in everyday work. First of all, these changes are related to the release of Visual Studio 2010.

File suggestion for you
• Javascript - 386 view We all know what Serializable interface guarantees i.e. ability to serialize the classes. This interface recommends you to useserialVersioUID also....

• WordPress template - 737 view Chances are that you want to set some kind of minimum requirements on your WooCommerce store before your customers checkout.

• Flash template, Flash game - 659 view In this Quick Tip you will learn how to use BitmapData's copyPixels() method to create a very fast blurry trail effect for the bullets in your...

• Web Development - 222 view Speech to Text Recognition for Data Scraping and Collection in Data Mining

• Visual studio & .NET - 745 view This is a simple application that will teach you on how to create a screen resolution detection program using visual basic.NET framework. It...

Mega tags
• Sharepoint - 999 view According to Microsoft, "Microsoft® Content Management Server (MCMS)...

• References - 1994 view In the process of web design, which makes it the most headaches is how...

• Javascript - 309 view When I began searching for my first job as a web developer, I applied...

• HTML-CSS template - 1697 view Clipping path is the path we use to clip an element, it marks out our...

• Javascript - 919 view In the course of my website, still regularly meet the requirements for...

• Mobile applications - 151 view This application shows you how to create an E-post office where you...

• Javascript - 311 view In previous tutorial, we learned about four persistent states of...

• HTML-CSS template - 6417 view Prior to HTML5 we had no element to semantically mark up a date or...

• HTML-CSS template - 629 view There are times, however, when a lightweight carousel with minimal...

• HTML-CSS template - 1046 view Share Template HTML&CSS Artificial Casting- By Piyush