1 / 32

Driving the Next Generation EIM Architecture

Driving the Next Generation EIM Architecture. Leverage Oracle BI Applications Architecture to Meet Real-Time Reporting Requirements. INTRODUCTIONS.

alaqua
Download Presentation

Driving the Next Generation EIM Architecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Driving the Next Generation EIM Architecture Leverage Oracle BI Applications Architecture to Meet Real-Time Reporting Requirements

  2. INTRODUCTIONS Neetu Shawis an industry author, speaker and thought leader for enterprise information management, big data, advanced analytics, and data governance. She leverages her 17 years of hands-on information strategy experience in diverse industries and technologies to help a variety of clients in financial services, energy, utilities, healthcare, biotechnology, communications, media, entertainment, automotive, retail, manufacturing, aerospace and advertising to realize their BI capabilities. Shiv Bharti is the Practice Director of Perficient’s National Oracle Business Intelligence Practice. Shiv has solid experience Building and Deploying Oracle Business Intelligence Products. He has successfully led implementation of over 75+ Oracle Business Intelligence and Custom Data Warehouse Projects. Shiv has worked in multiple industries and with clients that include fortune 500 companies . He has Expertise leading large global teams, as well as in-depth knowledge across multiple verticals and technologies. Prior to 2008, Shiv was a member of the Oracle and Siebel Core Engineering Teams and responsible for the Design and Development of numerous Business Intelligence Applications.

  3. AGENDA 01About Perficient 02 Building a Unified Enterprise Information Architecture 03 Oracle BI Applications Overview 04 What is Real-Time BI? 05 OBIEE Metadata Modeling Steps To Achieve Real-Time Analytics 06 Q&A Experts in delivering business-driven technology solutions

  4. ABOUT PERFICIENT 01 Inspiration Delivered

  5. PERFICIENT • Leading Technology Consulting & Solutions Firm • Founded 1997 • $450M+ in annualized revenues • 85% of revenue from recurring clients • Platinum Partner w/1,800+ Oracle Implementations • Enterprise Information Management • Enterprise Performance Management (EPM) • E-Business Suite • Oracle Technology, Middleware/SOA • Customer Experience / CRM • Oracle Certified Education Partner • Key Differentiators • Focused expertise, lower cost, faster time-to-value • Highly-experienced consultants • National coverage • Perficient uses Oracle to run its business • A strong commitment to Oracle world for our 10th year in a row • Expansive OOW Presence • Main Booth • Big Data Theatre • CX and HC Showcases • Multiple Presentation Sessions • Life Sciences • Digital HC • Leveraging ODI to Automate Data Extraction • Our Social Media Presence • www.perficient.com/oow • @PRFT Oracle • http://blogs.perficient.com/oracle Experts in delivering business-driven technology solutions

  6. PERFICIENT’S ENTERPRISE INFORMATION SOLUTIONS LANDSCAPE Enterprise Information Management (EIM) Solutions & Services STRATEGIC AND AGNOSTIC CONSULTING Deep Financial Services Domain Expertise Executive Advisory Services & Workshops Strategy and Roadmaps Enterprise Data & Solution Architecture Governance and Organizational Design Product Selections Health Checks Full Solution Vendors EIS Pillars Information Governance MDM, Metadata, Governance, Quality Enterprise Data Modeling, Warehousing, Integration Analytics Descriptive, Diagnostics, Predictive, Prescriptive Big Data At Rest, In Motion, Discovery Content Solutions Management, Intelligence, Search Global Delivery Centers/Offshore Delivery Niche Solutions Healthcare Financial Services Industry Verticals Retail and Consumer Markets Life Sciences

  7. ORACLE BUSINESS UNIT • Oracle Platinum Partner with multiple specializations • 10+ year relationship of loyalty and trust • Successfully delivered over 375 Oracle BI projects • 50+ U.S based Consultants and 50+ Offshore consultants dedicated to delivering Oracle BI Solution • 60% of consultants come from Oracle Engineering • Multiple Delivery Models • Deep technical expertise on • Oracle BI Apps, OBIEE, Custom Data Warehousing, Oracle Golden Gate, Mobility • Oracle Certified Education Training Partner • Work closely with Oracle product management to provide feedback for functional enhancements • Strong partnerships with field sales and marketing organizations • Long standing involvement with Oracle Open World Experts in delivering business-driven technology solutions

  8. UNIFIED INFORMATION ARCHITECTURE 02 Inspiration Delivered

  9. CAPABILITIES-DRIVEN REFERENCE ARCHITECTURE Multi-Channel Delivery • Promotes a UNIFIED vision for Info. Mgmt. & Analytics • Prioritized by Business Need • Adaptive to Business Change • Driving Agile Value from Raw Data Assets • Quickly establishes consensus on the scope of your EIM solution without being distracted by technical details • Paints the “big picture” for internal communications to build support Unified Information Management Real-TimeAnalytics IntelligentProcesses System-GeneratedData ExternalData OperationalData HistoricalData AnalyticalData COTSData Reference Data Content High VolumeData Acquisition Speed of Thought Analysis Applications-Embedded Analytics Multi-structured Data Persistence Interactive Dashboards Guided User Navigation Low LatencyData Processing Discovery and Advanced Analytics Performance and Strategy Management Single Version of the Truth Event Processing Real-Time Decisions Public Cloud Managed Services Private Cloud Traditional IT Source: ORA White Paper

  10. EXPANDED LOGICAL ARCHITECTURE Multi-Channel Delivery Governance Desktop Laptop Mobile Tablet Print Email SMS Interaction Layer Interactive Dashboards Charts & Graphs Spreadsheets Reports Intelligence Analysis Tools Advanced Analytics Tools Guided Analysis Process Layer Security Custom Analytic Applications Process-Specific Analytic Applications Industry-Specific Analytic Applications Performance Management Services Layer Presentation Services Business Rules Business Activity Monitoring Monitoring Information Services Event Handling Data Processing Data Virtualization Event Detection Information Layer In-DB Analytics HistoricalData Analytical Data Discovery Data • Ensure your EIM solution includes all the Necessary Capabilities • Develop Holistic EIM Vision and Roadmap for one or more pillars • Defines it as an integrated solution rather than a piecemeal effort • Map CurrentCapabilities to find Solution and Product gaps • Identify supporting design patterns and reusable components • Codify common analytic patterns and models • Establish data quality governance strategy - processes and procedures Management Data Ingestion COTS Data Reference Data Operational Data System-GeneratedData ExternalData Content Modeling Shared Infras-tructure Database Machine Big Data Appliance Analytics Machine

  11. FOCUSED LOGICAL ARCHITECTURE & ORACLE PRODUCT MAPPING – Intelligent Processes Source: ORA White Paper

  12. ENTERPRISE TRANSFORMATION / DATA FOCUS SOA Master Data Management Mater Data Hub • Master • Customer • Product • Vendor • Reference Source 1 Source 2 ETL/Staging Managed Data ID linkage (Customer, Product, Vendor) Match & Merge Source 3 Source n Business Intelligence Data Warehousing Data Quality Presentation Manager/Application Integration Source 1 Source 2 Reporting Source 3 Source n Standard Reference Data OS & Staging Enterprise Data Warehouse Physical & Virtual Data Marts Visualization Source 1 Source 2 Big Data Information as a Service Source 3 Source n Content & Collaboration Server Analytics Line of Business / Application Data Warehouses (SOR) Pattern-Based or Metadata Driven LOB Analytics Marts External Data Discovery Structured / Unstructured Data Metadata Management Content Database Information Lifecycle Management Centralized Metadata Repository Metadata Integration Services Data Quality & Metadata Data Mart Metadata Reporting and Analysis Experts in delivering business-driven technology solutions

  13. ORACLE BI APPLICATIONS OVERVIEW 02 Inspiration Delivered

  14. ORACLE BI APPLICATIONS Complete. Open. Integrated. Planning &Forecasting StrategyManagement CRM Analytics Industry Analytics ERP Analytics Financial Close & Reporting Profitability Management BI / EPM Apps Interactive Dashboards Query & Analysis Scorecards Reports & Publishing Office Search Detect & Alert Embedded Mobile BI/EPM Platform BI Server Essbase Dimension Management Predictive Analytics Data Warehouses Data Marts(SQLServer, Oracle…etc.) ) Unstructured & Semi-Structured Common Enterprise Information Model OLAP Sources(MS Cube) Packaged Applications (Oracle, SAI, UltiPro) Business Processes OLTP & ODS Systems Exadata Excel XML/Office Data Sources Experts in delivering business-driven technology solutions

  15. ORACLE BI APPLICATIONS Adopt the Data Model – Don’t Build Your OwnComprehensive Conformed Dimensions Ensures Cross Functional Alignment ERP ANALYTICS • CONFORMED DIMENSIONS CRM ANALYTICS • Finance • Receivables • Payables • Cash Flow • General Ledger • Procurement & Spend • Procurement Performance • Supplier Performance • Spend Analysis • Order Management • Sales Orders and Invoices • Bookings, Billings, Backlog • Order fulfillment process • Supply Chain • Inventory Performance • Inventory Bill of Materials • Customer & Supplier Returns • Human Resources • Compensation • Recruiting, Training, Learning • Workforce Profile • Projects • Project Funding • Project Budgets • Project Performance • Customer • Products • Suppliers • Internal Organizations • Customer Locations • Customer Contacts • GL Accounts • Employee • Sales Reps • Service Reps • Partners • Campaign • Offers • Cost Centers • Profit Centers • Sales • Opportunities • Quotes • Pipeline • Marketing • Campaigns • Responses • Marketing Costs • Service • Service Requests • Activities • Agreements • Contact Center • ACD Events • Contact-Rep Snapshot • Targets and Benchmark • Loyalty • Members and Points • Transactions • Promotions • Price • Price Waterfall • Deal Desk • Price Segments • MODULAR DATA MODEL • 370 Fact Tables • 595 Dimension Tables • 8,200 Prebuilt Metrics • 17,700 Data Elements Experts in delivering business-driven technology solutions

  16. ORACLE BI APPLICATIONS 1 3 Pre-mapped metadata, including embedded best practice calculations and metrics for executives and other business users Pre-built warehouse with 370 star-schemas designed for analysis and reporting on financial analytics • Presentation layer • Logical business model • Physical sources 2 4 A “best practice” library of over 8200pre-built metrics, 88 intelligent dashboards, 2576 reports and several alerts for Executives, Managers and Business Users Pre-built ETL to extract data from operational tables and load it into the DW, sourced from PSFT, Oracle EBS and other sources Experts in delivering business-driven technology solutions

  17. ARCHITECTURE Metadata Dashboards by Role OBI EE Analytics Web Reports, Analysis / Analytic Workflows Metrics / KPIs OBI EE Analytics Server Logical Model / Subject Areas Physical Map Data Warehouse Data Warehouse Database Informatica(ETL) / Oracle Data Integrator(ODI) Source Systems Oracle ERP Non-Oracle ERP Legacy Administration OBI EE Analytics reporting tools, including dashboards, reports, graphs, etc. Robust pre-defined OBI EE metadata built specifically for Oracle ERP Customers. All Oracle ERP data integrity and relationships built in. Simple, yet powerful data warehouse architecture. Informatica or ODI for Extract, Transform and Load into the Data Warehouse. Sources can Oracle ERP, Non-Oracle ERP, Legacy or Custom Applications Experts in delivering business-driven technology solutions

  18. BUILD VS. BUY Speeds time to value and lowers TCO Build from Scratchwith Traditional BI Tools Training/Roll-out Define Metrics& Dashboards • Faster deployment • Lower TCO • Assured business value DW Design Back-end ETL andMapping Training/Rollout Easy to use, easy to adapt Role-based dashboards and thousands of pre-defined metrics Define Metrics& Dashboards Prebuilt DW design, adapts to your EDW DW Design Back-end ETL andMapping Prebuilt business adapters for Oracle, PeopleSoft, Siebel, and others Quarters or Years Weeks or Months Source: Patricia Seybold Research, Gartner, Merrill Lynch, Oracle Analysis Experts in delivering business-driven technology solutions

  19. REAL-TIME BI 02 Inspiration Delivered

  20. WHAT IS RTBI? Real-time business intelligence (RTBI) is the process of delivering information about business operations as they occur. Real time means near to zero latency and access to information whenever it is required. • Access to Point of Sale Transactions • Operational reports for Business that depend on timely deliveries • Need up to date information with real-time data Experts in delivering business-driven technology solutions

  21. METADATA MODELING FOR RTBI 03 Inspiration Delivered

  22. DESIGN SCENARIO Source Systems OLTP OBAW Experts in delivering business-driven technology solutions

  23. OBIEE – PHYSICAL LAYER OBAW Physical Layer – “Intelligent Request Generation” Reads in system catalog Multiple sources Optimized SQL generation Regardless of Schema Function ship to appropriate data sources/Compensation OLTP Experts in delivering business-driven technology solutions

  24. OBIEE – Business Layer 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 Experts in delivering business-driven technology solutions

  25. OBIEE – Presentation Layer Presentation Layer Role-based, in context, personalized presentation – Oracle Analysis Experts in delivering business-driven technology solutions

  26. OBIEE ANALYSIS select sum(T217.NET_QTY) as c1, T712.DATE as c2 T956.PRODUCT_NAME as c3 T471.CUSTOMER_NUMBER as c4 from VIEW_DATE T712 VIEW_PRODUCT T956, VIDEW_CUSTOMER T471, VIEW_SALES_ORDERS T217 Where (T712.ROW_ID = T217.DATE_ID AND T956.ROW_ID = T217.PRODUCT_ID AND T471.ROW_ID = T217.CUSTOMER_ID) group by T712.DATE, T956.PRODUCT_NAME, T471.CUSTOMER_NUMBER select sum(T312.NET_QTY) as c1, T925.CALENDAR_DATE as c2 T659.PRODUCT_NAME as c3 T323.CUSTOMER_NUMBER as c4 from W_DAY_D T925 W_PRODUCT_D T659, W_PARTY_D T323, W_SALES_INVOICE_LINE_F T312 Where (T925.ROW_WID = T312.DATE_WID AND T659.ROW_WID = T312.PRODUCT_WID AND T323.ROW_WID = T312.PARTY_WID) group by T925.CALENDAR_DATE, T659.PRODUCT_NAME, T323.CUSTOMER_NUMBER Experts in delivering business-driven technology solutions

  27. SAMPLE 3-TIER ARCHITECTURE Experts in delivering business-driven technology solutions

  28. BI APPS 11.1.7.1 • New BI Analytics Apps Supports Real-Time • BI Apps 11.1.1.7.1 with Oracle Data Integrator and GoldenGate • Oracle Data Integrator provides • In-database E-LT Transformation vs. E-T-L • Best in class performance, scalability, availability • Lightweight deployment for lower TCO • Faster time-to-value through declarative design • Oracle GoldenGate option for BI Apps • Reduce load on source system by streaming data • continuously into persistent store in the DW • More reliable change data capture and delete • support • Enables near real-time dashboard refresh • BI Apps 11.1.1.7.1 with Oracle Data Integrator and GoldenGate Experts in delivering business-driven technology solutions

  29. SELECT SUCCESSES Transportation Consumer Goods/Media Oil & Gas/Chemical Manufacturing Technology Higher Education Healthcare Financial Services Energy Experts in delivering business-driven technology solutions

  30. CALL TO ACTION • Contact Us Within the Next Hour to Receive a Complimentary Advisory Workshop • Logical Unified Architecture • Real-time Oracle BI Apps and Intelligent Processing • Big Data and Advanced Analytics • Agnostic Enterprise Information Strategy encompassing all EIM Pillars • Contact Us By Tomorrow to Receive • The CIOStory Publication • Other Top White Papers on Enterprise Information Management (Industry, Agnostic or Oracle Product Specific) Experts in delivering business-driven technology solutions

  31. Q & A Experts in delivering business-driven technology solutions

  32. Thank You! For more information, please contact: Shiv Bharti, Oracle BI Practice Director shiv.bharti@perficient.com 312.291.1532 office I 312.659.3233 mobile Neetu Shaw, Principal, Enterprise Information Solutions neetu.shaw@perficient.com 248-770-1226 office I 248-770-1226 mobile www.perficient.com www.facebook.com/perficient www.twitter.com/perficient Experts in delivering business-driven technology solutions

More Related