Open source BI tools

Business intelligence tools are a type of application software designed to report, analyze and present data. The tools generally read data that have been previously stored, often, though not necessarily, in a data warehouse or data mart.

Types of business intelligence tools
The key general categories of business intelligence tools are:

Spreadsheets[1]
Reporting and querying software - are tools that extract, sort, summarize, and present selected data
OLAP
Digital Dashboards
Data mining
Process mining
Business performance management
Local information systems
Except for spreadsheets, these tools are sold as standalone tools, suites of tools, components of ERP systems, or as components of software targeted to a specific industry. The tools are sometimes packaged into data warehouse appliances.

Except for spreadsheets, these tools are sold as standalone tools, suites of tools, components of ERP systems, or as components of software targeted to a specific industry. The tools are sometimes packaged into data warehouse appliances.

[edit] Open source free products
Eclipse BIRT Project: Eclipse-based open source reporting for web applications, especially those based on Java EE.
JasperSoft offers a version of JasperReports called JasperReports Community which has comprehensive basic reporting capabilities. A commercial edition is also available with more features.
RapidMiner community edition (formerly YALE) is an open-source software for data analysis, knowledge discovery, data mining, predictive analytics, and machine learning. A commercial edition is also available with more features.
SpagoBI: uses Free Open Source Software tools to provide a unified Free Platform for the development of Business Intelligence solutions at enterprise level.


[edit] Open source commercial products
Palo (OLAP database): OLAP Server, Worksheet Server and ETL Server
Pentaho: Reporting, analysis, dashboard, data mining and workflow capabilities
[edit] Proprietary free products
Freereporting.com: Free browser-based reporting software by LogiXML, available for .NET or Java. More advanced BI features such as dashboards, analysis grid and interactive data viewer are not offered in Freereporting.com but are available in LogiXML's full-featured managed reporting software, Logi Info.
InetSoft offers Visualize Free as a Web-only based visualization application where you upload your data to their server.
MicroStrategy offers a non-restricted free version of their MicroStrategy Reporting Suite.
[edit] Proprietary products
ACE*COMM
Ab Initio
ActiveReports
Actuate
COA Solutions
ComArch
CyberQuery
Data Applied
Dimensional Insight
HP Neoview
IBM
Applix
Cognos
InetSoft
Informatica
Information Builders
InfoZoom
Izenda
Jreport
LogiXML
LucidEra
Microsoft
SQL Server Analysis Services
PerformancePoint Server 2007
Proclarity
MicroStrategy
m-Power
Oracle Corporation
Hyperion Solutions Corporation
Oracle Business Intelligence Suite Enterprise Edition
Panorama Software
Pebble Reports
Pentaho
Pervasive DataRush
Pilot Software, Inc.
PRELYTIS
Qliktech
SAP Business Information Warehouse
Business Objects
OutlookSoft
SAS Institute
Siebel Systems
Spotfire (now Tibco)
StatSoft
SPSS
Sybase IQ
Tableau Software
Teradata
Thomson Data Analyzer


Reference :http://en.wikipedia.org/wiki/Business_intelligence_tools#Open_source_free_products

Date : 01-March-2010