Software Advice has helped thousands of businesses choose the right visual analytics software so they can visually explore data and create dashboards. How does it work?

Visual Analytics Tools


Sort by:
 
Sort by:
 
Dundas BI logo
 
Dundas BI, from Dundas Data Visualization, is a browser-based business intelligence and data visualization platform that includes integrated dashboards, reporting tools, and data analytics. It provides end users the ability to create... Read More
Rating:            (55)
Rating:
        (55)
Price:
Advisor Recommendations:
48
Platforms:
Deployment:
Business Size:
S
M
L
Dundas BI, from Dundas Data Visualization, is a browser-based business intelligence and data visualization platform that includes integrated dashboards, reporting tools, and data analytics. It provides end users the ability to create... Read More
 
Sisense logo
 
SiSense is a BI tool that was developed for all types of user--even those with little or no prior experience with BI software. SiSense's tools manage and support business data with powerful visuals and tools.
Rating:            (95)
Rating:
        (95)
Price:
Advisor Recommendations:
36
Platforms:
Deployment:
Business Size:
S
M
L
SiSense is a BI tool that was developed for all types of user--even those with little or no prior experience with BI software. SiSense's tools manage and support business data with powerful visuals and tools.
 
Domo logo
 
Domo is a fully cloud-based business management suite that integrates with multiple data sources, including spreadsheets, databases, social media and any existing cloud-based or on-premise software solutions. It is suitable for company... Read More
Rating:            (39)
Rating:
        (39)
Price:
Advisor Recommendations:
32
Platforms:
Deployment:
Business Size:
S
M
L
Domo is a fully cloud-based business management suite that integrates with multiple data sources, including spreadsheets, databases, social media and any existing cloud-based or on-premise software solutions. It is suitable for company... Read More
 
IntelliFront BI logo
 
IntelliFront BI by ChistianStevens Software enables all industries to view multiple data sets in one place. The system offers real-time dashboards with on-demand reporting. Users have access to business process automation, report... Read More
Rating: No reviews
Rating:
No reviews
Price:
Advisor Recommendations:
22
Platforms:
Deployment:
Business Size:
S
M
L
IntelliFront BI by ChistianStevens Software enables all industries to view multiple data sets in one place. The system offers real-time dashboards with on-demand reporting. Users have access to business process automation, report... Read More
 
Style Intelligence logo
 
InetSoft Style Intelligence is a business intelligence software platform that allows users to create dashboards, visual analyses and reports via a data mashup engine—a tool that integrates data in real time from multiple sources.... Read More
Rating:            (31)
Rating:
        (31)
Price:
Advisor Recommendations:
21
Platforms:
Deployment:
Business Size:
S
M
L
InetSoft Style Intelligence is a business intelligence software platform that allows users to create dashboards, visual analyses and reports via a data mashup engine—a tool that integrates data in real time from multiple sources.... Read More

Call us for a free FastStart Consultation: +1 844 746 1795


 
Looker logo
 
Companies that want to analyze the large amounts of data they are collecting should consider Looker, an intuitive web-based Business Intelligence platform. They offer an extensive free trial.
Rating:            (24)
Rating:
       (24)
Price:
Advisor Recommendations:
12
Platforms:
Deployment:
Business Size:
S
M
L
Companies that want to analyze the large amounts of data they are collecting should consider Looker, an intuitive web-based Business Intelligence platform. They offer an extensive free trial.
 
Yellowfin logo
 
Yellowfin, a business intelligence platform, is a single integrated solution developed for companies across varying industries and scaling sizes. This system is customizable to suit businesses in accounting, advertising, agriculture,... Read More
Rating:            (8)
Rating:
        (8)
Price:
Advisor Recommendations:
11
Platforms:
Deployment:
Business Size:
S
M
L
Yellowfin, a business intelligence platform, is a single integrated solution developed for companies across varying industries and scaling sizes. This system is customizable to suit businesses in accounting, advertising, agriculture,... Read More
 
BOARD logo
 
