SPAGOBI SPAGOBI Fill a gap promoting a vision Fill a gap promoting - - PowerPoint PPT Presentation

spagobi spagobi fill a gap promoting a vision fill a gap
SMART_READER_LITE
LIVE PREVIEW

SPAGOBI SPAGOBI Fill a gap promoting a vision Fill a gap promoting - - PowerPoint PPT Presentation

Engineering Ingegneria Informatica SPAGOBI SPAGOBI Fill a gap promoting a vision Fill a gap


slide-1
SLIDE 1
  • 1

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SPAGOBI SPAGOBI Fill a gap promoting a vision Fill a gap promoting a vision

  • Engineering Ingegneria Informatica

2006, July 20th

slide-2
SLIDE 2
  • 2

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Agenda

  • !
  • ! !
  • "# !
  • $
slide-3
SLIDE 3
  • 3

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Business Intelligence in a nutshell

% & %

% '(!(!

% )!*"+

!"# % %,-!!

$ . !!% !

%#& % /!( !

. $/

slide-4
SLIDE 4
  • 4

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/
  • '
  • 0 !!
  • $ !
  • 1'!
  • 1!#2
  • 1 "!(

,

BI misunderstanding

PRODUCT + PRODUCT + PROJECT = PROJECT = SOLUTION SOLUTION

slide-5
SLIDE 5
  • 5

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Operational data and event

  • !!
  • ! ! "# !

$

  • %

#

  • #"$&!&

"'

  • !

# ' "! ! #()*#*#+ ! #

  • "

+ #

  • Wireless

web desktop voice

BI – Proprietary products

SAS SAS

ETL Studio Metadata Server repository Information Map Studio Web Report Studio OLAP Server & OLAP Studio Enterprise Miner Information Delivery Portal Analytic applications …

Cognos Cognos

Decision Stream Architect Query ReportNet PowerPlay Enterprise Visualizer UpFront Analytic applications ….

Microsoft Microsoft

Integration Services Relational Database Analysis Services Reporting Services Microsoft Office products BI Development Studio SQL Server Management Studio …

IBM IBM

Warehouse Manager Ascential Data Stage Ascential MetaStage Cube Views QMF / Office Connect OLAP Server OLAP Analyzer Intelligent Miner …

Oracle Oracle

Warehouse Builder Discoverer Reports SpreadSheet Data Miner BI Beans Portal Analytic applications …

Business Business Objects Objects

Data Integrator DI Repository Business Objects full-client Web Intelligence Crystal Reports Business Miner Dashboard Manager InfoView Application Foundation Analytic applications …

slide-6
SLIDE 6
  • 6

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

BI – FOSS tools

  • !"

" #!$%! ! & % '() *#"+ ,- .- /-- '01 2 '01 !3/ .34 56

