We've helped thousands of businesses choose the right data discovery software so they can integrate data and explore trends across dimensions. How does it work?

Data Discovery 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:
50
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:
44
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:
33
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:
27
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:            (30)
Rating:
        (30)
Price:
Advisor Recommendations:
18
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: (844) 680-2046


 
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:
12
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
 
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:
11
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.
 
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:
9
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
 
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:
8
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:
6
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.

Call us for a free FastStart Consultation: (844) 680-2046


 
Salesforce Analytics Cloud (Wave) logo
 
Designed to offer powerful insights and uncover new business opportunities instantly, Salesforce Analytics Cloud, powered by Wave, was launched in October 2014. This nimble Business Intelligence system was designed to give users access... Read More
Rating:            (24)
Rating:
        (24)
Price:
Advisor Recommendations:
5
Platforms:
Deployment:
Business Size:
S
M
L
Designed to offer powerful insights and uncover new business opportunities instantly, Salesforce Analytics Cloud, powered by Wave, was launched in October 2014. This nimble Business Intelligence system was designed to give users access... Read More
 
IBM Cognos Business Intelligence logo
 
IBM Cognos is a scalable Business Intelligence solution that can be deployed either on-premise or web-based. It provides companies in any vertical the ability to glean useful information and insight from large amounts of raw data.
Rating:            (22)
Rating:
        (22)
Price:
Advisor Recommendations:
2
Platforms:
Deployment:
Business Size:
S
M
L
IBM Cognos is a scalable Business Intelligence solution that can be deployed either on-premise or web-based. It provides companies in any vertical the ability to glean useful information and insight from large amounts of raw data.
 
Halo logo
 
Halo - The Supply Chain Intelligence Company provides analytics tools that are tailored to specific industries, such general ledger (GL) analysis for finance and inventory forecasting for supply chain management. The system uses data... Read More
Rating:            (28)
Rating:
        (28)
Price:
Advisor Recommendations:
2
Platforms:
Deployment:
Business Size:
S
M
L
Halo - The Supply Chain Intelligence Company provides analytics tools that are tailored to specific industries, such general ledger (GL) analysis for finance and inventory forecasting for supply chain management. The system uses data... 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:            (23)
Rating:
        (23)
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

Call us for a free FastStart Consultation: (844) 680-2046


 
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.
 
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
 
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 21, 2017


Data discovery is one of the fastest-growing and rapidly changing segments of the BI market. These tools differ dramatically from the traditional systems of record that enable IT to push reports and dashboards out to the rest of the organization.

In many cases, data discovery tools are purchased by organizations that have already deployed traditional BI systems, in order to solve issues with data access, data preparation and data exploration. Data discovery solutions have also been a godsend for small businesses that can’t afford complex data warehouses and lack the expertise to build them.

The market for data discovery software is complex and highly fragmented. There are a number of different “flavors” of data discovery, and a variety of use cases in which one flavor works better than another.

In this Buyer’s Guide, we’ll explain how data discovery software differs from traditional BI and describe the categories into which these tools break down.

Here’s what we’ll cover:

How Do Data Discovery Tools Differ From Traditional BI Systems?
Capabilities of Data Discovery Software
Types of Data Discovery Tools

How Do Data Discovery Tools Differ From Traditional BI Systems?

An easy way to understand this difference is to look at the history of BI solutions.

Traditional BI systems were an attempt to solve the difficulty of writing SQL queries in order to retrieve data such as sales information, customer information, shipping records etc. stored in multiple relational databases. Before BI, users had to be highly familiar with SQL to get the data they needed out of such databases.

Thus, traditional BI systems mapped a layer of familiar business terms (known as a semantic layer) onto the relational databases’ storage schemas, thereby allowing users to retrieve and combine data without knowing SQL at all.

Traditional BI Semantic Layer

Traditional BI Semantic Layer

 

The semantic layer is a way of expressing a data model, or a schematic representation of the relationships between data in one or multiple datasets. In particular, the semantic layer schematizes the relationships between data residing in different data sources/databases. For instance, the dimension “customer” in the semantic layer may be defined as grouping together information from both the “sales orders” database as well as the “customer records” database.

