From 6.0 version SpagoBI is released as


KNOWAGE is the evolution of SpagoBI: a more mature product that best meets the criteria of modern business intelligence and advanced analysis of traditional sources and big data. Upgrade to KNOWAGE!


BI Components

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.




Realize structured reports and export them using the most suitable format (HTML, PDF, XLS, XML, TXT, CSV, RTF).



Multidimensional analysis (OLAP)

Explore your data on different detail levels and from different perspectives, through drill-down, drill-across, slice-and-dice, drill-through processes.




Develop ready-to-use charts according to your single charts (e.g. histograms, pie charts, bar charts, area charts, scatter diagrams, line charts, bubble charts, dispersion charts) and interactive ones (e.g. temporal sliders, add/delete series). Use it separately or aggregate them into a cockpit for a richer view on your data!




SpagoBI offers a complete set of tools to create, manage, view and browse KPI hierarchy models, through different methods, calculation rules, thresholds and alarm rules.



Interactive cockpits

Aggregate different analysis into a single view, set navigation paths, and explore your data a dynamic and graphical way.



Ad-hoc reporting

Self-create your multi-sheet reports, including tables, cross-tables and charts.



Location Intelligence

Visualize your business data on maps (i.e. static map catalogues or web mapping/feature services) and interact dynamically to get instant views.



Free Inquiry

A QbE (Query by Example) engine makes data exploration and navigation particularly intuitive and easy, thanks to an entirely graphical and web-based interface. Then save your queries for future use.



Data mining

Advanced data analysis allowing you to extract knowledge from large volumes of data, to improve your decision-making and business strategies.



Network analysis

Visualize and interpret relations among entities through specialized views. An entity can be animate (e.g. social media users) or inanimate (e.g. countries, companies, projects).




SpagoBI integrates the open source product TOS (Talend Open Studio), to load data into the data warehouse and managing them at your convenience.




Create structured report dossiers, enrich your analysis with personal notes and comments posted by users. Then share them through a collaborative workflow.



Office automation

Publish your personal documents into your BI environment, integrating common Office tools (Open Office or MS Office).



Masterdata management

Users can write back to the database and modify table data through an intuitive user interface, whose behavior can be set by means of simple configuration parameters, using pre-defined models.



External processes

Manage your analytical processes, which can run in the background or be scheduled to start and stop at a scheduled time.




Providing tools for each type of user

From business users and decision makers,
to developers and administrators.


SpagoBI is composed of the following main modules:

  • SpagoBI Server, the core of the suite including the analytical tools and features
  • SpagoBI Studio, the integrated development environment
  • SpagoBI Meta, the metadata environment
  • SpagoBI SDK, the integration layer allowing to use SpagoBI with external tools
  • SpagoBI Applications, a collection of vertical analytical models that are developed using SpagoBI.

The full list of analytical engines is available in the project Wiki here.
The full list of certified environments in available on the project Wiki here (SpagoBI Server) and here (SpagoBI Studio/Meta).


SpagoBI analytics are analytical models addressed to specific markets (i.e. e-government, financial risk management) or business domains (i.e. competitive intelligence, service intelligence, geo-marketing). Analytics leverage the full potential of SpagoBI suite to crate tailored solutions that meet users’ needs.