We recommend BOARD to those looking for a centralized tool to house data, conduct multidimensional analyses and drill-down to examine the performance of company departments. BOARD is used by US Navy, Puma and Giorgio Armani.
Rating:            (54)
Rating:
        (54)
Price:
Advisor Recommendations:
7
Platforms:
Deployment:
Business Size:
S
M
L
We recommend BOARD to those looking for a centralized tool to house data, conduct multidimensional analyses and drill-down to examine the performance of company departments. BOARD is used by US Navy, Puma and Giorgio Armani.
 
Pentaho logo
 
Pentaho is a flexible and comprehensive Business Intelligence solution. Intelligent tools for Dashboards and Scorecards, ETL, Data Mining and Predictive Analytics, and OLAP are available for deployment on-premise or web-based.
Rating:            (13)
Rating:
        (13)
Price:
Advisor Recommendations:
7
Platforms:
Deployment:
Business Size:
S
M
L
Pentaho is a flexible and comprehensive Business Intelligence solution. Intelligent tools for Dashboards and Scorecards, ETL, Data Mining and Predictive Analytics, and OLAP are available for deployment on-premise or web-based.
 
SAP Crystal Reports logo
 
SAP Crystal Reports is a Business Intelligence (BI) program for Windows suitable for small to medium-sized businesses across multiple industries. The system offers the ability to write customize reports from any data source, as well... Read More
Rating:            (27)
Rating:
        (27)
Price:
Advisor Recommendations:
7
Platforms:
Deployment:
Business Size:
S
M
L
SAP Crystal Reports is a Business Intelligence (BI) program for Windows suitable for small to medium-sized businesses across multiple industries. The system offers the ability to write customize reports from any data source, as well... Read More

Call us for a free FastStart Consultation: +1 844 746 1795


 
Halo logo
 
Halo is an end-to-end supply chain management and business intelligence platform that helps in business planning and forecasting inventory for supply chain management. The system uses data from all sources - big, small, and in-between... Read More
Rating:            (28)
Rating:
        (28)
Price:
Advisor Recommendations:
3
Platforms:
Deployment:
Business Size:
S
M
L
Halo is an end-to-end supply chain management and business intelligence platform that helps in business planning and forecasting inventory for supply chain management. The system uses data from all sources - big, small, and in-between... Read More
 
Birst logo
 
Birst is a web-based Networked BI and Analytics solution that connects insights from various teams which helps in taking informed decisions. The tool enables decentralized users to augment the enterprise data model virtually without... Read More
Rating:            (28)
Rating:
        (28)
Price:
Advisor Recommendations:
1
Platforms:
Deployment:
Business Size:
S
M
L
Birst is a web-based Networked BI and Analytics solution that connects insights from various teams which helps in taking informed decisions. The tool enables decentralized users to augment the enterprise data model virtually without... Read More
 
Exago logo
 
Exago is a self-service Business Intelligence solution that provides a unique balance of operational and ad hoc reporting, dashboards, and interactive data visualization for non-technical business users. End users control the entirety... Read More
Rating:            (22)
Rating:
        (22)
Price:
Advisor Recommendations:
1
Platforms:
Deployment:
Business Size:
S
M
L
Exago is a self-service Business Intelligence solution that provides a unique balance of operational and ad hoc reporting, dashboards, and interactive data visualization for non-technical business users. End users control the entirety... Read More
 
Sage Live logo
 
Sage Live is a web-based and mobile ready accounting platform for small and mid-sized businesses. Key features include multi-company, multi-currency, and multi-legislation support, personalization based on user role, bank integration,... Read More
Rating:            (3)
Rating:
         (3)
Price:
Advisor Recommendations:
1
Platforms:
Deployment:
Business Size:
S
M
L
Sage Live is a web-based and mobile ready accounting platform for small and mid-sized businesses. Key features include multi-company, multi-currency, and multi-legislation support, personalization based on user role, bank integration,... Read More
 
Rapid Insight logo
 
