50 Open Source Replacements for Proprietary Business Intelligence Software: Page 4

From simple spreadsheet applications to complete BI suites, the open source community has created dozens of applications that help enterprises store and analyze business data.


How to Help Your Business Become an AI Early Adopter

(Page 4 of 4)

38. SPMF

Replaces SAS Predictive Analytics, Oracle Data Miner, Statistica

Also Java-based, SPMF began life as a sequential pattern mining framework (hence the SPMF acronym). Since then, the project has expanded in scope and also includes association rule mining, sequential rule mining and frequent itemset mining algorithms. Operating System: OS Independent.

39. Rattle

Replaces SAS Predictive Analytics, Oracle Data Miner, Statistica

Short for "R Analytical Tool To Learn Easily," Rattle offers a graphical interface to perform data mining tasks using the R programming language. It can summarize data statistically or visually, build models, score datasets and more. Operating System: Windows, Linux, OS X.

ERP Solutions with BI Features

40. Openbravo ERP

Replaces: NetSuite , Microsoft Dynamics

A complete enterprise resource management solution, Openbravo also includes business intelligence capabilities like reporting, multidimensional analysis (OLAP) and balanced scorecards. The paid basic and professional editions add support and features not found in the open source community edition. Operating System: Windows, Linux, OS X.

41. ADempiere

Replaces: NetSuite , Microsoft Dynamics

This ERP suite incorporates the BI capabilities of the Pentaho suite. Although plenty of documentation and community support is available, this community-run project does not offer paid support. Operating System: Windows, Linux, OS X.

42. Compiere

Replaces: NetSuite , Microsoft Dynamics

The Compiere ERP and CRM solution includes several BI functions, including dashboards and reporting. It comes in community and enterprise editions that can be deployed on premise or in Amazon's cloud. Operating System: Windows, Linux, OS X.

43. JFire

Replaces: NetSuite , Microsoft Dynamics

JFire describes is both a full-featured Java-based ERP suite and a platform for building customized business applications. The ERP suite includes BIRT integration for BI and reporting. Support and services are available through third parties or through project owner NightLabs. Operating System: OS Independent.

44. Opentaps

Replaces: NetSuite , Microsoft Dynamics

Used by enterprises like Toyota and Honeywell, Opentaps is a full-featured ERP suite with ecommerce, customer relationship management, warehouse and inventory management, supply chain management, financial management and business intelligence capabilities. It's also available in a professional edition that can be deployed on premise or on Amazon Web Services. Operating System: Windows, Linux.

45. ]project-open[

Replaces: NetSuite , Microsoft Dynamics

Downloaded more than 150,000 times, project-open aims to bridge the gap between ERP and project management. The core (free) software includes basic reporting, but more advanced business intelligence and data warehouse modules are available for a fee. Operating System: Windows, Linux.


46. OpenOffice Calc

Replaces Microsoft Excel

Apache's OpenOffice project offers word processing, spreadsheets, presentations, graphics, database software that is compatible with the Microsoft Office equivalents. The latest version of Open Office has been downloaded more than 3 million times since its release in early May. Those who have used Excel will find Calc very similar. Operating System: Windows, Linux, OS X.

47. LibreOffice Calc

Replaces Microsoft Excel

A community fork of OpenOffice, LibreOffice's version of Calc also offers a look and feel similar to Excel with support for Excel file formats. It also includes several advanced feature for BI professionals, including Advanced DataPilot technology, natural language formulas, scenario manager and more. Operating System: Windows, Linux, OS X.

48. KOffice KCells

Replaces Microsoft Excel

KDE's office productivity suite also includes a spreadsheet application. Although the interface is quite a bit different than Excel, OpenOffice and LibreOffice, users generally report that it's fairly intuitive. Key features include built-in templates and a comprehensive formula list. Operating System: Windows, Linux, OS X.

49. Gnumeric

Replaces Microsoft Excel

Gnumeric isn't part of a comprehensive office productivity suite--it's a standalone spreadsheet. Although the interface is similar to Excel's and it imports Excel files, it's not meant to be an Excel clone. It offers all of Excel's functions, plus 153 more, and reports have praised Gnumeric as more accurate than commercial spreadsheet software. Operating System: Windows, Linux.

50. Sparklines for Excel

Replaces Microsoft Excel's standard graphics

Sparklines doesn't replace Excel--it extends its functionality with new functions that create simple, intense graphics known as Sparklines. See the user manuals for examples of the type of charts and graphs it can create. Operating System: Windows.

Page 4 of 4

Previous Page
1 2 3 4

Tags: open source, business intelligence, BI, analytics

0 Comments (click to add your comment)
Comment and Contribute


(Maximum characters: 1200). You have characters left.



IT Management Daily
Don't miss an article. Subscribe to our newsletter below.

By submitting your information, you agree that datamation.com may send you Datamation offers via email, phone and text message, as well as email offers about other products and services that Datamation believes may be of interest to you. Datamation will process your information in accordance with the Quinstreet Privacy Policy.