25 Open Source and Free Business Intelligence Solutions

http://www.predictiveanalyticstoday.com/open-source-free-business-intelligence-solutions/

1.Jedox Base

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?0?2 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.
Jedox Base


Jedox base Business Intelligence solution
2. JasperReports Server


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.
JasperReports Server


JasperReportsServer
 
3. BIRT


BIRT is an open source Eclipse based reporting system from Eclipse Foundation which integrates with Java/Java EE application to produce compelling reports. 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.
BIRT


Eclipse BIRT Project
4. SpagoBI




 


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.
SpagoBI


SpagoBI
5. ReportServer


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.
ReportServer


6. 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.
ART – A Reporting Tool


ART stands for A Reporting Tool
7. 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.
Pentaho Reporting


Pentaho Reporting
8. JMagallanes


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).
JMagallanes


JMagallanes
9.OpenReports


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.
OpenReports
10.Openi


Openi provides end to end Business intelligence solution. The solution includes dashboards, interactive reporting, etl, dimensional modeling, olap cube design and predictive models.
Openi
11.ERP BI Solutions


ERP BI Solutions provides business intelligence solutions for popular open source ERP systems including PostBooks and xTuple ERP.
ERP BI Solutions
12. Pentaho Community Edition


Pentaho Community Edition suite includes ETL, OLAP analysis, metadata, data mining, reporting, dashboards and a platform that allows you to create complex solutions to business problems.
Pentaho Community Edition


Pentaho Community Edition
13. Rapidminer


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
14. Mondrian


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.
Mondrian
15. KNIME


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.
KNIME


Knime
2) Free Proprietary Business Intelligence Solutions


1.InetSoft Technology Corporation


InetSoft Technology Corporation offers various applications that focus on operational BI, enterprise reporting, data visualization and embeddable reporting.
Style Scope Free Edition is a small footprint server that delivers web based interactive flash dashboards and visualizations that can be shared within an organization. It provides support for multi source data mashups and full admin and permission controls.
Visualize Free is a visual analysis application that allows users to explore their own data visually and interactively. It requires no software installation. Style Chart is a charting engine and JavaScript API for Web developers to embed charts and graphs in Web pages via AJAX.
InetSoft


InetSoft Technology Corporation
2. QlikView


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.
QlikView


QlikView Personal Edition
3. SAP Lumira




 


SAP Lumira delivers beautiful analytics, allowing to easily convey and share knowledge to discover hidden patterns and transform the business. SAP Lumira, personal edition build interactive visualizations to analyze spreadsheet data for insights to analyse, share. This helps to surface the issues and spot anomalies immediately, and let you to drill into details or iterate with more data for a more complete picture.
SAP Lumira


SAP Lumira
4.icCube


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.
icCube
5. 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.
Tableau Public
3) Open Source Commercial Business Intelligence Solution


1.Pentaho


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.
Pentaho
2.Jaspersoft


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.
Jaspersoft
3.Palo


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).
Palo
4.Actuate Corporation


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.
Actuate
5. TACTIC


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.