40 Open Source and Free Business Intelligence Solutions
40 Open Source and Free Business Intelligence Solutions : Business Intelligence solution enables, the collection and ingestion of intelligence data through enrichment and augmentation.Business Intelligence technologies provide historical, current and predictive views of business operations. The common functions of business intelligence technologies are reporting, online analytical processing, data mining, process mining, business performance management, benchmarking and analytics. Following is a list of 40+ business intelligence solutions covering Free Cloud Business Intelligence, Free Proprietary Business Intelligence Solutions, Free Open Source Business Intelligence Solutions and Open Source commercial Business Intelligence Solution in no particular order.
40 Open Source and Free Business Intelligence Solutions in no particular order :
Free Cloud Business Intelligence Solutions : Free Cloud Business Intelligence Solutions including IBM Watson Analytics, Microsoft Power BI, Zoho Reports, Tableau Public.
Free Proprietary Business Intelligence Solutions : Free Proprietary Business Intelligence Solutions including Power BI Desktop, EspressReport Lite, QlikView Personal Edition, Style Scope Free Edition, Qlik Sense Desktop, icCube, Arcadia Data Instant, Prognoz Personal Edition, Visualize Free, Dataiku Data Science Studio (DSS) Community Edition, Actian VectorH Express, Actian Vector Express, Birst Express for NetSuite
Free Open Source Business Intelligence Solutions : Free Open Source Business Intelligence Solutions including Pentaho Community Edition, OpenText Actuate Information Hub, Free Edition, ReportServer, JasperReports Business Intelligence, Jedox Base, SpagoBI, ART, Widestage, Pentaho Reporting, JMagallanes, OpenReports, Seal Report, Openi, NextReports, RapidMiner, Mondrian, KNIME.
Open Source Commercial Business Intelligence Solution : Open Source Commercial Business Intelligence Solution including Pentaho, Jaspersoft, Palo, Actuate Corporation, TACTIC, Helical Insight.
40 Open Source and Free Business Intelligence Solutions
|IBM Watson Analytics||Self-service analytics, Data refinement, Data warehousing, Data visualization||Free Cloud Business Intelligence||100,000 rows, 50 columns and total data storage of 500 MB|
|Microsoft Power BI||Self-service analytics, Data refinement, Data warehousing, Data visualization||Free Cloud Business Intelligence||Data capacity limit of 1 GB, and support for streaming data, is 10K rows/hour|
|Zoho Reports||Online reporting, Dashboards,Business intelligence, Data visualization||Free Cloud Business Intelligence||2 users|
|Tableau Public||Data visualisation||Free Cloud Business Intelligence|
|Power BI Desktop||Self-service analytics, Data refinement, Data warehousing, Data visualization||Proprietary Business Intelligence Software|
|EspressReport Lite||Reporting engine, Visual report builder, Scheduling tools||Proprietary Business Intelligence Software|
|QlikView Personal Edition||Self-service analytics, Data refinement, Data visualization||Proprietary Business Intelligence Software|
|Style Scope Free Edition||Interactive flash dashboards and Visualizations||Proprietary Business Intelligence Software|
|Qlik Sense Desktop||Visualizations, Reports and Dashboards||Proprietary Business Intelligence Software|
|icCube||Multidimensional online analytical processing, Web reporting server||Proprietary Business Intelligence Software|
|Arcadia Data Instant||Data visualisation||Proprietary Business Intelligence Software|
|Prognoz Personal Edition||Data visualisation||Proprietary Business Intelligence Software|
|Visualize Free||Data visualisation||Proprietary Business Intelligence Software|
|Dataiku Data Science Studio||Data Science, Data visualisation||Proprietary Business Intelligence Software|
|Actian VectorH Express||Data Science, Data visualisation||Proprietary Business Intelligence Software|
|Actian Vector Express||Data Science, Data visualisation||Proprietary Business Intelligence Software|
|Birst Express for NetSuite||Data visualisation||Proprietary Business Intelligence Software|
|Pentaho Community Edition||Business Analytics Platform, Data Integration, Report Designer, Aggregation Designer, Schema Workbench, Metadata Editor, Hadoop Shims||Free Open Source Business Intelligence Software|
|OpenText Actuate Information Hub, Free Edition||Schedule, manage and export BIRT content, Add interactivity for BIRT Reports, Collaborate and share content with users, Integrate BIRT content with your web application||Free Open Source Business Intelligence Software|
|ReportServer||Graphic Reports, Dynamic Lists, Interactive Dashboards, Report Variants, Scheduling and Search and UI||Free Open Source Business Intelligence Software|
|Jaspersoft Community Edition||Report Designer, Reporting Engine, Interactive Report Viewing, Server Repository, Report Scheduling, Mobile BI, User Access & Security||Free Open Source Business Intelligence Software|
|Jedox Base||Jedox OLAP Server, Jedox Excel Add-in||Free Open Source Business Intelligence Software|
|SpagoBI||Reporting, Multidimensional analysis (OLAP), Charts, Interactive cockpits, Ad-hoc reporting||Free Open Source Business Intelligence Software|
|A Reporting Tool||Reporting, Multidimensional analysis (OLAP), Charts, Interactive cockpits, Ad-hoc reporting||Free Open Source Business Intelligence Software|
|Widestage||Reporting, Multidimensional analysis (OLAP), Charts, Interactive cockpits, Ad-hoc reporting||Free Open Source Business Intelligence Software|
|Pentaho Reporting||Report Designer and Reporting Engine||Free Open Source Business Intelligence Software|
|JMagallanes||OLAP and Dynamic Reports||Free Open Source Business Intelligence Software|
|OpenReports||Web based report generation and administration interface||Free Open Source Business Intelligence Software|
|Seal Report||Web Report Server, Dynamic HTML 5 Charts or MS Charts, Dynamic SQL sources||Free Open Source Business Intelligence Software|
|OpenI||Web-driven interface to build and publish interactive reports from OLAP data sources||Free Open Source Business Intelligence Software|
|NextReports||NextReports Designer, NextReports Engine and NextReports Server||Free Open Source Business Intelligence Software|
|Rapidminer||Advanced Analytics, Advanced Scheduling, Reports, Interactive Reports, Collaboration, Integration||Free Open Source Business Intelligence Software|
|Mondrian||Online Analytical Processing server||Free Open Source Business Intelligence Software|
|KNIME||Advanced Analytics, Reporting||Free Open Source Business Intelligence Software|
|Jaspersoft||Suite of open source Business Intelligence products||Open Source Business Intelligence Software|
|Jedox||Suite of open source Business Intelligence products||Open Source Business Intelligence Software|
|TACTIC||Web based platform||Open Source Business Intelligence Software|
Free Cloud Business Intelligence Solutions:
1.IBM Watson Analytics
Watson Analytics provides a freemium version of its cloud based service designed to run on desktop and mobile devices is available. Watson Analytics can help business source the data, cleanse and refine it, discover insights, predict outcomes, visualize results, create reports or dashboards, and collaborate with others. Watson Analytics offers a full range of self-service analytics, including access to easy-to-use data refinement and data warehousing services .Watson Analytics Free Edition, let to upload, storage and work with flat files with no more than 100,000 rows, 50 columns and total data storage of no more than 500 MB.
Sisense empower the most non-technical user with the ability to access data and build interactive dashboards and business intelligence reports. Sisense provides a variety of dashboard widgets to pinpoint the best visualization for your data, such as: geographical maps, gauges to measure KPIs, line charts to determine trends, scatter plots to see correlations, and pie charts for clear comparisons.Sisense enables to customize dashboard layout with drag-and-drop features to place each widget exactly where you want for optimal representation.
2.Microsoft Power BI
Power BI, is a cloud based business analytics service, designed for non technical business users.Customers can keep a pulse on their business via live operational dashboards with just any browser or a Power BI mobile app. They can deeply explore their business data, through interactive visual reports, and enrich it with additional data sources. Power BI let toconnect to your data in minutes, with built in connectors and pre built dashboards and reports from a wide variety of sources. Power BI Designer is a dedicated report authoring tool for the Power BI Preview service. The Data capacity limit for free version is 1 GB, and support for streaming data, is 10K rows/hour.
Zoho Reports is an Online reporting and business intelligence which provide unlimited reporting and dashboards.Zoho Reports let to visually analyze your business data, create insightful reports and dashboards to make informed business decisions.
4. Tableau Public
Tableau Public is a free data visualisation application used to create and share interactive charts graphs, stunning maps, live dashboards and fun applications in minutes, then to publish that anywhere on the web.
Free Proprietary Business Intelligence Solutions
1.Power BI Desktop
The Power BI Desktop is an end-to-end solution for building analytics. The Desktop has all the capabilities to quickly connect, shape, visualize, and share data insights through Power BI.Power BI makes publishing and sharing your beautiful interactive reports easy.
EspressReport Lite is a Java report development tool kit from Quadbase. It comes with a reporting engine and a visual report builder to build embedded reporting functionality into web based or standalone applications. With a robust Java API, and visual design, query, and scheduling tools, EspressReport offers a fully embedded reporting component that can be integrated seamlessly in application, applet, servlet, and JSP code.EspressReport Lite provides the same capabilities as premium, EspressReport except that sub-reports, drill-down, embedded charts and scheduling are not supported.
3. QlikView Personal Edition
The QlikView Business Discovery platform delivers true self service BI that empowers business users by driving innovative decision making. QlikView is used for consolidating relevant data from multiple sources into a single application, exploring the associations in data, visualizing data, and enabling social decision making through secure, real-time collaboration.
QlikView Personal Edition is a free software.
4.Style Scope Free Edition
5. Qlik Sense Desktop
Qlik Sense Desktop is fully functional business intelligence software, available at no cost for personal and business use. Qlik Sense empowers business users to easily create personalized visualizations, reports and dashboards with drag-and-drop simplicity. It an installed Windows application which provides Drag-and-drop app creation and data loading and Multi-data source integration.
icCube is a business intelligence tool to analyze and get insights from a wide range of types of data possibly spread out across multiple data sources. The icCube Server is an in memory multidimensional online analytical processing (OLAP) server written in Java. Along with the analytical engine, the icCube Server is featuring a web reporting server that is leveraging the multi dimensional concepts such as drilldown, slice, dice to create interactive web dashboards accessible from PC and Table.
icCube community edition is a free software.
7. Arcadia Data Instant
Arcadia Data unifies visual analysis, data discovery and business intelligence native in Hadoop and provides access data inside and outside Hadoop right from web browser, and no driver installation required. Lets browse data sources, structure and content, with full granularity and transparency. It lets to create semantic relationships across multiple sources, set hierarchies and logical datasets, for blending visualizations across sources and provides an easy-to-use, familiar web-based self-service drag-n-drop authoring, to create full range of charts and graphs. Arcadia Data assemble dashboard of visual apps that show your work, with interactive drilldown to raw data, so you can zoom and pivot with transparent precision to any values in your data sets.
8. Prognoz Personal Edition
Prognoz Platform is a modern BI platform for creating and developing desktop, web and mobile applications combining modern technologies of data storage, visualizations, OLAP, forming reports, modeling and forecasting of business processes.Personal version contains all tools of Prognoz Platform 8, a repository with demo examples and is not time restricted. Personal version cannot be used with commercial DBMS and is used to work with a full set of functionalities only in a local database.
9. Visualize Free
Visualize Free provides an easy way to evaluate some of the capabilities of InetSoft’s commercial visual analysis product, Style Scope. Visualize Free is a free Web-based on demand analytics solution to visually explore and present data that standard office charting software cannot handle.
10.Dataiku Data Science Studio (DSS) Community Edition
Dataiku Data Science Studio (DSS) is a software platform that aggregates all the steps and big data tools necessary to get from raw data to production ready application. DSS can make the models and predicted values accessible to other business applications through a REST API.DSS can also publish the models and predicted values to a variety of other destinations such as ElasticSearch, FTP servers, internal Datawarehouses.
11.Actian VectorH Express
Actian VectorH Express provides Hadoop analytics using existing SQL tools and resources and transform Hadoop into a full function analytics platform for free. Load, transform and analyze up to 500GB of Hadoop data and analyze Hadoop data 30x faster without MapReduce coding and provide business users industrialized SQL in Hadoop access
12.Actian Vector Express
Actian Vector Express provides high performance BI analytics. Load, transform, and analyze up to 250GB of ANY data, build re-usable analytical workflows visually without coding and accelerate analytics processing over 10x faster.
13.Birst Express for NetSuite
Birst Express for NetSuite, is a free analytics module that NetSuite administrators can use to achieve greater operational efficiency across their organization. Birst Express for NetSuite is part of the Birst analytics family, which includes Birst Discovery and Birst Enterprise editions.Birst Express provides powerful data visualization, reporting and analytics to organizations of all sizes.
Free Open Source Business Intelligence Solutions:
1. Pentaho Community Edition
Pentaho offers, a suite of open source Business Intelligence (BI) products which provide data integration, OLAP services, reporting, dashboarding, data mining and ETL capabilities. Pentaho Community Edition suite includes ETL, OLAP analysis, metadata, data mining, reporting, dashboards and a platform that allows to create complex solutions to business problems.Portfolio includes Business Analytics Platform, Data Integration, Report Designer, Aggregation Designer, Schema Workbench, Metadata Editor, Hadoop Shims.The Report Designer is a graphical tool that generates reports from data streamed through the Data Integration engine without the need for any intermediate staging tables.
2. OpenText Actuate Information Hub, Free Edition
BIRT is an open source Eclipse based reporting system from Eclipse Foundation which integrates with Java/Java EE application to produce compelling reports. BIRT Business Intelligence platform includes BIRT Designer, BIRT Designer Pro, BIRT iHub F-Type and BIRT Analytics. BIRT provides core reporting features such as report layout, data access and scripting. The stated goals are to address the reporting needs within a typical application, which ranges from operational or enterprise reporting to multi dimensional online analytical processing (OLAP). BIRT has two main components, which are, a visual report designer within the Eclipse IDE for creating BIRT Reports, and a runtime component for generating reports that can be deployed to any Java environment. The BIRT project also includes a charting engine that is both fully integrated into the report designer and can be used standalone to integrate charts into an application.
ReportServer is an open source software for business intelligence and reporting platform released in aGPL license. Major features include Graphic Reports, Dynamic Lists, Interactive Dashboards, Report Variants, Scheduling and Search and UI, TeamSpaces, Hierarchical Structures, Report Management, Data Sources and User Management.
ReportServer integrates with JasperReports, Eclipse Birt and SAP Crystal Reports. ReportServer is a web application based on Java Servlet technologies which can be used with any relational database for which a JDBC driver is available.
4. JasperReports Business Intelligence
Jaspersoft Business Intelligence Suite Community Edition includes JasperReports Server, JasperReports Library, Jaspersoft Studio and iReport Studio. JasperReports Server is a stand-alone and embeddable reporting server. It provides reporting and analytics that can be embedded into a web or mobile application as well as operate as a central information hub for the enterprise by delivering mission critical information on a real time or scheduled basis to the browser, mobile device, printer, or email inbox in a variety of file formats.
The heart of the Jaspersoft BI Suite is JasperReports Server. JasperReports Server provides the ability to create new reports using an intuitive web-based drag and drop Ad Hoc reporting interface, efficiently and securely manage many reports, interact with reports, including entering parameters and drilling on data. For advanced BI users, Jaspersoft offers Jaspersoft OLAP, which runs as an add-on feature to JasperReports Server to provide OLAP based data analysis capabilities.
The Jedox Base Business Intelligence solution provides OLAP Server,Free Excel client (Jedox Excel Add-in), No limit on database size, dimensions or number of users.All the data the Jedox OLAP Server holds is organized in cubes, dimensions, elements and element attributes. This approach to data modelling has proven very successful as it accurately reflects the way users think of their business. Jedox also offers multidimensional, real-time aggregation and calculation capability. Jedox OLAP Server also supports real time modelling. Jedox OLAP offers a variety of ways to extend the application via API and standard serial interfaces.
SpagoBI is an open source business intelligence suite, founded and supported by the Engineering Group. It offers a large range of analytical functions, a highly functional semantic layer and a set of advanced data visualization features including geospatial analytics. SpagoBI Server is the main module of the suite, which offers the core and analytical functionalities. It provides two conceptual models known as analytical model and behavioural model. Also provided are administration tools and cross platform services. The analytical model is the core of SpagoBI Server and covers a range of analytical needs. The behavioural model regulates the visibility over documents and data, according to the end-users’ roles. The administration tools provide various functionalities, such as: scheduler, import/export, user profile system, menu management, audit & monitoring, subscription management and graphical interfaces. The cross platform services include the platform common features that can be used on all analytical areas such as SSO, alert and notification, workflow, search engine, collaborative tools, rules engine etc.
7. ART – A Reporting Tool.
ART stands for A Reporting Tool and is a free Open Source Business Intelligence solution .ART is a lightweight, multiplatform, web based query tool and reporting environment. SQL queries can be published in a few minutes. It supports tabular, crosstab, charts, scheduling, email alerts, drill down, among other features. Results are exportable to spreadsheet/pdf, can be reversed to a database table (cached), can be embedded in a portal-like page or retrieved via a smartphone.
Widestage is a Lightweight Open Source Business Intelligence and reporting tool for mongodb, postgresql, Mysql, & MS sql. Widestage supports Mongodb, Postgresql, Mysql and MS sql to feed your reports, and you can configure as much data sources as you need. Widestage let you to create different semantic layers to allow your users create their own reports without need to know your data structure.
9. Pentaho Reporting
Pentaho Reporting are Open Source reporting tools for the creation of relational and analytical reports from a variety of data-sources. Report Designer is a desktop reporting tool that provides a visual design environment. Reporting Engine is an embeddable JAVA reporting library that is used by the report designer to generate reports. Reporting Software Developers Kit (SDK) is a packaging of the Classic Engine.
The open source project JMagallanes is an end user application for Olap and Dynamic Reports written in Java/J2EE. It combines static reports (based on JasperReports), a Swing pivot table for OLAP analysis, and charts (based on JFreeChart).
OpenReports is a powerful, flexible, and easy to use open source web reporting solution that provides browser based, parameter driven, dynamic report generation and flexible report scheduling capabilities.
Seal Report is an Open Source for the Microsoft .Net Framework entirely written in C#. The main features include Dynamic SQL sources, Native Pivot Tables, HTML 5 Charts and Microsoft Charts, HTML Rendering using Razor engine, Web Report Server and Task scheduler. The Dynamic SQL sources use either the SQL or let the Seal engine build dynamically the SQL used to query the database. Native Pivot Tables let to simply drag and drop elements directly in a pivot table (Cross Tab) and display them in report. HTML 5 Charts and Microsoft Charts are available to define and display Chart Series in two mouse clicks. HTML Rendering using Razor engine make use of the power of HTML5 in the report result such as JQuery Tabs, Tables sorting and filtering. Web Report Server publish the reports on the web.
OpenI provides a web-driven interface to build and publish interactive reports from OLAP data sources.OpenI provides a clean, intuitive interface to connect to different types of data sources, and to publish web-based interactive reports.OpenI is a J2EE web application, with the default implementation running on top of tomcat and uses data-source specific report definition languages (RDL’s) to define and track the reports created on the platform
NextReports provides NextReports Designer, NextReports Engine and NextReports Server. NextReports Designer is an AdHoc Query and Reporting software that promotes simple, fast and powerful report creation, which runs on any operating system that supports Java 1.7 . NextReports Engine is a lightweight java reporting engine that could be embedded in any application or used on their own. NextReports Server is a reporting server that helps automating production and delivery of business reports.
Rapidminer is the leader in open source provider for data mining and business analytics. The community edition is open source which can be downloaded from website.RapidMiner Server lets to run processes on enterprise hardware from anywhere, without restrictions.
Mondrian is an Open Source Business Analytics engine written in Java that enables business users access to their data for interactive analysis. With Mondrian as Online Analytical Processing (OLAP) engine, business users can enable multidimensional queries against data, using the MDX query language.
KNIME, the Konstanz Information Miner is an open source data analytics, reporting and integration platform. KNIME integrates various components for machine learning and data mining through its modular data pipelining concept. A graphical user interface allows assembly of nodes for data pre processing, for Extraction, Transformation, Loading, for modeling and data analysis and visualization.There are different modules for data integration such as file I/O, database nodes supporting all common database management systems and data transformation such as filter, converter, combiner and for data analysis and visualization. Using Report Designer extension, KNIME workflows can be used as data sets to create report templates that can be exported to different document formats.
Open Source Commercial Business Intelligence Solution
Pentaho offers a suite of open source Business Intelligence products called Pentaho Business Analytics providing data integration, OLAP services, reporting, dashboarding, data mining and ETL capabilities.
The Pentaho suite consists of two offerings, an enterprise and community edition. The enterprise edition contains extra features not found in the community edition. The enterprise edition is obtained through an annual subscription and includes extra support services. Pentaho’s core offering is frequently enhanced by add-on products, usually in the form of plugins, from the company itself and also the broader community of users and enthusiasts.Mondrian is an open source OLAP server, written in Java. It supports the MDX (multidimensional expressions) query language and the XML. It reads from SQL and other data sources and aggregates data in a memory cache.
Jaspersoft is a commercial open source software vendor focused on business intelligence, including data visualization, reporting, and analytics. Jaspersoft provides commercial and open source software, support, services, and licensing around the JasperReports, JasperReports Server, Jaspersoft Studio, iReport, and Jaspersoft ETL products. Jaspersoft’s main related product is JasperReports Server, a Java web application that provides advanced report server capabilities such as report scheduling, permissions, ad hoc reporting, dashboards, and multi-tenancy. It is offered in a community open source edition as well as under several commercial editions with broad support for various databases and data sources, including NoSQL and other big data datasources.
Palo is a memory resident multidimensional (online analytical processing (OLAP) or multidimensional online analytical processing (MOLAP)) database server and typically used as a business intelligence tool for controlling and budgeting purposes with spreadsheet software acting as the user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage.
Jedox OLAP Server continues to be offered free of charge as commercial open source software under the name of PALO. There is also an open-source integration with OpenOffice named PalOOCa (Palo for OpenOffice.org Calc).
Actuate Corporation is creation of the open source Eclipse BIRT business data reporting project launched by the Eclipse Foundation in 2004. Actuate’s primary commercial offerings include the BIRT Designers, and the BIRT iHub development and deployment platform for developers.
TACTIC is a dynamic, open-source, web-based platform that allows users to manage the development and delivery of digital assets through the entire content creation process. Designed for busy work environments with high volumes of content traffic, TACTIC streamlines workflow by applying business logic to disparate data and file system environments and to dynamically visualize every aspect through web based delivery. The platform seamlessly combines elements of DAM, PAM, CMS and ECM technologies, offering users a set of tools to create a wide range of customized enterprise workflow solutions.
6. Helical Insight
Helical Insight, of course, provides features expected of a BI tool such as email scheduling, visualization, exporting, multi-tenancy, user role management, etc.
For a review of the top free Extract, Transform, and Load, ETL Software, click on the button below:
Top Free Extract, Transform, and Load, ETL Software
For a review of the top Cloud – SaaS – OnDemand Business Intelligence Solutions, click on the button below:
Cloud – SaaS – OnDemand Business Intelligence Solutions
For a review of Online Analytical Processing Tools click on the button below :
Online Analytical Processing Tools