Description
SpagoBI offers powerful graphical data visualization tools, to manage KPI hierarchical models.
1
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The only 100% open source, complete and flexible
Business Intelligence suite
by SpagoBI Competency Center - Engineering Group
April 2012
SpagoBI was awarded
the Open Innovation Award
at Open World Forum 2011
2
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
A complete range of support services
Pay-as-you-go support services
The business intelligence comprehensive suite
All BI capabilities, many analytical areas, various engines
Unique solutions
Location Intelligence, Real-time BI and Mobile BI
Suitable for any requirement
Just-in-time BI, agile and sustainable developments
SpagoBI suite
100% open source, forever
Pure open source model, no software lock-in
3
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
100% open source, forever
Complete, robust, secure and scalable
Industry-grade
Highly extensible and customizable
Sustained by a large company and an open
community
Supported by a growing partner network
Why SpagoBI
4
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI supporters
Brazil
Benelux
Italy
Argentina
Lebanon
The leading Italian independent, privately-owned software and
Information Technology services company
One of the top 10 in Europe in software and services
43 branches in Italy, Belgium, Latin America and the MENA area
> 1B$ revenues in 2010, 1000 large accounts in all market sectors
www.eng.it www.eng.it
www.ow2.org www.ow2.org
6 major support centers in Italy provided by SpagoBI CC
4 international offices provided by SpagoBI CC
Support in 5 continents provided by partners
More than 100 SpagoBI customers worldwide
SpagoBI SpagoBI Competency Competency Center Center
The The working working unit unit of of the the Research Research & & Innovation Innovation
division division of of Engineering Group Engineering Group
www.spagobi.org www.spagobi.org
The global open source community granting open source availability, quality and
sustainability over time
An independent non-profit organization
> 100 organizations and 6,000 IT professionals in Europe, Asia and the Americas
5
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The SpagoBI Team
6
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The SpagoWorld History
7
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The complete and flexible BI suite
A wide range of analytical tools:
different engines for several analytical areas
Broad integration capabilities:
it provides quick results and easy deployment, even in
legacy environments
8
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
An Open Architecture
9
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Server
10
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows to produce reports
using structured information views
(lists, tables, crosstabs, graphs)
4 engines
JasperReport: leader in open
source reporting tools
BIRTReport: eclipse-based open
source reporting tool for web
applications
BO: displaying reports managed by
Business Objects 6.5
Accessibility: tabular reports
compliant to WCAG 2.0 accessibility
guidelines
SpagoBI Server analytical engines – Reporting
11
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows the
multidimensional analysis
through OLAP engines
3 engines
JPivot: access Mondrian servers
using a JPivot client
JPalo: access Mondrian servers
using a JPalo client
JPXMLA: access standard
XMLA engines (e.g. MS
Analysys Services) using a
JPivot client
SpagoBI Server analytical engines – OLAP
12
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
3 engines
JfreeCharts: specific engine
based on JFreeChart, to develop
graphical widgets
HighCharts: a specific engine to
develop highly dynamic graphs
ExtCharts: a new engine to
develop highly dynamic graphs
SpagoBI Server analytical engines – Charts
SpagoBI offers powerful graphical data visualization tools, to build interactive
dashboards and cockpits
13
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers powerful graphical data visualization tools, to build
interactive cockpits
SpagoBI Server analytical engines – Interactive Cockpits
2 engines
Composed document:
powerful specific engine to
build highly interactive
cockpits that aggregate
heterogeneous documents
In-memory: a tool to
increase performances and
interactivity, experiencing a
new analytical pattern,
based on incremental filters
(available through 2012)
14
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers powerful graphical data visualization tools, to manage KPI
hierarchical models
1 engine
KPI: powerful specific engine to create, manage, view and browse KPI hierarchical
models, through different methods, calculation rules, thresholds and alarm rules
SpagoBI Server analytical engines – KPI
15
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows advanced data analysis, thanks to Data Mining processes
aiming to identify hidden information patterns among a great amount of data
2 engines: Weka and R (the latter available through 2012)
SpagoBI Server analytical engines – Data Mining
16
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows to freely
inquiry a data warehouse
and to extract, filter and
combine the result sets
2 engines
QbE: allows to define
queries by means of drag-
and-drop operations. Results
can be used to produce
report templates
Smart Filter: allows users to
enquiry data using intuitive
web forms and filters
SpagoBI Server analytical engines – Free Inquiry
17
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Server analytical engines – Ad-hoc reporting
SpagoBI allows to define flat tables, pivot tables and different types of charts,
to be included in the document layout
1 engine
Worksheet : allows to
freely create multi-sheet
reports
18
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers geographical
engines to set up run-time
connections between
geographical and business data
2 engines
Geo: uses a static catalog of SVG
maps allowing the user to
dynamically re-aggregate
information
GIS: interacts with a spatial
system according to the
WFS/WMS standard
SpagoBI Server analytical engines – Location Intelligence
19
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
2 engines
Console: based on eclipse
eBAM
Dashboard: SWF visualization
engine to display real-time views
of data
SpagoBI Server analytical engines – Real Time
SpagoBI offers a specific engine to produce real-time monitoring consoles, to be used in
Business applications or in BAM (Business Activity Monitoring) processes
20
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
4 engines
MobileTable
MobileChart
MobileCockpit
MobileKPI (available through 2012)
SpagoBI Server analytical engines – Mobile
SpagoBI offers specialized components that follow the common devices interaction
touch-screen paradigm, conceived for an efficient off-line workability
21
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a specific engine for the publication of personal documents in
BI environments
SpagoBI Server analytical engines – Office Automation
1 engine
Office: allows to publish documents realized through common
Office tools (Open Office or MS Office).
22
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a specific engine allowing to automatically create organized
report dossiers
1 engine
Analytical dossier: allows to enrich shared dossiers with notes and information, posted
by users to comment data. A collaboration workflow manages the dossier components to
be sent to users in order to receive their notes.
SpagoBI Server analytical engines – Collaboration
23
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a component that allows to load data into the data warehouse
and manage it
1 engine
Talend: integrates the ETL open source product TOS (Talend Open Studio)
SpagoBI Server operational engines – ETL
24
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a component that allows to manage customized processes, running
in the background and/or starting at a scheduled time
1 engine
CommonJ: it includes pre-defined processes supporting the execution of shell commands
(Linux/Windows). This engine is integrated in the Console, which allows to start and stop
processes directly from the detail section.
SpagoBI Server operational engines – External Processes
25
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
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.
SpagoBI Server operational engines – Master Data Management
1 engine
QbE: a specific functionality named “Registry”, included in this engine, allows to work
on table data
26
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Studio is the development environment based on Eclipse. It allows the
developer to design and modify all analytical documents.
It supports users during the design of documents as well as during the
installation and testing processes, directly on SpagoBI Server.
SpagoBI Studio
27
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Meta
SpagoBI Meta is the module specifically focused on metadata management and
inquiry.
It manages both business metadata, enabling the user to know more about the
data under evaluation, and technical metadata allowing the administrator to know
where the data are taken from, to provide automatic documentation or to make
impact analyses.
28
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI SDK
SpagoBI SDK is the specific tool used for the integration of the services provided by the
server.
It is used by SpagoBI Studio in order to allow users to download/upload their analytical
documents from/onto the server. It aims both at the integration of the documents, thanks to
a wide range of services available through web service, and at the publication of SpagoBI
documents in an external portal.
The services available through web service are:
Data Set: to receive the data sets, defined in SpagoBI, and their respective metadata
Data Source: list of connections to the different databases
Engine: list and details of the engines, defined in SpagoBI Server
Map catalogue: list and details of the maps, available on the server
Analytical Documents: to recover the document list and the respective details, to
manage templates, to create and execute documents, and to display the results in a
PDF format.
29
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Applications
SpagoBI Analytics are applications that full exploit the potentials of the suite to
meet the market needs.
They are developed by market sector (i.e. e-government, financial risk
management), by subject (i.e. competitive intelligence, service intelligence,
geo-marketing) or by product, as a specific analytical component.
Analytics are composed of a data model and pre-defined analysis.
Look at the available SpagoBI Analytics at:
www.spagobi.org www.spagobi.org
30
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
How to use SpagoBI
A wide range of analytical tools and engines proving various
solutions for each analytical area
SpagoBI as a Server
On demand SpagoBI
Dedicated hardware and software resources, through which
SpagoBI CC realizes and hosts your BI projects. Immediate
results, avoiding any initial setup and configuration effort
Cloud SpagoBI
Thanks to this solution, you don’t need to deploy SpagoBI on
your servers or to buy the licenses of the related software
solutions. It provides an instance of SpagoBI Server through
a remote connection, against the payment of a monthly fee
Mobile SpagoBI
It allows you to display and analyze data anywhere, at any
time. Through SpagoBI real-time functionalities, you are kept
up to date in real-time with possible critical events, reported
by the operational systems, allowing you to react promptly
31
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
Ministry of Labour, Health and Social Policies - Italy
SpagoBI has been used for the realization of a decisional support system named
“NSIS Cockpit”, which provides analysis for the monitoring of the main aid levels of
the national health service.
www.ministerosalute.it www.ministerosalute.it
FIAT Group Automobiles - Italy
SpagoBI has been used for the realization of link.e.intelligence, the analytical
component of the .link product, aiming to support the selling activities of Fiat Group
Automobiles international distribution network.
www.fiatgroup.com www.fiatgroup.com
All SpagoBI Success Stories: www.spagobi.org www.spagobi.org
Who’s using SpagoBI
ENEL - Italy
SpagoBI suite has been used by ENEL, Italy's largest power company and Europe's
second listed utility by installed capacity, to optimize end user service management.
Through a Business Activity Monitoring application, it allows to monitor processes,
minimize gaps and maximize the company’s profit.
www.enel. www.enel.it it
32
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
USER SUPPORT & MAINTENANCE
Support prices starting at € 1,000
Pay-as-you-go maintenance services (the right to use the suite is separated from the purchase of support
services)
Modular maintenance prices, based on the number of analytical engines
Maintenance services based on a per-project pricing model, depending on analytical components/engines,
version and environment, with unlimited number of CPUs and users. The price of the first project starts at
€ 5,000. Entry-price level at € 12,000.
Full flexibility on the increase in the number of projects
With SpagoBI, the Open Source BI fits your needs and your budget
PROFESSIONAL SERVICES
Standard packages: Proof of Concepts, Quick Start
Ad-hoc packages, on-site consultancy
Development services, for SpagoBI suite and BI projects
TRAINING
In-class and on-site courses
Remote and recorded on-line courses
Tailored options
Free webinars
Certification test (2
nd
half 2012)
SpagoBI services
33
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
With SpagoBI, the Open Source BI fits your needs and your budget
ON-DEMAND & CLOUD SPAGOBI
On demand: your first SpagoBI project starting at € 5,000
Cloud: your own SpagoBI configuration paying a monthly fee;
subscribe now and you’ll just pay the maintenance costs
SPAGOWORLD SHOP
Easy access to SpagoBI remote services
Buy on-line remote and recorded training courses, SpagoBI book &
certification test (2
nd
half 2012)
SpagoBI services
34
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
http://www.caribbean-tour.com/Contact-Us.html
Find out all information
(demo, documentation, tutorials, services and much more)
and download all SpagoBI components at:
www.spagobi.org www.spagobi.org
References
Contact us
[email protected] [email protected]
doc_876136664.pdf
SpagoBI offers powerful graphical data visualization tools, to manage KPI hierarchical models.
1
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The only 100% open source, complete and flexible
Business Intelligence suite
by SpagoBI Competency Center - Engineering Group
April 2012
SpagoBI was awarded
the Open Innovation Award
at Open World Forum 2011
2
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
A complete range of support services
Pay-as-you-go support services
The business intelligence comprehensive suite
All BI capabilities, many analytical areas, various engines
Unique solutions
Location Intelligence, Real-time BI and Mobile BI
Suitable for any requirement
Just-in-time BI, agile and sustainable developments
SpagoBI suite
100% open source, forever
Pure open source model, no software lock-in
3
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
100% open source, forever
Complete, robust, secure and scalable
Industry-grade
Highly extensible and customizable
Sustained by a large company and an open
community
Supported by a growing partner network
Why SpagoBI
4
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI supporters
Brazil
Benelux
Italy
Argentina
Lebanon
The leading Italian independent, privately-owned software and
Information Technology services company
One of the top 10 in Europe in software and services
43 branches in Italy, Belgium, Latin America and the MENA area
> 1B$ revenues in 2010, 1000 large accounts in all market sectors
www.eng.it www.eng.it
www.ow2.org www.ow2.org
6 major support centers in Italy provided by SpagoBI CC
4 international offices provided by SpagoBI CC
Support in 5 continents provided by partners
More than 100 SpagoBI customers worldwide
SpagoBI SpagoBI Competency Competency Center Center
The The working working unit unit of of the the Research Research & & Innovation Innovation
division division of of Engineering Group Engineering Group
www.spagobi.org www.spagobi.org
The global open source community granting open source availability, quality and
sustainability over time
An independent non-profit organization
> 100 organizations and 6,000 IT professionals in Europe, Asia and the Americas
5
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The SpagoBI Team
6
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The SpagoWorld History
7
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
The complete and flexible BI suite
A wide range of analytical tools:
different engines for several analytical areas
Broad integration capabilities:
it provides quick results and easy deployment, even in
legacy environments
8
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
An Open Architecture
9
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Server
10
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows to produce reports
using structured information views
(lists, tables, crosstabs, graphs)
4 engines
JasperReport: leader in open
source reporting tools
BIRTReport: eclipse-based open
source reporting tool for web
applications
BO: displaying reports managed by
Business Objects 6.5
Accessibility: tabular reports
compliant to WCAG 2.0 accessibility
guidelines
SpagoBI Server analytical engines – Reporting
11
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows the
multidimensional analysis
through OLAP engines
3 engines
JPivot: access Mondrian servers
using a JPivot client
JPalo: access Mondrian servers
using a JPalo client
JPXMLA: access standard
XMLA engines (e.g. MS
Analysys Services) using a
JPivot client
SpagoBI Server analytical engines – OLAP
12
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
3 engines
JfreeCharts: specific engine
based on JFreeChart, to develop
graphical widgets
HighCharts: a specific engine to
develop highly dynamic graphs
ExtCharts: a new engine to
develop highly dynamic graphs
SpagoBI Server analytical engines – Charts
SpagoBI offers powerful graphical data visualization tools, to build interactive
dashboards and cockpits
13
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers powerful graphical data visualization tools, to build
interactive cockpits
SpagoBI Server analytical engines – Interactive Cockpits
2 engines
Composed document:
powerful specific engine to
build highly interactive
cockpits that aggregate
heterogeneous documents
In-memory: a tool to
increase performances and
interactivity, experiencing a
new analytical pattern,
based on incremental filters
(available through 2012)
14
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers powerful graphical data visualization tools, to manage KPI
hierarchical models
1 engine
KPI: powerful specific engine to create, manage, view and browse KPI hierarchical
models, through different methods, calculation rules, thresholds and alarm rules
SpagoBI Server analytical engines – KPI
15
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows advanced data analysis, thanks to Data Mining processes
aiming to identify hidden information patterns among a great amount of data
2 engines: Weka and R (the latter available through 2012)
SpagoBI Server analytical engines – Data Mining
16
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI allows to freely
inquiry a data warehouse
and to extract, filter and
combine the result sets
2 engines
QbE: allows to define
queries by means of drag-
and-drop operations. Results
can be used to produce
report templates
Smart Filter: allows users to
enquiry data using intuitive
web forms and filters
SpagoBI Server analytical engines – Free Inquiry
17
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Server analytical engines – Ad-hoc reporting
SpagoBI allows to define flat tables, pivot tables and different types of charts,
to be included in the document layout
1 engine
Worksheet : allows to
freely create multi-sheet
reports
18
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers geographical
engines to set up run-time
connections between
geographical and business data
2 engines
Geo: uses a static catalog of SVG
maps allowing the user to
dynamically re-aggregate
information
GIS: interacts with a spatial
system according to the
WFS/WMS standard
SpagoBI Server analytical engines – Location Intelligence
19
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
2 engines
Console: based on eclipse
eBAM
Dashboard: SWF visualization
engine to display real-time views
of data
SpagoBI Server analytical engines – Real Time
SpagoBI offers a specific engine to produce real-time monitoring consoles, to be used in
Business applications or in BAM (Business Activity Monitoring) processes
20
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
4 engines
MobileTable
MobileChart
MobileCockpit
MobileKPI (available through 2012)
SpagoBI Server analytical engines – Mobile
SpagoBI offers specialized components that follow the common devices interaction
touch-screen paradigm, conceived for an efficient off-line workability
21
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a specific engine for the publication of personal documents in
BI environments
SpagoBI Server analytical engines – Office Automation
1 engine
Office: allows to publish documents realized through common
Office tools (Open Office or MS Office).
22
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a specific engine allowing to automatically create organized
report dossiers
1 engine
Analytical dossier: allows to enrich shared dossiers with notes and information, posted
by users to comment data. A collaboration workflow manages the dossier components to
be sent to users in order to receive their notes.
SpagoBI Server analytical engines – Collaboration
23
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a component that allows to load data into the data warehouse
and manage it
1 engine
Talend: integrates the ETL open source product TOS (Talend Open Studio)
SpagoBI Server operational engines – ETL
24
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI offers a component that allows to manage customized processes, running
in the background and/or starting at a scheduled time
1 engine
CommonJ: it includes pre-defined processes supporting the execution of shell commands
(Linux/Windows). This engine is integrated in the Console, which allows to start and stop
processes directly from the detail section.
SpagoBI Server operational engines – External Processes
25
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
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.
SpagoBI Server operational engines – Master Data Management
1 engine
QbE: a specific functionality named “Registry”, included in this engine, allows to work
on table data
26
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Studio is the development environment based on Eclipse. It allows the
developer to design and modify all analytical documents.
It supports users during the design of documents as well as during the
installation and testing processes, directly on SpagoBI Server.
SpagoBI Studio
27
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Meta
SpagoBI Meta is the module specifically focused on metadata management and
inquiry.
It manages both business metadata, enabling the user to know more about the
data under evaluation, and technical metadata allowing the administrator to know
where the data are taken from, to provide automatic documentation or to make
impact analyses.
28
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI SDK
SpagoBI SDK is the specific tool used for the integration of the services provided by the
server.
It is used by SpagoBI Studio in order to allow users to download/upload their analytical
documents from/onto the server. It aims both at the integration of the documents, thanks to
a wide range of services available through web service, and at the publication of SpagoBI
documents in an external portal.
The services available through web service are:
Data Set: to receive the data sets, defined in SpagoBI, and their respective metadata
Data Source: list of connections to the different databases
Engine: list and details of the engines, defined in SpagoBI Server
Map catalogue: list and details of the maps, available on the server
Analytical Documents: to recover the document list and the respective details, to
manage templates, to create and execute documents, and to display the results in a
PDF format.
29
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
SpagoBI Applications
SpagoBI Analytics are applications that full exploit the potentials of the suite to
meet the market needs.
They are developed by market sector (i.e. e-government, financial risk
management), by subject (i.e. competitive intelligence, service intelligence,
geo-marketing) or by product, as a specific analytical component.
Analytics are composed of a data model and pre-defined analysis.
Look at the available SpagoBI Analytics at:
www.spagobi.org www.spagobi.org
30
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
How to use SpagoBI
A wide range of analytical tools and engines proving various
solutions for each analytical area
SpagoBI as a Server
On demand SpagoBI
Dedicated hardware and software resources, through which
SpagoBI CC realizes and hosts your BI projects. Immediate
results, avoiding any initial setup and configuration effort
Cloud SpagoBI
Thanks to this solution, you don’t need to deploy SpagoBI on
your servers or to buy the licenses of the related software
solutions. It provides an instance of SpagoBI Server through
a remote connection, against the payment of a monthly fee
Mobile SpagoBI
It allows you to display and analyze data anywhere, at any
time. Through SpagoBI real-time functionalities, you are kept
up to date in real-time with possible critical events, reported
by the operational systems, allowing you to react promptly
31
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
Ministry of Labour, Health and Social Policies - Italy
SpagoBI has been used for the realization of a decisional support system named
“NSIS Cockpit”, which provides analysis for the monitoring of the main aid levels of
the national health service.
www.ministerosalute.it www.ministerosalute.it
FIAT Group Automobiles - Italy
SpagoBI has been used for the realization of link.e.intelligence, the analytical
component of the .link product, aiming to support the selling activities of Fiat Group
Automobiles international distribution network.
www.fiatgroup.com www.fiatgroup.com
All SpagoBI Success Stories: www.spagobi.org www.spagobi.org
Who’s using SpagoBI
ENEL - Italy
SpagoBI suite has been used by ENEL, Italy's largest power company and Europe's
second listed utility by installed capacity, to optimize end user service management.
Through a Business Activity Monitoring application, it allows to monitor processes,
minimize gaps and maximize the company’s profit.
www.enel. www.enel.it it
32
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
USER SUPPORT & MAINTENANCE
Support prices starting at € 1,000
Pay-as-you-go maintenance services (the right to use the suite is separated from the purchase of support
services)
Modular maintenance prices, based on the number of analytical engines
Maintenance services based on a per-project pricing model, depending on analytical components/engines,
version and environment, with unlimited number of CPUs and users. The price of the first project starts at
€ 5,000. Entry-price level at € 12,000.
Full flexibility on the increase in the number of projects
With SpagoBI, the Open Source BI fits your needs and your budget
PROFESSIONAL SERVICES
Standard packages: Proof of Concepts, Quick Start
Ad-hoc packages, on-site consultancy
Development services, for SpagoBI suite and BI projects
TRAINING
In-class and on-site courses
Remote and recorded on-line courses
Tailored options
Free webinars
Certification test (2
nd
half 2012)
SpagoBI services
33
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
With SpagoBI, the Open Source BI fits your needs and your budget
ON-DEMAND & CLOUD SPAGOBI
On demand: your first SpagoBI project starting at € 5,000
Cloud: your own SpagoBI configuration paying a monthly fee;
subscribe now and you’ll just pay the maintenance costs
SPAGOWORLD SHOP
Easy access to SpagoBI remote services
Buy on-line remote and recorded training courses, SpagoBI book &
certification test (2
nd
half 2012)
SpagoBI services
34
www.spagobi.org
Copyright © 2012 Engineering Group.
All Rights Reserved. Engineering and its logo are trademarks of Engineering Group.
http://www.caribbean-tour.com/Contact-Us.html
Find out all information
(demo, documentation, tutorials, services and much more)
and download all SpagoBI components at:
www.spagobi.org www.spagobi.org
References
Contact us
[email protected] [email protected]
doc_876136664.pdf