InetSoft Tools & Technology: The Power of Visual Analysis

Visual analysis is a relatively new innovation in information management software that allows a person to explore data in an interactive, visual manner. At its simplest, it means charting and graphing data, but the novelty is in multi-dimensional charting and interactivity.

Multi-dimensional Charting

Multi-dimensional charting means being able to depict more than just two dimensions on a graph. The standard simple graph charts just two dimension, on the x and y axes. In a two-dimensional chart you can identify basic trends, such as time-based one: is a measure like sales, increasing or decreasing, but you can’t see any other dimension that might help explain why.

With multi-dimensional charting you can add coloring and sizing options. Coloring means coloring different data points on that two-dimensional chart to denote more information.

For example start with a graph of sales opportunities where closing probability is depicted on the y-axis and days until expected close date on the y-axis, with dots represented a single opportunity. You would already be able to identify imminently winnable opportunities in the upper left corner.

Now color the dots by sales person, a different color for each person. Now a scan of the color patterns shows who has more open opportunities and where they are in the likelihood and timeliness to close.

Add another dimension by sizing those dots by dollar amount, such that the larger the revenue potential of the opportunity, the larger the circle is. Now, at a glance you can prioritize opportunities to focus on.

demo
Read how InetSoft saves money and resources with deployment flexibility.

Drill-down

Another aspect of visual analysis is the interactivity, pointing and clicking to explore the data and drill into more details. Drill-down simply means clicking on a data point to see more detail. That can be summarized data as seen by hovering the mouse over a data point, or detailed background information seen by drilling into a detail page of another application or another detailed report by that can be accessed by double-clicking on a data point.

Filtering

Filtering the data displayed on a graph is as easy as checking off selection boxes from criteria lists, as many lists as applicable. Date selection is another level of filtering, and date sliders or visual calendars are visual controls for picking the date ranges to include in the chart. Either of these methods allows sifting through large amounts of data, zooming into the areas of interest, noticing comparisons and trends along the way.

Drop-downs for Dimension Selections

A very powerful innovation in visual analysis is the ability to change what is on the X or  Y axis, or the “size by” or “color by” options. By using simple drop-down menus of available choices for any of these four settings, dozens of useful charts and analyses can be accessed in a single visual analytical view.



Read the top 10 reasons for selecting InetSoft as your BI partner.

Continued: The Business Benefits of Visual Analysis Software