Finding software can be overwhelming. Software Advice has helped hundreds of business intelligence practitioners find the best BI and analysis tools for making smart, informed business decisions.

Showing 1-20 of 202 products

Domo

Domo is the Business Cloud®, empowering organizations of all sizes with BI leverage at cloud scale in record time. With Domo, BI-critical processes that took weeks, months or more can now be done on the fly, in minutes or seconds,... Read more

Price:

Recent recommendations: 11 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Dundas BI

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

Price:

Recent recommendations: 7 recommendations

Platforms: MacWinLinux
Deployments: On premise
Business Size:
Learn More

Sigma

Sigma is the business intelligence and analytics solution that allows everyone in your organization, not just analysts, to ask questions and find answers using data. Instant, guided access to the cloud data warehouse enables teams... Read more

Price:

Recent recommendations: 6 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Style Intelligence

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

Price:

Recent recommendations: 6 recommendations

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

Sisense

Sisense is an agile business intelligence (BI) solution that provides advanced tools to manage and support business data with analytics, visuals and reporting. The solution allows businesses to analyze big and disparate datasets and... Read more

Price:

Recent recommendations: 4 recommendations

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

TIBCO Spotfire

TIBCO Spotfire provides executive dashboards, data analytics, data visualization and KPI push to mobile devices. It complements existing business intelligence and reporting tools, while midsize organizations can use dashboards and... Read more

Price:

Recent recommendations: 3 recommendations

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

Toucan Toco

Toucan Toco is a cloud-based data visualization solution designed to deliver data and insights to non-technical decision makers using visual data storytelling. With Toucan's application studio, businesses are able to create and display... Read more

Price:

Recent recommendations: 3 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Incorta Data Analytics

Incorta is a unified data analytics platform that provides a true self-service data experience. The software enables organizations to quickly and accurately make decisions based on vast easy to digest data sets. Incorta is a data... Read more

Price:

Recent recommendations: 3 recommendations

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

Jirav

Jirav is a cloud-based financial planning and reporting solution that is designed to give businesses the proper tools to examine historical data and build accurate financial models and plans. With Jirav, users are able to accurately... Read more

Price:

Recent recommendations: 2 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Etleap

Etleap is a cloud-based AWS database management tool that allows users to analyze data from disparate sources. Users can add or modify new data sources and apply custom transformations to their datasets. It works with analytical... Read more

Price:

Recent recommendations: 2 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

BOARD

Created to combine business intelligence, corporate performance management, and business analytics, BOARD is a full-featured business intelligence system that serves midsize and enterprise-level companies in a variety of different... Read more

Price:

Recent recommendations: 1 recommendations

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

Centralpoint - Business Intelligence

Centralpoint by Oxcyon is a content management solution that can be installed on-premise or accessed on the cloud from any mobile device with an internet connection.The modular applications can be deployed in a configuration that suits... Read more

Price:

Recent recommendations: 1 recommendations

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

BI4Dynamics

BI4Dynamics is built on 15 years of BI, data warehouse, and Microsoft Dynamics experience and has been deployed for over 1,000 Dynamics user projects worldwide. BI4Dynamics allows companies to build corporate-level data warehouses... Read more

Price:

Recent recommendations: 1 recommendations

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

CXO

Your organization depends on your team to deliver the actionable C-Level insights from your EPM data that it needs. If you are stuck with static reports, BI tools that don’t innately understand the hierarchies and dimensions of financial... Read more

Price:

Recent recommendations: 1 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Dploy Solutions

Dploy Solutions is a cloud-based manufacturing and industrial IIoT software that helps businesses collect, combine and analyze performance data across plant floors and other operations departments. It allows users to gain real-time... Read more

Price:

Recent recommendations: 1 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Lumenore

Lumenore is a cloud-based technology performance management platform that integrates with multiple data sources, including spreadsheets, databases, social media and any existing cloud-based or on-premise software solution. It is suitable... Read more