Rapid Insight Inc. is a locally installed Business Intelligence solution with integrated applications for Dashboards and Scorecards, Data Mining and Predictive Analytics, Extract Transform Load, and Query and Report Writer.
Rating:            (3)
Rating:
       (3)
Price:
Business Size:
S M L
Platforms:
Deployment:
Rapid Insight Inc. is a locally installed Business Intelligence solution with integrated applications for Dashboards and Scorecards, Data Mining and Predictive Analytics, Extract Transform Load, and Query and Report Writer.

Call us for a free FastStart Consultation: +1 844 746 1795


 
Chartio logo
 
For business owners seeking a full-featured Business Intelligence system, we recommend Chartio as a great option to add to your shortlist. The system smartly focuses on being simple to use, featuring Drag and Drop Chart Creation. This... Read More
Rating:            (15)
Rating:
        (15)
Price:
Business Size:
S M L
Platforms:
Deployment:
For business owners seeking a full-featured Business Intelligence system, we recommend Chartio as a great option to add to your shortlist. The system smartly focuses on being simple to use, featuring Drag and Drop Chart Creation. This... Read More
 
SAP Business Objects logo
 
With its consolidated approach, SAP Business Objects gives organizations a set of tools to manage and optimize Business Intelligence. From a centralized portal, companies handle everything from ETL and data cleansing to predictive... Read More
Rating:            (46)
Rating:
        (46)
Price:
Business Size:
S M L
Platforms:
Deployment:
With its consolidated approach, SAP Business Objects gives organizations a set of tools to manage and optimize Business Intelligence. From a centralized portal, companies handle everything from ETL and data cleansing to predictive... Read More
 
Diver | BI logo
 
Diver | BI from Dimensional Insight is a business intelligence and information delivery platform offering flexible deployment options and compatibility with most devices. The suite of applications includes dashboards and scorecards,... Read More
Rating: No reviews
Rating:
No reviews
Price:
Business Size:
S M L
Platforms:
Deployment:
Diver | BI from Dimensional Insight is a business intelligence and information delivery platform offering flexible deployment options and compatibility with most devices. The suite of applications includes dashboards and scorecards,... Read More
 
iCharts for NetSuite logo
 
iCharts for NetSuite is a Business Intelligence (BI) reporting and analytics tool that suits enterprise-level companies in a variety of industry segments. The cloud-based platform allows users to visualize and analyze NetSuite data... Read More
Rating: No reviews
Rating:
No reviews
Price:
Business Size:
S M L
Platforms:
Deployment:
iCharts for NetSuite is a Business Intelligence (BI) reporting and analytics tool that suits enterprise-level companies in a variety of industry segments. The cloud-based platform allows users to visualize and analyze NetSuite data... Read More
 
Centerprise Data Integrator logo
 
Centerprise Data Integrator is an on-premise data integration solution that includes integration, transformation, quality and profiling. It enables users to choose from multiple integration scenarios and control individual users' view... Read More
Rating:            (22)
Rating:
        (22)
Price:
Business Size:
S M L
Platforms:
Deployment:
Centerprise Data Integrator is an on-premise data integration solution that includes integration, transformation, quality and profiling. It enables users to choose from multiple integration scenarios and control individual users' view... Read More
 

Buyer's Guide

by Daniel Harris,
Market Research Associate
Last Updated: April 26, 2017


Visual analytics tools allow business analysts and other users to query and combine data sets using point-and-click gestures in a visual interface, instead of actually writing out queries in a programming language like SQL.

These tools represent a significant advancement in the modern, “self-service” model of BI. In this model, business analysts access and query data themselves, instead of accessing and querying it through technologies controlled by the IT department.

Visualization is key to self-service BI, since it’s a way for users who don’t know how to write queries themselves to retrieve the data they need. Users can perform analytical operations merely by clicking on pie charts, adding new dimensions to maps etc., instead of expressing such operations in SQL or another language.