BusinessObjects—later acquired by SAP—was the first BI vendor to use the semantic layer model, and remains one of the most popular semantic layer-based solutions. The semantic layer model is still suitable for large enterprises that need unified access to data stored in numerous operational databases.

The problem with this model is that the semantic layer needs to be standardized across the organization. In other words, various business units must agree on which databases and tables in these databases the dimension “customer” will pull from. Moreover, once the semantic layer has been standardized, it remains under IT control.

As you can see in the above diagram, traditional tools for ad hoc queries pass analysts’ queries through the semantic layer, which automatically translates them into SQL queries to retrieve data from SQL databases and other data sources that support SQL querying. Thus, traditional querying tools can only work with data sources that have already been integrated into the semantic layer.

Data sources outside the semantic layer (a spreadsheet sent in an email, a public data source on the web, 500,000 Tweets about a product recall etc.) can’t be easily integrated with the semantic layer unless IT develops new processes. And, of course, IT can’t develop a process for every new data source.

When the semantic layer is standardized across the organization, the paths that analysts follow to retrieve and combine data get frozen into place. For instance, if the organization defines “store” as a subcategory of “branch,” and “branch” as a subcategory of “sales region,” while neglecting to slot “customer” somewhere into this hierarchy, blended analysis of sales and customer data can become overly complex.

Business terms mapped to operational data in SAP BusinessObjects

Business terms mapped to operational data in SAP BusinessObjects

Data discovery tools remedy this situation by providing direct access to the operational databases shown in our chart, instead of going through a semantic layer. This allows users to combine spreadsheets and other data sources outside the semantic layer with operational data.

Any data preparation work that needs to be done to combine data sources (e.g., converting “customer_ID” to “customer”) is done on the fly, instead of forcing IT to standardize terminology across the organization.

Additionally, users can develop their own data models during analysis, instead of being bound to the data model encoded in the semantic layer. This allows greater flexibility for sophisticated queries that depend on blending data from multiple sources.

Capabilities of Data Discovery Software

There’s a wide range of data discovery platforms, meaning that listing specific features is pointless. Instead, let’s take a quick look at the broad capabilities that define these solutions:

(Graphical) front end for data manipulation Allows for data access and manipulation via visualizations of data sources and patterns in data. Instead of writing a query, you can simply click on a wedge of a pie chart to drill down, or choose a heat-map visualization for your data.
In-memory processing Processes data by storing it in RAM (random access memory) instead of writing it to disk. This gives them the processing power to blend massive data sets on a user’s laptop, instead of doing the blends in the database as traditional BI tools do. See our data blending report for more details.
Big data connections Supports direct connections to data sources, instead of confining access to sources within the semantic layer. Support for flat files (.xlsx, .csv etc.) is nearly universal, as is support for SQL databases. Beyond that, the range of data sources a tool can connect to is generally a point of competitive differentiation.
Data cleaning/preparation Offers features for cleaning and preparing data, since analysts can’t rely on pre-integration of data sources via a semantic layer. These features are for normalizing dimensions, removing trailing spaces, testing the accuracy of joins etc. on the fly.

Note: Several of these definitions of data discovery capabilities were adapted from Gartner research reports, specifically What Data Discovery Means for You by Joao Tapadinhas and Dan Sommer (available to Gartner clients).

Types of Data Discovery Tools

Data discovery has been an emerging market for at least a decade, but instead of solidifying around a core set of concepts and features, the market has continued to evolve.

Data discovery functionality has also been added to traditional systems that use semantic layers, though such systems will still be overkill for many small businesses.

There are essentially three categories of data discovery solutions currently on the market:

  • “Search engine”-like tools for textual searches of data
  • Visual interaction tools that provide a graphical front-end for data manipulation
  • “AI”-based tools that do the bulk of the pattern recognition for you

