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 (e.g. lists, tables, crosstabs, reports) 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 flexible and user-friendly OLAP engines. 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 allows users to aggregate several documents into a single view and to interact with them in an dynamic and intuitive way. |
 |
AD-HOC REPORTING 1 engine: Worksheet SpagoBI allows end-users to freely create their own multi-sheet reports, including simple tables, cross-tables and different chart types in the document layout. |
 |
LOCATION INTELLIGENCE 2 engines: GEO, GIS SpagoBI offers two geographical engines allowing to set run-time connections between geographical data and business data stored in 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 queries through an entirely graphical and web-based interface. They can also 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 based on the common touch-screen interaction paradigm, to efficiently combine BI with mobility. |
 |
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 2013