Since visual analytics is still an evolving technology, we’ll describe the major capabilities these tools offer. We’ll also explain how the market breaks down, since visual analytics capabilities are found in various types of BI solutions.

We’ll guide you through the following topics:

Visual Analytics != Dashboards
Capabilities of Visual Analytics Software
Visual Data Discovery vs. Visual Analytics in Traditional BI Systems
Choosing: Dedicated Visual Analytics Platform, or Traditional BI?

Visual Analytics != Dashboards

Many readers will know enough SQL to recognize “!=” as the “does not equal” operator rather than a typo, but if not, that’s precisely why you need a visual analytics system. SQL syntax becomes even more complex once you go beyond the basic operators.

Visual analytics tools are frequently confused with dashboards. Let’s take a look at why.

Exhibit A is an actual dashboard:

Dashboard in BI software platform Board

Exhibit A: Sales manager dashboard in Board

Exhibit B is the interface of a visual analytics solution during analysis:

Visual analytics in Qlik Sense

Exhibit B: Visual analysis of accident reports in Qlik Sense

At first glance, it can be very difficult to tell the difference between these two visual interfaces for presenting trends in data. There are, however, a few, including:

  • The dashboard is customized for a role (“sales manager”), whereas the visual analytics interface is generic.
  •  
  • The dashboard shows key performance indicators (KPIs) at a glance, whereas the visual analytics system shows patterns in a data set.
  •  
  • On a related note, the dashboard is pulling data from a diverse range of sources, whereas the visual analytics application is primarily being used on a single data set.
  •  
  • The dashboard is neatly templated, whereas the visual analytics tool looks like charts and graphs have been dropped in during analysis (because they have).

Dashboards are templated visualizations of KPIs that integrate data from a variety of operational sources: CRM systems, e-commerce/order processing platforms, inventory management systems, accounting systems, supply chain management systems etc. They either update in real-time or are regularly refreshed with new data. Most dashboards aim to help end users (sales managers, call center agents etc.) understand their individual performance or the business’s performance.

Interactivity is highly limited in a dashboard, because analysts in conjunction with business leaders determine how performance is calculated—not the end users. Users may be able to click on a chart element to get more details on a KPI, but they can’t decide, for instance, to swap out all of the line graphs in the dashboard with scatter plots, or to blend the data in the dashboard with a spreadsheet on their desktop.

Visual analytics graphical user interfaces (GUIs), on the other hand, are blank slates for accessing and manipulating data sets with point-and-click, drag-and-drop gestures on visual data displays (pie charts, tree graphs, heat maps, scatter plots etc.). Whereas the business “freezes” KPI calculations into dashboards, visual analytics tools are designed for free-form visual analysis of any old data set: a spreadsheet, a SQL database, a NoSQL database etc. Moreover, users can blend data from multiple sources during analysis, instead of having to rely on the blends that have been built into a dashboard.

Users thus choose the visualization types they want to use in visual analytics software. If one chart type doesn’t work, another can be used in its place. Users also choose the dimensions (data categories such as customer, product etc.) and measures (numerical values like the number of items sold in a given transaction) that they want to combine in these visualizations. Generally, analysis is a process in these tools—once a pattern has been spotted, the user explores it with further visualizations.

Visual analytics tools are thus specifically designed for business analysts who spend all day spotting new patterns in business data to explain problems and highlight opportunities.

The following table summarizes the differences:

Key Differences Between Dashboard and Visual Analytics Interfaces

  DashboardVisual analytics interface
User base End users throughout organization Business analysts and other data explorers
Purpose Present role-specific KPIs Facilitate free-form analysis
Level of interactivity Minimal High
Data connections Prebuilt Ad hoc

Capabilities of Visual Analytics Software

Visual analytics tools generally offer the following capabilities:

