business intelligence

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.

 

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

 

olap Multidimensional analysis (OLAP)
Expore your data on different detail levels and from different perspectives, through drill-down, drill-across, slice-and-dice, drill-through processes.

 

charts Charts
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!

 

kpi KPIs
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.

 

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

 

adhocreporting Ad-hoc reporting
Self-create your multi-sheet reports, including tables, cross-tables and charts.

 

locationintelligence 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.

 

freeinquiry 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.

 

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

 

networkanalysis 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).

 

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

 

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

 

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

 

masterdata 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.

 

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

 

Architecture

Architecture

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).

Analytics

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.