Visual data interaction tools are analytics tools that directly access data sources instead of going through a semantic layer. They allow users to process massive datasets on their laptops (via in-memory caching engines) and spot patterns using a visual interface.

Data visualizations in data discovery tool Tableau

Data visualizations in Tableau

The point of a visual data discovery tool isn’t simply to crunch numbers and then output pretty charts and graphs, which can easily be done with Excel and Powerpoint. Instead, these tools are for interactive manipulation of data via visualizations.

For example, you can click on a particular city in a heat-map to begin analyzing sales just within that city’s stores. You can then add another dimension to your map—say, aggregate payroll expenses per store—to blend sales and payroll data and spot new patterns.

As you click on visualization elements and drag and drop dimensions and measures into your visualizations, an engine within the data discovery tool translates your gestures into SQL queries. Changing the visualization automatically refreshes it with newly processed data from your databases.

These tools thus allow for highly interactive and sophisticated database querying without forcing users to learn SQL. Moreover, they allow users to access and blend data from multiple data sources that haven’t been integrated via a semantic layer.

Visual data interaction tools are thus known as “self-service” BI tools, since business analysts can get the data they need and analyze it in the ways they want without involving IT in the workflow.

Originally, visual data interaction tools were designed to supplement the capabilities of an existing BI system. As they’ve evolved, however, they’ve incorporated more and more of the capabilities that used to be found only in traditional systems. Many organizations—especially smaller ones—are now exclusively relying on this form of data discovery as their dominant analytics platform.

Visual data interaction tools make up the bulk of the data discovery market, and frequently data discovery is used as a synonym for business analytics via interactive visualizations.

“Search engine-like” tools are a niche category in data discovery. They’re specifically for performing keyword searches of large collections of files, and they feature an interface similar to that of web search engines such as Google and Bing. Search-based tools harness text mining technology to allow users to search keywords within files and documents:

Data discovery using keyword searches and word clouds in WebFOCUS

Data discovery using keyword searches and word clouds in WebFOCUS

Search-based tools are clearly not the best choice for dealing with numerical values, which are, of course, absolutely central to business analysis. Instead, this form of data discovery is used by organizations with massive collections of unstructured textual data (surveys, documents, presentations, product literature etc.) sitting in numerous data siloes.

Without search-based data discovery, employees may never be able to track down the documents they need on their own. These tools thus enable better information-sharing, at the same time cutting down on the time that information “gatekeepers” have to spend tracking down documents for co-workers. Most small businesses won’t need them.

“AI”-based tools. Visual data interaction tools can be used to support pattern via machine learning (or “AI” in layman’s terms). Generally this requires integration with a variety of other tools and technologies ranging from the statistical programming language “R” to Apache Spark (a framework for programming machine-learning algorithms in cluster computing environments).

“AI-based” data discovery tools directly leverage machine learning to spot patterns for users, instead of enabling users to spot patterns themselves through visual analysis. These tools then output visualizations and can even express the patterns they find in narrative form for users (for example, they can output a sentence stating “Q4 revenue down 2.1 percent in Kentucky branch stores served by X, Y and Z distributors.”

Don’t assume that a HAL 9000 will replace your analysts anytime soon, however. Human beings still need to vet the patterns to make sure that they’re truly significant, and once a pattern has been spotted, users can continue to refine the analysis by asking new questions of the tool, similar to the workflow in a visual data interaction tool.

Examples of “AI”-based data discovery tools include IBM Watson and Salesforce BeyondCore. This is still an emerging market, and while promising, these solutions are too expensive and technologically immature for SMB users at present. Most SMBs will be better served exploring the wide range of visual data interaction tools on the market.

Note: Several of these definitions of categories in the data discovery market were adapted from Gartner research reports, specifically What Data Discovery Means for You by Joao Tapadinhas and Dan Sommer (available to Gartner clients).

Free Download:
Business Intelligence Software Pricing Guide

Free Download:
Ten Steps Guide to Selecting the Right
Business Intelligence (BI) Software

 

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: (844) 680-2046
Software Advice Advisors
×