controlling and reporting for public services a deep dive into developing an oracle based business...
TRANSCRIPT
1
A deep dive into developing an ORACLE based Business Intelligence solution
Controlling and Reporting for Public Services
virtual7 – The Oracle Middleware Experts
Welcome
Marcus WeißManaging DirectorDevelopment, HR & Finance
Email: [email protected]: +49 721 619 017 0
virtual7 GmbHZeppelinstraße 276185 Karlsruhe
http://www.virtual7.de
virtual7 – The Oracle Middleware Experts
• virtual7 GmbH and ORACLE• ORACLE Business Intelligence Suite• Controlling and Reporting in Public Services• Live Demonstration
• Final WrapUp and Q & A
Agenda
virtual7 – The Oracle Middleware Experts
ORACLE product portfolio and strategyQuick glance at virtual7ORACLE products at virtual7
virtual7 GmbH and ORACLE
virtual7 – The Oracle Middleware Experts
ORACLE product portfolio and strategyQuick glance at virtual7ORACLE products at virtual7
virtual7 GmbH and ORACLE
virtual7 – The Oracle Middleware Experts
What do you know about ORACLE ?
virtual7 – The Oracle Middleware Experts
Some of the latest acquisitions at ORACLE
• Passlogic (Oct 2010)• AmberPoint (Feb 2010)• HyperRoll (Sep 2009)• GoldenGate (Jul 2009)• Java (Apr 2009)• BEA (Jan 2008)• Captovation (Jan 2008)• Bridgestream (Sep 2007)• Stellent (Nov 2006)• Sunopsis (Oct 2006)
• DataScaler (Oct 2010)• Secerno (May 2010)• mValent (Feb 2009)• e-Test (Mar 2008)• Sleepycat (Feb 2006)• Innobase (Oct 2005)• TimesTen (Jun 2005)• TripleHop (Jun 2005)
• Virtual Iron (May 2009)• Sun (Apr 2009)
• Datanomic (Apr 2011, pending)• Ndevr (Feb 2011)• Silver Creek Systems (Jan 2010)• Primavera (Oct 2008)• Agile (May 2007)• Hyperion (Mar 2007)• Siebel (Jan 2006)• PeopleSoft (Jan 2005)
APPLICATIONS
DATABASE
MIDDLEWARE
SERVER & STORAGE
virtual7 – The Oracle Middleware Experts
ORACLE Product Portfolio
DATABASE
• Database 11g (EE, SE)• Database 10g Express• Application Express (APEX)
• MySQL
• Berkeley Database• Content Database• TimesTen (In-Memory)• Database Vault• Audit Vault
MIDDLEWARE
• HTTP Server• WebLogic ApplicationServer
• GlassFish Server• JRockit (JVM)• Coherence• WebCenter Suite• Portal• Identity Management• Information RightsManagement
• Universal Content Management
• Universal Records Management
• Document Capture
• Forms and Reports• Business IntelligenceSuite
• Business IntelligencePublisher
• Data Integrator• Hyperion Performance Management
• Business ActivityMonitoring
• WebServices Manager• BPEL Process Manager• Enterprise Service Bus• SOA Suite• Access Manager• Identity Manager
SERVER & STORAGE SYSTEMS• Enterprise Linux• Solaris 10 / 11 Express
• Oracle VM• VirtualBox VM
DEVELOPER TOOLS• JDeveloper• NetBeans IDE• Oracle ADF• Solaris Studio• TopLink
• SQL Developer• SQL Dev. Data Modeler• XML Developer• DataMiner• WarehouseBuilder
FUSION APPLICATIONS• CRM• Financials• Governance, Risk & Compliance
• Human Capital Mgmt.• Procurement• Project Portfolio Mgmt.• Supply Chain Mgmt.
COLLABORATION & SEARCH• OpenOffice• Beehive
• WebConference• Secure Enterprise Search
virtual7 – The Oracle Middleware Experts
ORACLE Middleware Strategy
• Provide Complete & Integrated Middleware Suite… Unified… Modular… Standards-based and Open… Hot Pluggable
• To Develop & Deploy Applications on Internet, unifying… Service-Oriented Architecture… Process Management… Business Intelligence… Content Management… Enterprise 2.0
• With Lowest Total Cost of Ownership… By Managing Systems, Applications, & User Identities
on Low Cost Hardware & Storage… Providing all development tools highly integrated
virtual7 – The Oracle Middleware Experts
ORACLE‘s stack strategy explored
• “Expand and accelerate — dramatically — the potentially massive global market for highly optimized and integrated hardware-software systems, and then dominate that market.”
• “Convince CIOs that a complete IT stack purchased from Oracle will deliver not only sufficient openness to avoid the dreaded vendor lock-in, but also superior performance compared with heterogeneous combinations.”
• “Convince CIOs that the combination of those 2 above will lower the costs of assembling, setting up, testing, tuning, managing, integrating, trouble-shooting, fixing, upgrading, and running those systems.”
• “Complete that infrastructure with ultra-modern Fusion applications that can run with existing enterpise apps, from Oracle or anyone else.”
• “Win in vertical markets like retail, healthcare, and telecom by complementing the broad horizontal apps with deep industry knowledge and functionality.”
virtual7 – The Oracle Middleware Experts
ORACLE product portfolio and strategyQuick glance at virtual7ORACLE products at virtual7
virtual7 GmbH and ORACLE
virtual7 – The Oracle Middleware Experts
ORACLE product portfolio and strategyQuick glance at virtual7ORACLE products at virtual7
virtual7 GmbH and ORACLE
virtual7 – The Oracle Middleware Experts
• Software & Consulting company• Founded in 1996• Headquarter in Karlsruhe (Germany)• Development Location in Timisoara (Romania)• 40 employees•
Business Areas• ORACLE Middleware Services• ORACLE-based Software Development• ORACLE-based Product Development• ORACLE Software Licensing
virtual7 – The ORACLE Middleware Experts
virtual7 – The Oracle Middleware Experts
virtual7: The development focus
virtual7 – The Oracle Middleware Experts
Focus: Portal / Application Development
A Portal is an application, that allows a centralized access topersonalized information, applications and processes, based on web technologies.
ORACLE Products:• ORACLE Portal / ORACLE WebLogic Portal• ORACLE WebCenter Suite
Technologies:• Java / JSF / ORACLE ADF • EJB / BC4J• BlazeDS / Flash / Flex• JPDK / JSR168• Spring / Hibernate / ORACLE Toplink• HTML / JavaScript / CSS / AJAX• SQL / PL/SQL
virtual7 – The Oracle Middleware Experts
Focus: Content Management
Enterprise-Content-Management (ECM) provides technologies to capture, administrate, store, archive and deliver content and documents to support organizational processes within the customer company.
Products:• ORACLE UCM Content Server• ORACLE UCM SiteStudio
Technologies:• Java• Idoc-Scripting• HTML / JavaScript / CSS / AJAX• SQL / PL/SQL
virtual7 – The Oracle Middleware Experts
Focus: Processes & SOA
A common base for heterogenious applications and services.
Products:• ORACLE SOA Suite• ORACLE BPEL• ORACLE Webservice Manager
Technologies:• Java • WSRP • BPEL
virtual7 – The Oracle Middleware Experts
Focus: Business Intelligence
Business Intelligence solutions provide a constant base for management decisions in our customer companies.
Products:• ORACLE Business Intelligence Suite• ORACLE Business Intelligence Publisher• ORACLE Warehouse Builder / Oracle DataIntegrator
Technologies:• SQL / PL/SQL• Datawarehousing / OLAP• relational & multidimensional BI-Modeling• HTML / JavaScript / CSS / AJAX• XML / XSLT• ORACLE APEX
virtual7 – The Oracle Middleware Experts
The base of all: Our software development
Software development using state-of-the-art technologies
• Mainly based on ORACLE-technologies• Enriched by OpenSource and own development
A broad experience base for our customers:• Programming / Coding
_ Java / EJB_ JSF / ORACLE ADF_ SQL / PL/SQL_ Flash / Flex_ Javascript / jQuery / AJAX_ HTML, CSS_ XML, XSL, XSLT_ PHP_ Perl_...
• Frameworks_ ORACLE ADF_ ORACLE Portlet API_ JPDK, JSR 168_ Hibernate, Spring_ ORACLE Toplink_ BlazeDS_ v7:Framework_ ...
virtual7 – The Oracle Middleware Experts
The customers
virtual7 – The Oracle Middleware Experts
ORACLE product portfolio and strategyQuick glance at virtual7ORACLE products at virtual7
virtual7 GmbH and ORACLE
virtual7 – The Oracle Middleware Experts
ORACLE product portfolio and strategyQuick glance at virtual7ORACLE products at virtual7
virtual7 GmbH and ORACLE
virtual7 – The Oracle Middleware Experts
ORACLE Product Portfolio
DATABASE
• Database 11g (EE, SE)• Database 10g Express• Application Express (APEX)
• MySQL
• Berkeley Database• Content Database• TimesTen (In-Memory)• Database Vault• Audit Vault
MIDDLEWARE
• HTTP Server• WebLogic ApplicationServer
• GlassFish Server• JRockit (JVM)• Coherence• WebCenter Suite• Portal• Identity Management• Information RightsManagement
• Universal Content Management
• Universal Records Management
• Document Capture
• Forms and Reports• Business IntelligenceSuite
• Business IntelligencePublisher
• Data Integrator• Hyperion Performance Management
• Business ActivityMonitoring
• WebServices Manager• BPEL Process Manager• Enterprise Service Bus• SOA Suite• Access Manager• Identity Manager
SERVER & STORAGE SYSTEMS• Enterprise Linux• Solaris 10 / 11 Express
• Oracle VM• VirtualBox VM
DEVELOPER TOOLS• JDeveloper• NetBeans IDE• Oracle ADF• Solaris Studio• TopLink
• SQL Developer• SQL Dev. Data Modeler• XML Developer• DataMiner• WarehouseBuilder
FUSION APPLICATIONS• CRM• Financials• Governance, Risk & Compliance
• Human Capital Mgmt.• Procurement• Project Portfolio Mgmt.• Supply Chain Mgmt.
COLLABORATION & SEARCH• OpenOffice• Beehive
• WebConference• Secure Enterprise Search
virtual7 – The Oracle Middleware Experts
ORACLE Product Portfolio
DATABASE
• Database 11g (EE, SE)• Database 10g Express• Application Express (APEX)
• MySQL
• Berkeley Database• Content Database• TimesTen (In-Memory)• Database Vault• Audit Vault
MIDDLEWARE
• HTTP Server• WebLogic ApplicationServer
• GlassFish Server• JRockit (JVM)• Coherence• WebCenter Suite• Portal• Identity Management• Information RightsManagement
• Universal Content Management
• Universal Records Management
• Document Capture
• Forms and Reports• Business IntelligenceSuite
• Business IntelligencePublisher
• Data Integrator• Hyperion Performance Management
• Business ActivityMonitoring
• WebServices Manager• BPEL Process Manager• Enterprise Service Bus• SOA Suite• Access Manager• Identity Manager
SERVER & STORAGE SYSTEMS• Enterprise Linux• Solaris 10 / 11 Express
• Oracle VM• VirtualBox VM
DEVELOPER TOOLS• JDeveloper• NetBeans IDE• Oracle ADF• Solaris Studio• TopLink
• SQL Developer• SQL Dev. Data Modeler• XML Developer• DataMiner• WarehouseBuilder
FUSION APPLICATIONS• CRM• Financials• Governance, Risk & Compliance
• Human Capital Mgmt.• Procurement• Project Portfolio Mgmt.• Supply Chain Mgmt.
COLLABORATION & SEARCH• OpenOffice• Beehive
• WebConference• Secure Enterprise Search
virtual7 – The Oracle Middleware Experts
ORACLE Product Portfolio
DATABASE
• Database 11g (EE, SE)• Database 10g Express• Application Express (APEX)
• MySQL
• Berkeley Database• Content Database• TimesTen (In-Memory)• Database Vault• Audit Vault
MIDDLEWARE
• HTTP Server• WebLogic ApplicationServer
• GlassFish Server• JRockit (JVM)• Coherence• WebCenter Suite• Portal• Identity Management• Information RightsManagement
• Universal Content Management
• Universal Records Management
• Document Capture
• Forms and Reports• Business IntelligenceSuite
• Business IntelligencePublisher
• Data Integrator• Hyperion Performance Management
• Business ActivityMonitoring
• WebServices Manager• BPEL Process Manager• Enterprise Service Bus• SOA Suite• Access Manager• Identity Manager
SERVER & STORAGE SYSTEMS• Enterprise Linux• Solaris 10 / 11 Express
• Oracle VM• VirtualBox VM
DEVELOPER TOOLS• JDeveloper• NetBeans IDE• Oracle ADF• Solaris Studio• TopLink
• SQL Developer• SQL Dev. Data Modeler• XML Developer• DataMiner• WarehouseBuilder
FUSION APPLICATIONS• CRM• Financials• Governance, Risk & Compliance
• Human Capital Mgmt.• Procurement• Project Portfolio Mgmt.• Supply Chain Mgmt.
COLLABORATION & SEARCH• OpenOffice• Beehive
• WebConference• Secure Enterprise Search
virtual7 – The Oracle Middleware Experts
26
Architecture & Components
ORACLE Business Intelligence Suite
virtual7 – The Oracle Middleware Experts
27
Architecture & Components
ORACLE Business Intelligence Suite
virtual7 – The Oracle Middleware Experts
Pre
sent
atio
n
Bus
ines
s In
telli
genc
eM
odel
&
Abs
tract
ion
Dat
aW
areh
ouse
ORACLE Business Intelligence Suite (SE One)
ORACLEInteractive Dashboards
Presentation
ORACLE Answers
Ad-hoc Analyse
ORACLE BI Publisher
Reporting & Publishing
ORACLEWarehouse
BuilderETL-Processes
& Workflows- Design- Deploy- Run & Control- Debug & Tune
ORACLEDatabase Base for 3-tier Data Warehouse
Store DataProvide Security, Backup & Recovery
on Database Level
OracleBI Server
Optimized Caching Services
Enterprise Business Model and Abstraction Layer
Intelligent Request-Generation and optimized Data access
Multidimensional Calculations- und Integration-Engine
virtual7 – The Oracle Middleware Experts
Security
ETL, Messaging and Metadata
Data Sources
SyndicatedExternal
UnstructeredData
OperationalSystems
COTS
Master Data
Staging Layer
TemporaryLoading
Structures
Rejected Data
!
Data Warehouse 3-Tier Architecture
Foundation Layer
Processneutral
3NF model
Access & Performance Layer
Embedded Datamarts,
MVs, AWs …
BI Applications
Data
BI A
bstr
actio
nan
dQ
uery
Gen
erat
ion
forA
dvan
ced
Anal
ysis
Too
ls
virtual7 – The Oracle Middleware Experts
Web Server (IIS, Tomcat, Websphere, iPlanet)
Oracle BI ServerOracle BI Server
Intelligent Request GenerationIntelligent Request Generation
Oracle Business Intelligence Suite Architecture
Logical Request GenerationLogical Request Generation
Session ManagementSession Management
Met
adat
a In
terc
hang
eM
etad
ata
Inte
rcha
nge
Logical SQL ODBC/JDBC (Logical Business Model)Logical SQL ODBC/JDBC (Logical Business Model)
Cache Cache ServicesServices
Oracle BI AdministrationOracle BI Administration
Analytical and Operational Data Sources
Metadata Documentation ServicesMetadata Documentation Services
Metadata Management ServicesMetadata Management Services
MultiMulti--User Development ServicesUser Development Services
Server Management ServicesServer Management Services
ODBC over TCP/IP (SSL)
Sys
tem
/ P
erf
Mon
itorin
gS
yste
m /
Per
f M
onito
ring
Data Source AdaptersData Source Adapters
ODBC, CLI, OCI, XML, MDX
Oracle BI Presentation ServicesOracle BI Presentation ServicesSOAP Web Services, XML and URL InterfaceSOAP Web Services, XML and URL Interface
Cache Services (Web) & Connection MngmtCache Services (Web) & Connection Mngmt
XML XML FrameworkFramework
Web Web Catalog Catalog ServiceService
User Profiling, Security and Session MngmtUser Profiling, Security and Session Mngmt
Oracle Interactive Oracle Interactive DashboardsDashboards
Oracle AnswersOracle Answers
Load BalancerLoad Balancer
Security S
ervicesS
ecurity Services
Query G
overn.Q
uery Govern.
Javascript for Usability & Interactivity
Web BrowserXML, HTML, XLS, PDF, TXT over HTTP/HTTPS
NavigatorNavigator
Aggregate Navigator
Fragmentation Optimization
Multi-Pass /Sub-Request Logic
Optimized Query RewritesOptimized Query Rewrites
Execution EngineExecution Engine
SAW Bridge (J2EE/ISAPI)SAW Bridge (J2EE/ISAPI)
TCP/IP (SSL)Oracle BI PublisherOracle BI PublisherDelivery ServerDelivery Server
Data LogicData Logic
Layout InterfacesLayout Interfaces
XSL
Externalized Authentication
LDAP
DB Authentication
Custom Authenticator
virtual7 – The Oracle Middleware Experts
3-Tier Information Model: Common Enterprise Information Modell
• Roles, Privileges & Preferences• Simplified Business Views• Logical SQL access
Presentation Layer
Role-based views on the information
• Dimensions• Hierarchies• Facts• Calculations• Aggregation rules• Time dimensions
Semantic Object Layer
Consistent definitionen of businessfacts, measures, metrics andaggregations (Single Point of Truth)
• Connection to physical data• Heterogeneous data sources• Schema
Physical Layer
Design once, use several times
On a Data Warehouse oracross different data sources
virtual7 – The Oracle Middleware Experts
3-Tier Information Model: Common Enterprise Information Modell
Physical Layer – “Intelligent Request Generation”Reads in system catalog
Multiple sources
Optimized SQL generation
Regardless of Schema
Function ship to appropriate datasources/Compensation
DB2SupplyChain DM
TeradataOLAP
OracleERP.
XML DataSource
SQL ServerAcxiom
SiebelOperational
virtual7 – The Oracle Middleware Experts
ORACLEData
Warehouse
3-Tier Information Model: Common Enterprise Information Modell
Business Model Layer –“Calculation Engine”
Physical complexity converted to logical subject areas
Drill-Paths
Complex/Derived Measures (Level-based, time series, dimension-specific, nested)
Aggregate/Fragment Aware
virtual7 – The Oracle Middleware Experts
3-Tier Information Model: Common Enterprise Information Modell
Presentation Layer
Role-based, in context, personalized presentation – Oracle Answers
virtual7 – The Oracle Middleware Experts
3-Tier Information Model: Common Enterprise Information Modell
Simplified Logical Model
The Oracle BI server presents as a logically modeled database enabling the Common Enterprise Information Model.
This provides powerful calculation, computation and federation capabilities to 3rd party tools as well as our own.
virtual7 – The Oracle Middleware Experts
Frontend: Ad-Hoc Queries by Answers
• Complete Ad-Hoc Analysis, Pivot tables,Charts
• Point & Click GUI• Drill up & down• Complexity of the sources
are hidden from the user• Create, save, organize and
share queries• Integration of created
queries in dashboards
virtual7 – The Oracle Middleware Experts
Frontend: Interactive Dashboards
• Fully interactive, graphicalinterface. End-user„compatible“
• Data in real time fromdifferent sources anddifferent business areas
• Personalizable views foreach user
• Point & Click GUI
virtual7 – The Oracle Middleware Experts
Frontend: Business Intelligence Publisher
• Replacing Excel-basedand printed reports
• Creating real time standard reports
• Integrate real time data in common Office-productslike Excel, Word, PowerPoint
virtual7 – The Oracle Middleware Experts
Evolution of Controlling in Public ServicesRequirements in the Public SectorMatching the requirements
Controlling and Reporting in Public Services
virtual7 – The Oracle Middleware Experts
Evolution of Controlling in Public ServicesRequirements in the Public SectorMatching the requirements
Controlling and Reporting in Public Services
virtual7 – The Oracle Middleware Experts
Evolution of the Controlling in Public Sector
Basic Controlling• Reports from the Financial Accounting
• Processing in Excel• Manually generated annual budget planning
Financial Controlling•Financial reports from controlling software
•Planning•In year forecast•No Product / Performance indicators
Operational Controlling•Financial and product / performance indicators
•Measurement ofoperational measures
•Annual budget planning at your fingertips
Strategic Controlling•Controlling theoverall process- Vision- Mission- Strategy- Goals- Measures
•Balanced Scorecard
virtual7 – The Oracle Middleware Experts
Evolution of Controlling in Public ServicesRequirements in the Public SectorMatching the requirements
Controlling and Reporting in Public Services
virtual7 – The Oracle Middleware Experts
Evolution of Controlling in Public ServicesRequirements in the Public SectorMatching the requirements
Controlling and Reporting in Public Services
virtual7 – The Oracle Middleware Experts
Requirements for the Controlling and Planningin the Public Sector
• Required data is distributed across many departments and administrativ procedures
virtual7 – The Oracle Middleware Experts
• Reporting is a highly agile topic and the required reports and information are subject to continuous change
• Additional reporting and metrics to be implemented mostly with the same staffing
• Each administrativ procedure is represented by several individual software systems each with an individual data sources
Requirements for the Controlling and Planningin the Public Sector
• Easy and fast report generation in the departments is needed
virtual7 – The Oracle Middleware Experts
• Support for situational reporting • Certain reports and actions are often only necessary if defined
thresholds are out of limits
• Decentralization of planning and budget responsibilities• Department heads and product managers need simple controlling and
regulation possibilities
Requirements for the Controlling and Planningin the Public Sector
virtual7 – The Oracle Middleware Experts
• More transparency in the administration is required… Reporting is part of the administrative processes… Politicians ask for more insight into the level of achievment of
objectives…Also the citizens ask for deeper insight
Special Requirements of a or city / district administration
Requirements for the Controlling and Planningin the Public Sector
• Comparability and data exchange among city / district administrations
virtual7 – The Oracle Middleware Experts
Special Requirements of a or city / district administration
Requirements for the Controlling and Planningin the Public Sector
Controlling within the software products for the administrative procedures as well as within the ERP-system• is limited in its possibilities with regard to the reporting • is limited in its scope on the procedure• is limited in its support of controlling workflow• offers only unhandy planning & reporting layouts, little user guidance• Print reports for the annual budget planning are strongly commerce-
oriented and need high manual effort for adjustments to the needs in public sector
virtual7 – The Oracle Middleware Experts
"The ORACLE Business Intelligence Suite based controlling offers us the possibility for a transparent planning and controlling. Relevant business information can be managed flexibly and can be presented in a way that suits the needs in Public Sector" - Matthias Portis, Head of Finance and Controlling, City of Dreieich -
Basic Controlling• Reports from the Financial Accounting
• Processing in Excel• Manually generated annual budget planning
Financial Controlling•Financial reports from controlling software
•Planning•In year forecast•No Product / Performance indicators
Operational Controlling•Financial and product / performance indicators
•Measurement ofoperational measures
•Annual budget planning at your fingertips
Strategic Controlling•Controlling theoverall process- Vision- Mission- Strategy- Goals- Measures
•Balanced Scorecard
TraditionallyMS Excel
Controlling withORACLE BI Suite 10g
Controlling withORACLE BI Suite 11g
virtual7 – The Oracle Middleware Experts
Requirements for the Controlling and Planningin the Public Sector
Evolution of Controlling in Public ServicesRequirements in the Public SectorMatching the requirements
Controlling and Reporting in Public Services
virtual7 – The Oracle Middleware Experts
Evolution of Controlling in Public ServicesRequirements in the Public SectorMatching the requirements
Controlling and Reporting in Public Services
virtual7 – The Oracle Middleware Experts
Pre
sent
atio
n
Bus
ines
s In
telli
genc
eM
odel
&
Abs
tract
ion
Dat
aW
areh
ouse
ORACLE Business Intelligence Suite (SE One)
ORACLEInteractive Dashboards
Presentation
ORACLE Answers
Ad-hoc Analyse
ORACLE BI Publisher
Reporting & Publishing
ORACLEWarehouse
BuilderETL-Processes
& Workflows- Design- Deploy- Run & Control- Debug & Tune
ORACLEDatabase Base for 3-tier Data Warehouse
Store DataProvide Security, Backup & Recovery
on Database Level
OracleBI Server
Optimized Caching Services
Enterprise Business Model and Abstraction Layer
Intelligent Request-Generation and optimized Data access
Multidimensional Calculations- und Integration-Engine
virtual7 – The Oracle Middleware Experts
GUI forplanning &forecasting
GUI based on ADF / WebLogic Application Server
ORACLE Business Intelligence Suite (SE One)
OracleDatawarehouse FinanceFinance
SAP FI/CO
CIP
Infoma nks
...
HRHRSAP HR
MPS
LOGA Personal
...
SocialSocialPROSOZ
OK.SOZIUS
ABDATA
...
OthersOthersGIS
FM
K3-Umwelt
...
Interactive Dashboards
Ad-hocAnalyse
PublishingPublicServiceDashboards
PublicServiceBI-Catalog
PublicServiceReports
OracleBI Server Optimized Caching Services
Enterprise Business Model and Abstraction layer
Intelligent Request-Generation and optimized Data access
Multidimensional Calculations- und Integration-Engine
PublicServiceBI-Model
PublicServiceETL
virtual7 – The Oracle Middleware Experts
Hetero-genous
Data Services
Matching the requirements
Why does the concept of ORACLE Business Intelligence Suite SE One matches the requirements ?
• Fully web-based it meets the requirements for an easy software distribution and centralized application management in the city / district administrations
(It’s even already on a good way for a later SaaS-approach in the public Computer Centers)
• The Data Warehouse approach allows a centralized data management, while the original data is widely spread in (technically) different operational systems
(This establishes a Single Point of Truth approach in the DWH)
virtual7 – The Oracle Middleware Experts
Matching the requirements
Why does the concept of ORACLE Business Intelligence Suite SE One matches the requirements ?
• The Ad-hoc reporting possibilities of Oracle Answers allow to react on short notice on situational reporting requirements
(With a short training, users are easily enabled to “drag and drop” their individual analyses)
• Considering the possible access to heterogenous data sources in the Physical Layer allows fast Proof of Concepts and a rapid data integration for situational ad-hoc reporting
(Quick Wins with non integrated data can be achieved)
• The 3-tier Information Model allows to replace quick win heterogenousdata sources by a datamart from within the DWH at a later point of time
(No changes in the Business Model or above have to be done)virtual7 – The Oracle Middleware Experts
Matching the requirements
Why does the concept of ORACLE Business Intelligence Suite SE One matches the requirements ?
• Ensures the Investment and reduces Total Cost of Ownership even in changing data environments
(City of Dreieich: Customer works with the systems since 2 years without fundamental system changes. Most changes in Modeling and Presentation could be done by the customer on its own)
virtual7 – The Oracle Middleware Experts
ORACLE Warehouse BuilderORACLE Business Intelligence AdministratorORACLE Business Intelligence Answers & Dashboards
Live Demo
virtual7 – The Oracle Middleware Experts
How to get in touch with it ?Questions & Answers
Final WrapUp and Q & A
virtual7 – The Oracle Middleware Experts
How to get in touch with it ?Questions & Answers
Final WrapUp and Q & A
virtual7 – The Oracle Middleware Experts
How to get in touch with it ?
• Fusion MiddlewareDemos, Internet Seminars, Tutorials, Oracle by Example, Downloadshttp://www.oracle.com/us/products/middleware/
• Business IntelligenceDemos, Internet Seminars, Tutorials, Oracle by Example, Downloadshttp://www.oracle.com/us/products/middleware/bus-int/
• Databasehttp://www.oracle.com/us/products/database/
• ORACLE Technology Networkhttp://otn.oracle.com
• German Oracle User Group (DOAG e.V.)http://www.doag.orghttp://mydoag.doag.org Schedule for comm. meetingshttp://www.doag.org/zielgruppen/hs/ Hochschul-Community
virtual7 – The Oracle Middleware Experts
How to get in touch with it ?
Get a deeper insight at virtual7
• Internship / Praktikum… with focus “Business Intelligence”… with focus “Project Management”
• Diploma paper / Bachelor/Master thesis… with focus “General Business Intelligence”… with focus “Controlling in Public Sector”
• Junior Consultant … with focus “Business Intelligence”
• Junior Software Developer … with focus “Java Development & Enterprise 2.0”
• Junior Account Manager … with focus “Business Intelligence”
http://jobs.virtual7.devirtual7 – The Oracle Middleware Experts
How to get in touch with it ?Questions & Answers
Final WrapUp and Q & A
virtual7 – The Oracle Middleware Experts
How to get in touch with it ?Questions & Answers
Final WrapUp and Q & A
virtual7 – The Oracle Middleware Experts
Marcus WeißManaging DirectorDevelopment, HR & Finance
Email: [email protected]: +49 721 619 017 0
virtual7 GmbHZeppelinstraße 276185 Karlsruhe
http://www.virtual7.de
Q U E S T I O N SQ U E S T I O N S
A N S W E R SA N S W E R S
virtual7 – The Oracle Middleware Experts