Visual GUI A visual interface supports data manipulation via drag-and-drop gestures rather than SQL clauses.
Library of templated chart types Users can pick from bar charts, heat-maps, treemaps, scatter plots, bubble charts and a range of other visualization operations. Many tools will even recommend an appropriate visualization based on the data.
Ability to promote visualizations to dashboards Analysts can template KPI analyses as dashboards and share them across the organization (generally requires a server license in addition to user licenses).
Ad hoc data connections These tools can connect directly to a wide range of data sources, including spreadsheets, relational databases, NoSQL databases, cloud data sources etc.
Data blending Users can combine data from different sources on the fly to discover new insights.
Linked visualizations If a user alters one element of a visualization (say by adding a new dimension), the other elements will update automatically.
Data cleaning/preparation Since data access in visual analytics software is frequently ad hoc, data typically needs to be prepared for analysis with features for normalizing fields, removing trailing spaces etc.
Back-end SQL engine Visual analytics software includes an engine that translates users’ gestures into SQL queries.
In-memory data cache These tools also process data in random access memory (RAM) instead of writing it to disk, which allows for rapid processing of huge data sets.

Visual Data Discovery vs. Visual Analytics in Traditional BI Systems

Visual analytics tools—also known as data discovery tools—evolved as a response to two problems with traditional BI systems:

  • These systems lacked an easy interface to allow non-IT users to run ad hoc queries on data. Frequently, analysts had to resort to SQL querying.
  •  
  • Traditional BI systems limit analysis to data sources that have been integrated into the system, whereas data discovery tools are designed to open analysis up by connecting directly to a variety of data sources.

Dashboards and static reports are a strength of traditional BI systems, since in these systems the IT department works alongside analysts to extract data from operational databases, calculate metrics and push KPIs out to end users via PDF reports, dashboards or some other medium.

In this use case, free-form analysis by the end user isn’t necessary or even encouraged. Instead, the organization standardizes on a single data model (a schematization of the relationships between data types, data sources etc.), which is then built into the BI system.

Visual data discovery tools thus evolved for those end users who do need to perform free-form analysis, i.e. business analysts, since dashboards and scheduled KPI reports aren’t enough for these users.

It may seem that visual data discovery tools have a clear edge over traditional BI. However, data discovery tools suffer precisely because of the freedom they enable. One analyst may use a different process to visualize data than another, which makes it possible for the analysts to wind up with two significantly different interpretations of the same data set.

Traditional BI systems were designed to control access to data such that companies had a “single source of truth” about business performance metrics. Data discovery tools are catching up in this regard by introducing data governance features (role-specific access to certain data sources, data modeling languages etc.). However, they’re not as robust in this area as traditional systems.

Data modeling in Looker BI

Data modeling in Looker BI

Moreover, traditional systems have now incorporated many of the visual analysis features originally found only in data discovery tools. Both visual data discovery tools and traditional systems can be used to create dashboards.

Choosing: Dedicated Visual Analytics Platform, or Traditional BI?

The following table presents the most important selection criteria for deciding between these options:

 Visual data discovery toolTraditional BI system
Free-form visual analysis of data
Dashboards
Regularly scheduled batch extractions of data from operational databases (extract, transform and load)  
Standardized and centrally governed data model serving as a “single source of truth”  
Collaborative data modeling among workgroups
 
Ad hoc connections to new data sources and recombinations of data sources
 
Data warehousing  
Organization-wide deployment for end users  
Workgroup deployments for analysts
 

These criteria unfortunately aren’t always as clear as they’d ideally be, since, as we’ve seen, the distinction between these categories is gradually eroding away.

Some popular visual analytics software products include Tableau, Qlik Sense and Looker, but there are many more options on the market than this.

Traditional BI vendors that support visual analytics include Birst and Pentaho—again, there are a host of additional options.

Free Download:
Business Intelligence Software Pricing Guide

Free Download:
Expert Advice for Your BI Software Search

 

How it Works

We match organizations with software that meets their needs.

Our service is simple and 100% free to customers like you because software vendors pay us when we connect them with quality leads. You save time and get great advice. Vendors get great referrals. It's a win for everyone!

Call now for advice: +1 844 746 1795
Software Advice Advisors
×