Visual Junction automatically draws exquisitely organized interactive charts that display easily understood information. This desktop tool enables end users to explore and interact with database or Excel data using our GraphicQL™ interface, allowing you to filter the queries by manipulating the chart. Click on a subset of data in one chart and related information is highlighted in another chart. Remove outlier components of a chart and focus on what’s important in the data. Visual Junction allows powerful statistical analysis using over 4,000 “R” library functions. Predict future trends with time series forecasting.
Visual Junction is a breakthrough business intelligence application with several patent pending innovations. Import data from tab delimited files, comma separated value files, relational databases or simply copy and paste from Excel.
See More with Interactive Charts
Visual Junction automatically draws exquisitely organized and interactive charts below a scrollable panel showing your data table (Patent Pending). From the very beginning your actions are informed by visual representations of the data and you act upon these same visual representations.
Click on the sale ranked highest in Units and observe that it is only ranked in the middle for Amount.
Click on the South bar in the Region chart and see how sales in the South are distributed in each of the other columns.
Click the title to the Amount chart and see how amount is summarized by Region, Salesperson, and Item.
You can get cross tabbed summaries with just two clicks. Click the Item chart title and the Region chart title and you get Units and Amount summarized by Item and Region.
Find out about sales of Pen Sets in the South by clicking its bar.
You can temporarily filter these summaries by selecting a bar or bars from any chart in Band 1.
Zoom in and out with keyboard shortcuts.
See the forest and the trees.
Interactive pie charts, scatter plots and line graphs are also available.
Your selections in the charts are highlighted in the table and vice versa.
What can you learn by comparing the highest ranked sale in Units to the highest ranked sale in Amount?
You can select these two bars and see them in the context of all sales.
To see them isolated you drag them down to the next band.
Now you want to separate the exemplary sales into Band 2, starting with the two sales you have already moved to Band 2.
You use your judgment to select and drag several other bars that rank high in either Units or Amount or a combination of both to Band 2.
You can change your mind about a sale and drag it back to Band 1 or set it aside by dragging it into Band 3, as shown below.
Share Your Insights with Instant Dashboards
You can display charts copied from various Visual Junction tabs in a Visual Junction dashboard.
A chart (or collection of interacting charts) copied from a tab and pasted into a Visual Junction dashboard is called a widget.
These widgets can be refreshed with new data and the dashboards can be published to websites.
Each widget has a Source button which brings you back to the source of its data.
Thus, you can use a Visual Junction dashboard as a visual table of contents for a collection of data sources.
Turn SQL on Its Head with GraphicQL
Incorporate the Power of R Statistical Analysis and GraphicQL
Visual Junction‘s R feature extends the power use of GraphicQL to all the thousands of statistical routines available in R.
GraphicQL helps you select subsets of data to feed to an R routine and then helps you understand the results. (Patent Pending)
Using an R routine is as simple as using a summary function like Average.
You select an R routine from the R menu just as you would select Average from the Summary menu.
Combine Expert and Quantitative Forecasting with Déjà vu Forecasting
Déjà vu Forecasting is a patent pending forecasting method for time series and is fundamentally different than previous methods.
It stimulates a close examination of the features of the time series.It also invites the incorporation of expert opinion.
Déjà vu Forecasting organizes the lessons of the past through an interactive set of forecast points.
Each forecast point is connected to certain past events that suggested the forecast point.
Clicking on a forecast point displays a graphic that illustrates this connection and highlights a period in the past and a period immediately preceding the present.
Using the time series and real world knowledge you can judge how similar this past period is to the present period and how much weight to give the associated forecast point.