slide-7
SLIDE 7
  • 7

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/
  • (
  • !#

!

  • '#!!
  • #$
  • #!(3 ($((

( 1

  • '#!($(

(!!!

SpagoBI overview

slide-8
SLIDE 8
  • 8

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – FOSS BI platform

ETL

BI Core Components (BIObj)

ADMINISTRATIVE TOOLS / SCHEDULING

BIContextController

BIDash BIOlap BIData Mining BIReport

Generic semantic layer Native access

Service Components BIParameter BIProfiling BIFunctionality Search BIQbE

Staging Area Source Systems

DWH METADATA Service Repository

Notify

Delivery layer Analytical layer Data & Metadata layer

BIPortlet BIService BIXCube BIMessage

Specific semantic layer

slide-9
SLIDE 9
  • 9

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

( ! +* ! "$, #() " '+!!&&

  • +

&)& "

  • &!+&

* "&#&#

SpagoBI Process vision

  • &! *

+

  • !
  • !
  • "
  • !
  • !"

!

  • !
slide-10
SLIDE 10
  • 10

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI Methodological vision

  • $!
  • !("
  • 0*(

!(!+

  • ) 2"
  • %'!(

'

  • #

!# 45

slide-11
SLIDE 11
  • 11

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

http://spagobi.eng.it/sbiportal

SpagoBI – Portal

slide-12
SLIDE 12
  • 12

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI - Report

slide-13
SLIDE 13
  • 13

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – OLAP & QbE

slide-14
SLIDE 14
  • 14

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI - Dashboard

slide-15
SLIDE 15
  • 15

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – Versioning&Doc Mng

slide-16
SLIDE 16
  • 16

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – Admin Support

slide-17
SLIDE 17
  • 17

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – Data Mining

$ )) #

– – %'*!+ – 6 !6!

*((7+

– – 2

!

slide-18
SLIDE 18
  • 18

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – Collaboration

  • *&

(

"!!!

"68)

(

"

'" !

"

slide-19
SLIDE 19
  • 19

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – Geo-referenced Analysis

& + ), + +-

slide-20
SLIDE 20
  • 20

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – What-if

  • *7 → 7 8
  • *7983%%%:

– 33%

%3

– 873

  • %:

– /%%-/ – + – %;

Off line On-line Syncronization

slide-21
SLIDE 21
  • 21

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/
  • "

– !*

(/'+

– *!(!$

$(,+

– !! – 0

  • &,

– !*+ – 0(! –

  • +
  • .
  • .

SpagoBI – next steps

slide-22
SLIDE 22
  • 22

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

BI ESB – JBI

Data provider service QbE Service METADATA Service Reporting service Dashboard service OLAP service DataMining service Security service Parameter service CMS service WF service Rule service Search service Admin service

  • /&0/ 1234
  • / 0/ 5624
  • / 573
  • !"
  • /$8
  • /9&
  • SpagoBI – next steps
slide-23
SLIDE 23
  • 23

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Platform vs Tools

  • & :! ;<=
  • & (

– – – !!

6

– !*&(3 +

'

– !*!

!+

– !(%

slide-24
SLIDE 24
  • 24

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Integration Platform vs Product

  • & #

– 9 !( – !!:

(

– !6!!

!

– 9! – –

2!

– !!

slide-25
SLIDE 25
  • 25

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI keystones

  • + )

  • 6

!

" %6

  • ;2

– "

  • 1 ! !

(

  • - !! - 1$%-&
slide-26
SLIDE 26
  • 26

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Parameter

Behavioural Behavioural model model

Analytical document Analytical document

Report Report

Structural configuration Structural configuration

Parameter Parameter Parameter Parameter Parameter Parameter Parameter Parameter Parameter Parameter Parameter QbE QbE – – Query Query by by Example Example

Analytical document Analytical document Structural configuration Structural configuration

Dashboard Dashboard

Analytical document Analytical document Structural configuration Structural configuration

OLAP OLAP

Analytical document Analytical document Structural configuration Structural configuration

Data Data Mining Mining

Analytical document Analytical document Structural configuration Structural configuration

Behavioural model set up

slide-27
SLIDE 27
  • 27

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Check

Use Mode

Check Check Role Role Role

Use Mode Use Mode

LOV

Roles (1..n) LOV (1) Checks (0..n)

Check Check Check Role Role Role LOV

Roles (1..n)

Check Check Check Role Role Role LOV

Roles (1..n)

PARAMETER

Modalities (1..n) Parameters (0..n)

Behavioural model set up

LOV (1) Checks (0..n) LOV (1) Checks (0..n)

slide-28
SLIDE 28
  • 28

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Internal support Call center

  • perator

Operative secretary

  • Pr. brand

director Roles …. Prd family director

Analytical document Structural configuration

Analytical document

Structural configuration

Analytical document

Structural configuration

Analytical document

Structural configuration

  • Predefined lists for
brand directors Exists on prd family table? Is text ? Internal support Call center
  • perator
Manual and free input for support users Default value for prd family directors Manual input without default Contains the right brand prefix ? Operative secretary
  • Pr. brand
director Query for the prd family list matching the brand responsability No checks Staff Executive secretary Prd family director Predefined and fixed value, switched on the users’ role Exists on prd family table? Roles (1..n) LOV (1) Checks (0..n) Roles (1..n) LOV (1) Checks (0..n) Roles (1..n) LOV (1) Checks (0..n) Modalities (1..n)

PARAMETERS

  • Analytical document

Report Report

Structural configuration

Dashboard Dashboard

Analytical document Structural configuration

OLAP OLAP

Analytical document Structural configuration

Data Data Mining Mining

Analytical document Structural configuration

  • Behavioural model at work
slide-29
SLIDE 29
  • 29

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/
  • – 0 → !

– $→ ! – ! → ' ! – ) → ' ! – 0→ ' ! – <0 → – - → –

  • – 0'→ !

– $→ ! – !$→ ! – &%→ !9 – &%→ !9 – !→ !' – &→ !' –

Abstract Model

Analytical Meta-model: Abstraction

slide-30
SLIDE 30
  • 30

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/
  • >
  • – $ !

  • &

– &!' – 9' – ;' – ' –

  • :

– $ !

  • &!($(-(=(

Analytical Meta-model: Reduction

slide-31
SLIDE 31
  • 31

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI – global references

( ! +* !"$, #() " '+!!&&-
  • + &)&"
  • &!+& * "
&#&#
  • $

!

  • !(

"

  • *(!(

!+

  • ) 2"
  • %'

!( '

  • #

!# 45

slide-32
SLIDE 32
  • 32

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

Architectural choices

"

  • (

! !

&! (

  • ')

! ( !

!

' !

*<0>?@( <0>AB(<0CB@(<0DE+

)!(F $

  • $!

!

  • *

!+

  • *(!

+

  • " GG*!+

"

  • ) 2"
  • %'

!

  • !
  • G'!G

( (

  • (!
  • 45

!

slide-33
SLIDE 33
  • 33

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

SpagoBI in a nutshell

Done Functional key Technical key Work in progress

  • % !

$

  • &-

8%

  • %
  • <0>?@
  • <0>AB

< <C )!" -H!

  • '! # *$+

1!(<(<$I*+J (8I*$ +< 0(-( (01 0&- ; ! $ & 3

  • &! -!

! $! ;K $'I $%

  • % !

$

  • &-

8%

  • %
  • <0>?@
  • <0>AB

< <C )!" -H!

  • '! # *$+

1!(<(<$I*+J (8I*$ +< 0(-( (01 0&- ; ! $ & 3

  • &! -!

! $! ;K $'I $%

slide-34
SLIDE 34
  • 34

Engineering Ingegneria Informatica S.p.A., 2006. This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike License. To view a copy

  • f this license, visit http://creativecommons.org/licenses/by-nc-sa/2.0/

References

  • (-- 04
  • (-- 04
  • (-<+- 0!<4
  • (-<+-<+-?@A12B

0+4

  • (-<+-?@A12B 04