SpagoBI
Encyclopedia
SpagoBI is the only entirely Open Source
Business Intelligence
suite, belonging to the free/open source
SpagoWorld initiative, founded and supported by Engineering Group..
SpagoBI supports day-to-day and strategic business, both at the decision-making and operational levels. SpagoBI is a BI
suite
because it covers the whole range of analytical needs, supporting developers, testers and administrators in their daily activities.
SpagoBI is open source
because it is released under the GNU LGPL license, which protects the freedom to run, copy, distribute, study, change and improve the software, allowing its commercial use.
SpagoBI is hosted by OW2 forge, contributing to the durable and collaborative development of a long-lasting ecosystem. OW2 Consortium, an independent and no-profit organization, guaranties the availability of open source licenses over time.
The Analytical Model is the core of SpagoBI Server and covers the whole range of analytical needs, providing many solutions for each analytical area:
The Behavioural Model regulates the visibility over documents and data, according to the end-users' roles. It allows to reduce the required number of analytical documents, to guarantee the uniform growth of the project over time and the respect of the visibility rules.
The Administration Tools support developers, testers and administrators in their daily work, providing various functionalities, such as: scheduler, import/export, user profile system, menu management, audit & monitoring, subscription management and graphical interfaces for every kind of settings.
The Cross Services include the platform common features that can be used on all analytical areas: SSO, alert and notification, workflow, search engine, collaborative tools, rules engine, delivery by e-mail, ranking, exporters, RT events, personal folders, cross navigation and metadata visualization.
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
Business Intelligence
Business intelligence
Business intelligence mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes....
suite, belonging to the free/open source
Foss
Foss may refer toPeople*Foss , people with the last name Foss*Foss Shanahan , New Zealand diplomat*Foss Westcott , English bishop...
SpagoWorld initiative, founded and supported by Engineering Group..
SpagoBI supports day-to-day and strategic business, both at the decision-making and operational levels. SpagoBI is a BI
Business intelligence
Business intelligence mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes....
suite
Software suite
A software suite or application suite is a collection of computer programs, usually application software and programming software of related functionality, often sharing a more-or-less common user interface and some ability to smoothly exchange data with each other.Sometimes software makers...
because it covers the whole range of analytical needs, supporting developers, testers and administrators in their daily activities.
SpagoBI is open source
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
because it is released under the GNU LGPL license, which protects the freedom to run, copy, distribute, study, change and improve the software, allowing its commercial use.
SpagoBI is hosted by OW2 forge, contributing to the durable and collaborative development of a long-lasting ecosystem. OW2 Consortium, an independent and no-profit organization, guaranties the availability of open source licenses over time.
SpagoBI Server
SpagoBI Server is the main module of the suite, offering all the core and analytical functionalities. It is based on two main conceptual models (Analytical Model, Behavioural Model) and it provides all necessary administrative tools and cross-platform services.The Analytical Model is the core of SpagoBI Server and covers the whole range of analytical needs, providing many solutions for each analytical area:
- ReportsReportA report is a textual work made with the specific intention of relaying information or recounting certain events in a widely presentable form....
, to show structured data in a pixel-perfect way - OLAP analysisOLAPIn computing, online analytical processing, or OLAP , is an approach to swiftly answer multi-dimensional analytical queries. OLAP is part of the broader category of business intelligence, which also encompasses relational reporting and data mining...
, 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 reportingLocation intelligenceLocation Intelligence is the capacity to organize and understand complex phenomena through the use of geographic relationships inherent in all information. By combining geographic- and location-related data with other business data, organizations can gain critical insights, make better decisions...
, to publish data over a geographical representation - Cockpits, to realize complex and interactive dashboards
- Free Inquiry (QbE), to freely build one's own query and generate the first report template
- Data mining processesData miningData mining , a relatively young and interdisciplinary field of computer science is the process of discovering new patterns from large data sets involving methods at the intersection of artificial intelligence, machine learning, statistics and database systems...
, to discover hidden information - Office Documents, to publish Office documents under the behavioural model control
- Analytical Dossiers, to collect documents with personal notes
- Accessible Reports, in compliance with the international standard WCAG 2.0 and the Italian law
- Real-time console, to monitor applications
- Smart Filter, for the guided data selection
- External Process, to execute external processes that can interact with OLTP systems
- ETLExtract, transform, loadExtract, transform and load is a process in database usage and especially in data warehousing that involves:* Extracting data from outside sources* Transforming it to fit operational needs...
/ EIIEnterprise Information IntegrationEnterprise Information Integration , is a process of information integration, using data abstraction to provide a unified interface for viewing all the data within an organization, and a single set of structures and naming conventions to represent this data; the goal of EII is to get a large set of...
processes, to collect data from different sources.
The Behavioural Model regulates the visibility over documents and data, according to the end-users' roles. It allows to reduce the required number of analytical documents, to guarantee the uniform growth of the project over time and the respect of the visibility rules.
The Administration Tools support developers, testers and administrators in their daily work, providing various functionalities, such as: scheduler, import/export, user profile system, menu management, audit & monitoring, subscription management and graphical interfaces for every kind of settings.
The Cross Services include the platform common features that can be used on all analytical areas: SSO, alert and notification, workflow, search engine, collaborative tools, rules engine, delivery by e-mail, ranking, exporters, RT events, personal folders, cross navigation and metadata visualization.