11 - michael wilke - bi server the ultimate choice for biccsrequirement engineering oracle bi server...
TRANSCRIPT
BI Server The ultimate choice for BICCs
Michael Wilcke, sumIT AG
Business versus
IT
Process and
Organisation
FEATURES
2!
Business Intelligence
Information gather
& present
Data get &
calculate
Knowledge built up
& use
Interface
Business
IT
interface
USE the
business model
IMPLEMENT the
business model
Business versus
IT
Separate Concerns
source source source
DWH
ETL ETL
source source
ETL ETL ETL
Dashboards Reports Ad-hoc
Integrity Performance Data Quality
FEATURE
Concept - BI Suite
Oracle BI Server
source source source source source
Interactive Dashbords Answers BI Publisher
Third Party Tools
“physical” SQL
“logical” SQL
FEATURE
SQL
“phy
sica
l” S
QL
“log
ical”
SQL
Concept - Server
BI Server
Physical layer
Business layer
Presentation layer
FEATURE
simple table
KPI Mgmt.
multi sourcing
“phy
sica
l” S
QL
“log
ical”
SQL
Decoupling
BI Server
Physical layer
Business layer
Presentation layer
REAL decouplin
g
FEATURE
Admin-Tool
“phy
sica
l” S
QL
“log
ical”
SQL
“phy
sisc
hes”
SQ
L
“log
isch
es”
SQL
Decoupling 2
BI Server
Physical layer
Business layer
Presentation layer
copy
“B”
“A”
FEATURE!!!
TOTAL decouplin
g
SQL
Admin-Tool
“phy
sisc
hes”
SQ
L
“log
isch
es”
SQL
Requirement Engineering
Oracle BI Server
Interactive Dashbords Answers BI Publisher
source source
FIRST
Process and
Organisation
build Dashboards ‣ with sample data ‣ with the business ‣ with all details
Process Top-Down Warehousing
Oracle BI Server
Interactive Dashbords Answers BI Publisher
source source
DWH
ETL ETL
THEN
Process and
Organisation
build the DWH ‣ datamarts like BM ‣ good specification ‣ optimisation
source source
DWH
Process top-down / bottom-up
Process and
Organisation
step2 step3 step1
Dashboards
≈!
Engineering
Magic
Magic Process and
Organisation
What do you do?
iterate
understand stepN
model
create Dashboards
BICC!Process and
Organisation
interface
Business
IT
define establish review
USE the
business model
IMPLEMENT the
business model
fast
slow
usage tracking
requirement eng.
top-down warehousing
simple table
KPI Mgmt.
TOTAL decouplin
g
OBIEE USP!!!
multi sourcing
Business versus
IT
1 2
3
1.1
1.2
1.3
SQL
? ?
?�?� ?!?
?
BI Server the ultimate choice
for BICCs