These products won a Top Rated award for having excellent customer satisfaction ratings. The list is based purely on reviews; there is no paid placement, and analyst opinions do not influence the rankings. Read more about the Top Rated criteria.
Business Intelligence (BI) Tools TrustMap
TrustMaps are two-dimensional charts that compare products based on trScore and research frequency by prospective buyers. Products must have 50 or more ratings to appear on this TrustMap.
What is Business Intelligence (BI)?
Business Intelligence software (BI) makes up a large heterogeneous category of software. Not all tools in the category can be meaningfully compared to each other. There are several types of BI tools of which the most substantive are Full-Stack Business Intelligence Tools and Data Visualization Tools.
Business Intelligence Tools Features & Capabilities
- BI Platform Type
- Supported Data Sources
- Standard Reporting
- Ad-Hoc Reporting
- Report Output and Scheduling
- Data Discovery and Visualization
- Access Control and Security
- Mobile Capabilities
- APIs / Embedding
Full-Stack Business Intelligence Tools
Slices of data from the warehouse—usually summary data for a single department like sales or finance—are stored in a “data mart” for quick access. All of this structured data is normalized by using an ETL process (Extract, Transform and Load) whereby transactional data is combined into a single pool of data and then “transformed” into a more appropriate format for querying and analysis before being written in the data warehouse database.
The Full-Stack Business Intelligence TrustMap shows only those products that belong in this sub-category.
Data Discovery and Visualization Business IntelligenceData Visualization products have a different purpose. These BI tools are primarily designed to help data analysts discover patterns in large quantities of data and to build compelling visual representations which allow these patterns to be easily understood.
These business intelligence tools often use a technology called in-memory analytics to query data residing on a computer’s RAM rather than on a physical disk. This means that the data does not have to be stored anywhere for subsequent analysis.
Data visualization products often have lower cost of implementation and require less support. This can make them good business intelligence tools for small companies that don’t need a full-stack business intelligence solution.
The Data Visualization TrustMap shows only those tools that belong in this sub-category.
Business Intelligence Software ComparisonWhen considering different business intelligence tools, consider the following aspects of each product offering.
Ease of Use: Some BI tools offer high complexity and customization, but can be difficult for non-technical users. You should consider the technical ability of the staff that will be using the BI tools as well as if you need more complex features.
Compatibility: Many BI tools are not complete, end-to-end solutions. For some organizations, purchasing BI software from multiple vendors may be necessary. If your business needs BI features that aren’t all covered in a single product, be sure to ask venders about integrations and compatibility with other software.
Scalability: Some BI software doesn’t scale up very well as data needs increase. Consider the breadth of data generated by your organization and decide if that amount will stay the same or increase. If your data needs will increase, be sure to choose a BI solution that can handle your expected growth.
One of the impediments to understanding pricing is that vendors base their pricing on a broad range of different variables from number of users to number of CPU cores.
However, as a very rough guide, advanced report authoring can cost $2,000 to $2,500 per seat, while interactive report viewing can be about half that amount. Static report viewing can be as little as $50 per seat.
Analyzer from Strategy Companion headquartered in Irvine provides a self-service business intelligence solution that allows managers to explore, visualize, publish, and share actionable insights in minutes. Users can ask questions of their data to uncover trends, opportunities, and…
Software AG’s webMethods Intelligent Business Operations Platform (IBO) integrates JackBe’s portfolio with the company’s webMethods suite. JackBe's enterprise platform, Presto, provides visualization dashboards for desktop, mobile, portals and SharePoint.
Invantive's free Query Tool provides users with real-time Operational Intelligence (OI) across their entire enterprise. The free Query Tool provides access to the user’s real-time data warehouse and databases running on MySQL, Oracle, SQL Server, Teradata, IBM DB2/UDB or elsewhere.…
BizViz Analytics Platform is a business intelligence solution that is designed to serve any vertical, and provides a 360° view of a organization’s data. This solution includes tools for creating dashboards, business apps, and geospatial analysis. It is comprised of a variety of modules…
Kyubit Business Intelligence is software designed for web based OLAP analysis and Dashboard management within the Microsoft technology environment. The vendor says Kyubit allows users to easily create OLAP reports and Dashboards based on SQL and OLAP data. Users can share reports…
PivotData REST Service is a .NET Core microservice (web application) that provides a web API for calculating pivot tables in the real time (in-memory OLAP engine + build-in ROLAP). It may be hosted either on Windows or Linux. Some key features include: direct connection to SQL…
i2e is a fully integrated forecasting and insights platform that leverages Microsoft Excel® for ease-of-use. The vendor says i2e enables organizations to conduct the following: Strategic long range forecasting and planning globallyOperational historical forecasting locally and globally…
DAVinCI LABS is an artificial intelligence based predictive analytics software that discovers patterns within enterprise data with machine learning algorithms. The findings will be converted into a deployable prediction model that can be easily integrated with virtually any strategic…
SyncFirst turns text documents, PDFs, formatted ASCII files and electronic reports into usable data tables. Once the information is captured in a table, users can create filters to view subsets of the data, sort the table on any combination of fields, create summaries that show totals…