BI components of SpagoBI, the only 100% open source, complete and flexible business intelligence suite
SpagoBI is the only entirely Open Source Business Intelligence suite. It covers all the analytical areas of Business Intelligence projects, with innovative themes and engines. SpagoBI offers a wide range of analytical tools, as follows.Have a look at the SpagoBI analytical engines full list, by Module and Analytical Area.
 |
REPORTING 4 engines: JasperReport, BIRT, Accessible report, BO SpagoBI allows to realize structured reports, using structured information views (ex. lists, tables, crosstabs, graphs) and to export them using several formats (HTML, PDF, XLS, XML, TXT, CSV, RTF). |
 |
MULTIDIMENSIONAL ANALYSIS (OLAP) 3 engines: Jpivot/Mondrian, JPalo/Mondrian, JPXMLA SpagoBI allows the multidimensional analysis through OLAP engines, which are more flexible and user-friendly, compared to structured reports. After having set the analysis axis according to hierarchies and observed measures, the users can monitor the data on different detail levels and from different perspectives, through drill-down, drill-across, slice-and-dice, drill-through processes. |
 |
CHARTS 3 engines: JFreeChart, HChart, ExtChart SpagoBI offers a specific graphics engine, based on JFreeChart, which allows to develop single ready-to-use graphical widgets (such as histograms, pie graphs, bar graphs, area graphs, scatter diagrams, line graphs, bubble graphs, dispersion graphs) and interactive ones (temporal sliders, add/delete series), to be used separately, by choosing the properties to be included into the reports for a richer data view. |
 |
KPI 1 engine: KPI SpagoBI offers all the necessary tools to create, manage, view and browse KPI hierarchical models, through different methods, calculation rules, thresholds and alarm rules. |
 |
INTERACTIVE COCKPITS 2 engines: composed document, in-memory (1) SpagoBI offers a specific engine for the realization of complex cockpits which allow to aggregate several documents into a single view, connecting them with one another, fostering their interactive and intuitive usage. |
 |
AD-HOC REPORTING 1 engine: Worksheet Thanks to its Worksheet engine, SpagoBI allows end-users to freely create their own multi-sheet reports, by defining simple tables, cross-tables and different chart types in their document layout. |
 |
LOCATION INTELLIGENCE 2 engines: GEO, GIS SpagoBI offers two geographical engines allowing to set run-time connections between the geographical data and the business data of the Data Warehouse:
|
 |
FREE INQUIRY (Driven Data Selection) 2 engines: QbE, Smart Filter SpagoBI offers a QbE (Query by Example) engine, which is suitable for those cases in which the free inquiry of data and the extraction of data are more important than their graphical structure and structural layout. Users can build their own queries through an entirely graphical modality. Moreover, they can execute queries, check the results, export them, save them for future use and generate reporting templates. |
 |
DATA MINING 2 engines: Weka, R (1) SpagoBI allows advanced data analysis, thanks to Data Mining processes aiming to find out hidden information patterns among a great amount of data. |
 |
REAL TIME DASHBOARDS AND CONSOLE 2 engines: Dash, Console SpagoBI offers a specific engine allowing to produce real-time monitoring consoles, to be used in Business, applicative or BAM processes. |
 |
COLLABORATION 1 engine: Analytical Dossier SpagoBI offers a specific engine allowing to automatically create organized report dossiers, enriched with the attending notes and information, posted by users to comment data. A collaborative workflow manages the dossier components to be sent to users in order to receive their notes. |
 |
OFFICE AUTOMATION 1 engine: Office SpagoBI offers a specific engine for the publication of personal documents in BI environments, realized through common Office tools (Open Office or MS Office). |
 |
ETL 1 engine: Talend SpagoBI allows to load data into the data warehouse and manage it. SpagoBI ETL engine integrates the open source product TOS (Talend Open Studio). |
 |
MOBILE 4 engines: Table, Chart, Cockpit, KPI (1) SpagoBI offers specialized components that follow the common devices interaction touch-screen paradigm, conceived for an efficient off-line workability. |
 |
EXTERNAL PROCESSES 1 engine: CommonJ SpagoBI offers a component that allows to manage customized processes, running in the background and/or starting at a scheduled time. |
 |
MASTER DATA MANAGEMENT 1 engine: Registry (QbE) SpagoBI offers a component that allows users to take advantage of write-back functionalities on the database. It allows them to modify the table data through a highly intuitive user interface, whose behavior can be set by means of simple configuration parameters, using pre-defined models available within the platform. |
(1) Available through 2012
