[Post] Open-source Bi KIT tools

Summary of open-source Bi KIT tools

There are a lot of commercial Bi suites. Similarly, there are also a lot of open-source Bi suites, but they are not shared, so many excellent Bi suites are not used. The open-source Bi suite summarized below focuses on OLAP multi-dimensional analysis and visualized expression. Of course, there is also a lot of report tools that everyone needs. 1. pentaho It's a big success. Its functions include data mining, data analysis, and data reporting. It also supports flexible custom applications. 2.Spagobi Not comparablePentahoPoor, it is based onJ2EEArchitecture, supportPortal, Report, OLAP, QBeETL, document management, metadata management, data mining, and graphical analysis. 3.Jaspersoft YesJasperreportThere should be a lot of people. Therefore, the Bi Kit it provides is certainly good. 4.Openi I have mentioned this in my previous articles. Many companies develop their own products based on it. It is suitable for small projects, so it is easy to build. 5.July JulyUses jstl labels for rendering and display.OLAPNavigation, which also supportsXmlaData source. AboveOpeniIs to useJulyFor rendering. 6.Mondrian MondrianYesJavaDevelopedOLAPThe server can handle massive volumes of data without writing SQL statements.DatasetAnalysis.MaxConvertSQL. 7.Rex Warehouse ExplorerIt usesJavaOpen a client dedicated for viewing multi-dimensional data sources, and supportXmlaProtocol, and its GUI is very good. 8. Jrubik It is mainly usedOLAPData Source, mainlyMondrianAndXmlaServer for data navigation and reports. It is based onJulyComponent development, of course not oursSwing. 9. Pocolap This is based onWebThe reporting tool has an onlineDemoYes.   10. BirtDynamic report What you are familiarEclipseIs mainly used for dynamic reports.