Price:

Recent recommendations: 1 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

SellScience

scalematters is a data-first business intelligence company that helps SaaS and subscription businesses reduce customer acquisition costs and unleash rapid growth. Too many SaaS companies are flying blind, wasting upwards of 50% of... Read more

Price:

Recent recommendations: 1 recommendations

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Exago

Exago BI is a 100% web-based, end-to-end business analytics solution that’s designed to be embedded in web-based applications. Embedding Exago BI allows SaaS companies of all sizes to provide their customers with self-service ad... Read more

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

TARGIT Decision Suite

TARGIT Decision Suite is a business intelligence and analytics solution that offers visual data discovery tools, self-service business analytics, reporting and dashboards in a single, integrated solution. TARGIT combines the control... Read more

Platforms: MacWinLinux
Deployments: CloudOn premise
Business Size:
Learn More

Ambition

Ambition is a cloud-based business intelligence (BI) solution that provides tools and functionalities that help businesses drive employee performance and manage sales operations. Key features include data transformation, private cloud... Read more

Platforms: MacWinLinux
Deployments: Cloud
Business Size:
Learn More

Buyers guide


Last Updated: October 13, 2020

Self-service BI is a term for business intelligence (BI) tools aimed at business users, instead of the IT department. These tools help analysts explore databases through visual interfaces, instead of SQL queries and custom scripts.

We'll take a look at the types of self-service BI tools on the market and explain how they differ from traditional platforms. Here's what we'll cover:

What Is Self-Service BI?
Common Functionality of Self-Service BI Tools
What Type of Buyer Are You?
Benefits and Potential Issues
Market Trends to Understand

What Is Self-Service BI?

To answer this question, you have to understand traditional BI.

Back in the 80s and 90s, BI platforms were so complex that IT staff had to help business analysts create custom reports by writing SQL queries and custom scripts. Moreover, organization-wide reports were typically produced by the IT department.

