Creating a Single Enterprise View of Your Organization Through BI – Regardless of Data Source Rob Tenhundfeld Business Intelligence Solution Specialist Let’s start with a (not so) simple question…. “How is my new brand doing?” More specifically, “How much have I sold, how is it impacting my support operations and what percentage of my total revenue is it generating?” BI Challenges Today • • • • • • Siloed Fragmented Inconsistent Report-centric Restricted Unintuitive Hasn’t the promise of BI been there for the past decade? The Evolving Role of BI From: To: Analysts Pervasive use Historical data Real-time, predictive data Fragmented view Unified, enterprise view Reporting results Insight-driven business process optimization Unified infrastructure & prebuilt analytic solutions Analytic tools Separate BI, CPM Integrated Performance Mgmt Oracle Business Intelligence Comprehensive, Integrated, Best-of-Breed BI Solutions Oracle BI Applications Enterprise-wide, Industry-Specific Analytic Applications Oracle BI Suite Best-of-Breed, Next Generation BI platform Oracle Data Warehousing Complete data warehousing solution Oracle is the Worldwide Leader in Business Analytics Oracle BI Applications Oracle BI Suite Oracle Data Warehousing Sources: IDC and Gartner #1 in Analytic Applications - IDC “One of the most comprehensive and innovative BI platforms…” Leader’s Quadrant- Gartner #1 in DW Tools - IDC Oracle’s Answer To Silo BI: Oracle BI Enterprise Edition Oracle BI Suite Enterprise Edition • Foundation for BI in Fusion • Based on technology from Siebel, Hyperion and Oracle • Siebel was fastest growing BI vendor, averaging 50%+ annual growth over the last 5 years • Comprehensive, next-generation BI platform • Pervasive intelligence for all users • Integrated and Hot-Pluggable architecture “With the acquisition of Siebel, Oracle find themselves as the owners of one of the most exciting BI solutions available at present.” – Bloor Research Oracle BI Suite Enterprise Edition Interactive Dashboards Ad hoc Analysis Proactive Detection and Alerts Microsoft Office Reporting & Publishing Common Enterprise Information Model Oracle BI Server OLTP & ODS Systems Data Warehouse Data Mart SAP, Oracle PeopleSoft, Siebel, Custom Apps Files Excel XML Business Process Advantages: Consolidate and standardize BI tools Unified BI metadata and infrastructure Seamless BI user experience Primary BI EE End User Options Complete Range of Insight Delivery Capabilities Oracle Interactive Dashboards • Guided experience leads user from insight to action • Intuitive and interactive dashboards/scorecards • Personalized, function-specific and role-based Oracle Answers • Ad-hoc data exploration • True business user self sufficiency • Create, modify and author analysis, pivots and dashboards Oracle Delivers • Dynamic problem/opportunity detection and notification • Automated analytic workflows and processes • Tailored delivery for wide range of mobile devices Oracle Reporting & Publishing • Schedule & distribute enterprise-class reports • Sophisticate “pixel-perfect” report layout controls Powerful Insight Across Data Sources Simplify analysis of distributed data • Point and click access to information spanning multiple physical sources “Show me sales through today for my highest value customers. Assure sufficient inventory to fulfill orders.” • Users interact with simplified model • Shielded from complex physical data • Complete and timely information Oracle BI Server Intelligent Request Generation • Real-time and historical data • Enables high value crossdepartmental analysis Data Warehouse ODS / Operational Inventory System Historical Sales (through yesterday) Today’s Sales Current Inventory OBIEE Multi-Source BI Oracle BI EE Architecture Web Server (IIS, Tomcat, Websphere, iPlanet) Oracle BI Web Oracle Interactive Dashboards Web Catalog Service Agent Execution Logic Device Adaptive Content Oracle Answers User Profiling, Security and Session Mngmt Scheduling/Event Services TCP/IP (SSL) XML, HTML, XLS, PDF, TXT over HTTP/HTTPS TCP/IP (SSL) SOAP Web Services, XML and URL Interface Oracle Delivers Server Web Browser SAW Bridge (J2EE/ISAPI) XML Framework ODBC over TCP/IP (SSL) Query Govern. Security Services Cache Services Navigator Multi-Pass / Sub-Request Logic Fragmentation Optimization Aggregate Navigator DB Authentication Optimized Query Rewrites Execution Engine Data Source Adapters ODBC, CLI, OCI, XML, MDX Analytical and Operational Data Sources Metadata Interchange Session Management System / Perf Monitoring Load Balancer Logical Request Generation Custom Authenticator Oracle BI Administration Logical SQL ODBC/JDBC (Logical Business Model) Intelligent Request Generation Externalized Authentication LDAP External Applications and Portals Cache Services (Web) & Connection Mngmt Oracle BI Server Oracle BI Cluster Controller HTML, SOAP over HTTP/HTTPS Javascript for Usability & Interactivity Metadata Management Services Multi-User Development Services Metadata Documentation Services Server Management Services Oracle BI EE Architecture Web Server (IIS, Tomcat, Websphere, iPlanet) Oracle BI Web Oracle Interactive Dashboards Web Catalog Service Agent Execution Logic Device Adaptive Content Oracle Answers User Profiling, Security and Session Mngmt Scheduling/Event Services TCP/IP (SSL) XML, HTML, XLS, PDF, TXT over HTTP/HTTPS TCP/IP (SSL) SOAP Web Services, XML and URL Interface Oracle Delivers Server Web Browser SAW Bridge (J2EE/ISAPI) XML Framework ODBC over TCP/IP (SSL) Query Government Security Services Cache Services Navigator Multi-Pass / Sub-Request Logic Fragmentation Optimization Aggregate Navigator DB Authentication Optimized Query Rewrites Execution Engine Data Source Adapters ODBC, CLI, OCI, XML, MDX Analytical and Operational Data Sources Metadata Interchange Session Management System / Perf Monitoring Load Balancer Logical Request Generation Custom Authenticator Oracle BI Administration Logical SQL ODBC/JDBC (Logical Business Model) Intelligent Request Generation Externalized Authentication LDAP External Applications and Portals Cache Services (Web) & Connection Mngmt Oracle BI Server Oracle BI Cluster Controller HTML, SOAP over HTTP/HTTPS Javascript for Usability & Interactivity Metadata Management Services Multi-User Development Services Metadata Documentation Services Server Management Services Enterprise Business Model Administration DB2 Supply Chain DM Teradata OLAP Oracle ERP. Physical Layer – “Intelligent Request Generation” Reads in system catalog XML Data Source SQL Server Acxiom Multiple sources Optimized SQL generation Regardless of Schema Function ship to appropriate data sources/Compensation Siebel Operational Enterprise Business Model Administration 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 Enterprise Business Model Administration Presentation Layer Role-based, in context, personalized presentation – Oracle Answers Oracle BI EE Architecture Web Server (IIS, Tomcat, Websphere, iPlanet) Oracle BI Web Oracle Interactive Dashboards Web Catalog Service Agent Execution Logic Device Adaptive Content Oracle Answers User Profiling, Security and Session Mngmt Scheduling/Event Services TCP/IP (SSL) XML, HTML, XLS, PDF, TXT over HTTP/HTTPS TCP/IP (SSL) SOAP Web Services, XML and URL Interface Oracle Delivers Server Web Browser SAW Bridge (J2EE/ISAPI) XML Framework ODBC over TCP/IP (SSL) Query Govern. Security Services Cache Services Navigator Multi-Pass / Sub-Request Logic Fragmentation Optimization Aggregate Navigator DB Authentication Optimized Query Rewrites Execution Engine Data Source Adapters ODBC, CLI, OCI, XML, MDX Analytical and Operational Data Sources Metadata Interchange Session Management System / Perf Monitoring Load Balancer Logical Request Generation Custom Authenticator Oracle BI Administration Logical SQL ODBC/JDBC (Logical Business Model) Intelligent Request Generation Externalized Authentication LDAP External Applications and Portals Cache Services (Web) & Connection Mngmt Oracle BI Server Oracle BI Cluster Controller HTML, SOAP over HTTP/HTTPS Javascript for Usability & Interactivity Metadata Management Services Multi-User Development Services Metadata Documentation Services Server Management Services Oracle BI Server Common Enterprise Information Model 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. A Day in the Life of a Query A Day in the Life of a Query A logical request comes in asking for Brand, Closed Revenue (GL) Service Requests (Call Center) Share of Revenue (Derivation) A Day in the Life of a Query Oracle BI Server Cache The Server will check to see if this request can be fulfilled via a prior request using Server Cache. This is an on-demand intelligent shareable and secure cache that can support: Subsets, Aggregations and Derivations A Day in the Life of a Query Navigator If it is the request is cannot be fulfilled by cache then the server will intelligently process the request A Day in the Life of a Query Multi-Pass/Sub-Request Logic Does this analysis require sophisticated analysis such as an OLAP calculation? [Revenue Share] The Server will determine the best possible way to provide this calculation/computation A Day in the Life of a Query Fragmentation Optimization Does this request span across partitions or silos of data? [Closed Revenue and Service Requests] The server will determine based on the request if it should navigate to both or only one. It will automatically resolve fan traps. A Day in the Life of a Query Aggregate Navigator Is there an aggregate that can better satisfy this request versus hitting the detail? {Brand Summary Table} The Server will apply approprate summary redirection to provide the quickest response. A Day in the Life of a Query Optimized Query Rewrites What can be function-shipped down to the database versus performed /supplemented by the computation capabilities of the Server. The server will provide a consistent set of functionality to the user regardless of underlying datasource. Oracle BI Server Exploiting Native Database Functionality Oracle BI Server Optimized Native SQL Rewrites select distinct D1.c2 as c1, Rank() OVER ( ORDER BY D1.c1 DESC ) as c2 from (select sum(T677."ActlExtnd") as c1, T699."District" as c2 from "d1_customer" T699, "d1_orders" T677 where ( T677."repkey" = T699."SalesRep" ) group by T699."District") D1 order by 1 select D1.c2 as c1, D1.c1 as c4 from (select sum(T1397."ActlExtnd") as c1, T1384."District" as c2 from "D1_customer" T1384, "D1_orders" T1397 where ( T1384."repkey" = T1397."SalesRep" ) group by T1384."District" ) D1 [Rank Calculation Performed on Oracle BI Server To Compensate for the Limitations of MS SQL Server] A Day in the Life of a Query Cache Services The request once executed will now be available to other users as a cache entry. Oracle BI Server System Services System Services Clustering: Add stacks as needed in a share nothing clustered environment. Session Management and Governance: Query throttling via connection pools and authorization Security Services: Integration with OID, LDAP with sophisticated data driven personalization mechanisms. D E M O N S T R A T I O N Oracle BI Suite Enterprise Edition Drive Pervasive Intelligence All Departments, Users, and Processes Unsurpassed Usability Anywhere, Anytime Rich, interactive Web interface Guided analytics Seamless user experience Robust personalization Simplified business model Abstraction from physical sources Complex calculations made easy Dashboards, ad hoc, alerts, reports Any device Full mobile disconnected analytics Integrated with business processes Embedded analytics Portal integration Extranet Leverage Prebuilt Oracle BI Applications Built in Best Practices Across Functions and Industries Auto Comms. Complex Consumer & Media Sector Mfg. Energy Financial Services High Tech Insurance Life & Health Sciences Public Sector Travel & Trans Sales Analytics Service & Contact Center Analytics Marketing Analytics Financial Analytics Supply Chain Analytics Workforce Analytics Pipeline Analysis Churn Propensity Campaign Scorecard Receivables / Payables Analysis Supplier Performance Employee Productivity Triangulated Forecasting Customer Satisfaction Response Rates Customer Profitability Inventory Analysis Compensation Analysis Sales Team Effectiveness Resolution Rates Product Propensity Product Profitability Procurement Cycle Times Compliance Reporting Up-sell / Cross-sell Service Rep Effectiveness Loyalty and Attrition Regulatory Compliance Inventory Availability Workforce Profile Discounting Analysis Service Cost Analysis Market Basket Analysis Expense Management Employee Expenses Turnover Trends Lead Conversion Service Trends Campaign ROI Cash Flow Analysis BOM Analysis Return on Human Capital Other Operational & Analytic Sources Prebuilt adapters: Oracle BI Suite Enterprise Edition Leverage Prebuilt Oracle BI Applications Changing the Economics of BI Build from Scratch with Traditional BI Tools Oracle BI Applications With BI Suite EE you can: 1. Build custom BI apps 2. Buy Oracle BI Apps 3. Do a mix of both Training & Roll-out Define Metrics & Dashboards Faster deployment Lower TCO Assured business value DW Design Back-end ETL and Mapping Training & Rollout Specific Metrics & Dashboards DW Design Mod Pre-built ETL Tailoring Quarters or Years Weeks or months Role-based dashboards and alerts Thousands of pre-defined metrics Prebuilt DW design Adaptable to your enterprise DW Prebuilt ETL Business Adapters for Siebel, Oracle, PeopleSoft, SAP, others Leverage Prebuilt Oracle BI Applications Proven Rapid Time To Value Deployed to 800 users in under 90 days Analytics for sales-oriented contact center Live in 120 days Sales Analytics Deployed to 3000+ users in 3½ months Sales Analytics 4 months from decision to live for 1200 users Pharma Analytics “ Live in 100 days, 6500 users Sales and Marketing Analytics Having had experience of Siebel Business Analytics, I can vouch that it can be deployed as rapidly as they claim...It is a product that really delivers. Maximize the Value of IT Investments “Hot Pluggable” BI Adapts to Your Environment Integrate with portals & apps Access with other tools XML, SOAP API, JSR168 support Open SQL query interface Portals Other Applications MS Office Other BI Tools Leverage existing security Oracle, MSFT AD, Sun iPlanet, Novell Others … Oracle BI Server Oracle Microsoft SQL Server Teradata IBM DB2 Essbase Data Warehouse Data Marts MultiDimensional SAP BW Leverage any Data Source Optimized native SQL; Source-specific function shipping XML Excel Flat Files Scalable and Sustainable BI Process Reduce IT backlog while increasing self-sufficiency Provide greater self-sufficiency at each level and enable each member of the process to do what they do best Business Users • Consume shared dashboards, reports, alerts • Easily build / modify their own analysis Business Analysts & Operations IT • Build shared dashboards, alerts, workflow processes for their user community • Focus on data infrastructure, metadata model, tuning performance, security Oracle BI Suite Enterprise Edition Summary of Key Benefits / Differentiators 1. 2. 3. 4. 5. Comprehensive, integrated BI suite Enterprise information model & consistent metrics Intelligence spanning multiple sources Designed for broad, pervasive use Library of prebuilt Oracle BI Applications • 6. 7. 8. 9. Provide lower TCO, faster deployment, more assured value “Hot Pluggable” to maximize value of current systems Scalable and flexible BI architecture Pre-integrated Oracle stack lowers cost & complexity Scalable and sustainable BI process Industry Leaders Adopting Oracle BI Enterprise Edition Aerospace & Defense 5 of the top 6 Commercial Banks 4 of the top 5 Pharmaceutical 8 of the top 9 Computer Office Equip 6 of the top 9 Diversified Financials 3 of the top 4 Railroad 3 of the top 4 Medical Products & Equip 3 of the top 6 Telecommunications 5 of the top 6 Securities 3 of the top 6 Network & Comms Equip 2 of the top 4 Life & Health Insurance 3 of the top 5 OBIEE Features vs. 11g DB OBIEE Provides Tools for the Roadmap to Best Practice BI/DW OBIEE • Time and Value Based Partitions for BI Oracle Database 11g • Time, Value, Interval Based Partitioning for Enterprise • Aggregate awareness through defined views in data sources • Transparent, highly scaled aggregate awareness for enterprise apps (OLAP) • Single, secured logical definition for BI usage • Single, secured physical definition of enterprise
© Copyright 2024