SpagoBI is an Open Source Business Intelligence suite, which offers a large range of analytical functions, a functional semantic layer and a set of advanced data visualization features including geospatial analytics.
Business Intelligence Software
Knowage (SpagoBI) is an Open Source Business Intelligence suite, which offers a large range of analytical functions, a functional semantic layer and a set of advanced data visualization features including geospatial analytics. The modules of SpagoBI suite are SpagoBI Server, SpagoBI Studio, SpagoBI Meta and SpagoBI SDK.SpagoBI Server is the main module of the suite, offering the core and analytical functionalities. It provides two conceptual models which are called Analytical Model and Behavioural Model, administration tools and cross-platform services.
SpagoBI Studio allows the developer to design and modify analytical documents such as reports, charts, GEO and cockpits. SpagoBI Meta is focused on metadata management and inquiry. SpagoBI SDK is the tool used for the integration of the services provided by the server.
The Analytical function covered are reports, to show structured data in a pixel-perfect way, OLAP analysis, to navigate through data, Graphs, providing simple and intuitive views of the information, real-time dashboards, to monitor the KPIs, KPI models, to build and test one's own performance monitoring model, Geo-referenced reporting, to publish data over a geographical representation, Cockpits, to realize complex and interactive dashboards, free Inquiry (QbE), to build one's own query and generate the first report template, and data mining processes, to discover hidden information.
SpagoBI allows to realize structured reports, using structured information views such as lists, tables, crosstabs, reports and to export them using several formats such as HTML, PDF, XLS, XML, TXT, CSV, RTF. SpagoBI allows the multidimensional analysis through flexible and user-friendly OLAP engines. Users can analyze data on different detail levels and from different perspectives, through drill-down, drill-across, slice-and-dice, drill-through processes.
SpagoBI offers a specific analytical engine based on JFreeChart for the development of single ready-to-use chart widgets such as histograms, pie charts, bar charts, area charts, scatter diagrams, line charts, bubble charts, dispersion charts and interactive ones temporal sliders, add/delete series, to be used separately or to be aggregated into a report for a richer data analysis. SpagoBI offers all necessary tools to create, manage, view and browse KPI hierarchy models, through different methods, calculation rules, thresholds and alarm rules. SpagoBI allows users to aggregate several documents into a single view and to interact with them in a dynamic and intuitive way.
SpagoBI allows end-users to freely create their own multi-sheet reports, including simple tables, cross-tables and charts in the document template. SpagoBI offers two geographical engines allowing to set run-time connections between geographical data and business data stored in the data warehouse.