IT was traditionally in charge of BI because traditional BI platforms store data in a data warehouse, which is a dedicated database system for historical business data (e.g., many years' worth of sales data, accounting data, customer information etc.).

Essentially, data warehousing involves pulling data from business applications (CRM systems, accounting systems etc.) and storing it so that analysts can spot and diagnose issues with the business's operational and financial performance:

data warehouse processing

Before data could be loaded into the warehouse, however, IT departments had to prepare it for analysis by normalizing dimensions (e.g., ensuring that “customer ID" means the same thing in all the tables in the database), aggregating certain metrics, cleaning dirty data etc. This is known as the “extract, transform, load" or ETL process, because data is extracted from applications, transformed into standard formats for analysis, and loaded into the warehouse.

When an analyst had to combine a new source of information, such as a web analytics system, with data in the data warehouse, the IT department would often have to reinvent the whole ETL process.

This was definitely not a user-friendly situation for analysts, and the IT department didn't really like being reduced to the work of data waitressing either.

Common Functionality of Self-Service BI Tools

Self-service BI tools emerged in the last decade as a response to this situation. They differ from traditional systems in the following ways:

self service vs traditional bi
  • Direct/live data connections. With a traditional BI platform, data is loaded into a warehouse before analysis. With a self-service tool, analysts simply connect directly to the data source, whether it's a cloud application, a relational database, a NoSQL file system, a flat file etc. Analysts can then explore and combine data from the data source with other sources. Moreover, instead of pulling data from the source in batches, analysts can configure a "live" connection to the source so that dashboards and visualizations automatically refresh with new data.
  •  
  • Self-service data preparation. Instead of having the IT team clean and prepare data for analysis, self-service tools allow analysts to prepare data themselves. After the analyst connects to a raw data source, they can specify cleaning procedures and transformations that the data needs to go through before being presented in, say, a dashboard.
  •  
  • Self-service data modeling. As analysts clean and transform data from a raw data source, a data model emerges. For instance, the analyst decides which columns in which tables should be aggregated using the “customer ID" dimension. Essentially, with traditional BI systems IT settles on a data model before data is loaded into the warehouse, whereas with self-service BI business analysts create the data model as they clean and transform data sources for analysis. Pre-configured data sources can then be shared with other analysts for use across the organization.
data modeling looker

Self-service data modeling in Looker BI

  • Graphical user interface. Self-service BI tools include a graphical user interface for data analysis. Analysts can drag and drop dimensions and measures into charts to create data visualizations. They can then click on parts of the visualization (e.g., a wedge in a pie chart) to drill down to more granular data. The drag-and-drop gestures that analysts make in the user interface are transformed into SQL queries by a backend engine. This means that analysts don't need to know programming languages to get data out of databases.
geospatial data visualization board

Visual data exploration in Board

What Type of Buyer Are You?

Analyst workgroup. Analyst workgroups typically need solutions that are robust when it comes to data analysis features—for instance, the statistical algorithms found in IBM SPSS and SAS STAT. They don't typically need strong dashboard capabilities or governance functionality.

IT department. Even though self-service tools are designed for business users, IT departments are still tasked with purchasing and configuring these platforms in many organizations. IT departments will need to find solutions with strong data modeling capabilities, since they'll need to invest in tools that can support data modeling for a whole organization rather than just a workgroup concerned with specific analytical tasks. Moreover, they'll need to invest in solutions that offer strong data governance to protect sensitive data from business users who don't need to access it as part of their roles.

Benefits and Potential Issues

Self-service BI tools offer the same benefits as traditional BI platforms, including:

Data governance Restrict access to sensitive data sources and visualizations.
Role-based dashboards Customize end-user dashboards for different roles throughout the organization.
Data mashups Blend data from many different sources in visualizations.
Metadata management Manage metadata (time stamps, classification tags etc.) across the organization.

Self-service tools also offer the benefit of user-friendly, visual data exploration, which isn't a strength of either traditional BI platforms or of tools for statistical analysis and data mining.

The need that self-service tools don't cover is data storage for analysis, since these tools typically lack support for data warehousing.

Additionally, since self-service tools lack support for analytical data warehousing, they are not as robust when it comes to data governance as traditional platforms. Organizations in which data quality is of utmost importance (e.g. financial institutions) will still need to use traditional data warehousing alongside self-service tools.

Market Trends to Understand

  • The convergence of data prep and visual analytics. Self-service BI tools fall into two categories: data preparation tools that allow analysts to clean and prepare data for analysis, and visual analytics tools that give analysts a visual interface for data exploration and enable them to publish visualizations as dashboards. Currently, data prep vendors and visual analytics vendors team up for self-service BI deployments. However, visual analytics vendors like Tableau are now working to add data prep functionality to their products. This means that you should consider your vendor's roadmap for product development when selecting a self-service tool.
  •  
  • Analytics as a service. As we've seen, self-service tools lack data warehousing functionality, which remains necessary for many organizations. However, providers of cloud services like Amazon Web Services (AWS) are stepping in to meet this need. Services like Amazon Redshift and Amazon S3 are enabling businesses to shift data warehouses to the cloud, and Amazon is launching a whole line of cloud-based analytics tools to complement data storage offerings.
  •  
  • “Smart" data discovery. New analytics offerings like IBM Watson and Salesforce Einstein promise to revolutionize analytics by automating the data exploration process via machine learning and natural language generation (NLG). These tools support a Q&A interface for data analysis, and use machine learning algorithms to spot patterns in data on their own, rather than relying on human users to spot the patterns. NLG functionality allows smart data discovery tools to return answers in the forms of sentences and even short narratives (“EMEA Sales dropped in Q2 because of APAC supply chain interruptions"). While smart data discovery is a long way from replacing human analysts, it represents the future of self-service analytics.