Oracle BI 11g Insync presentation
Download as PPT, PDF3 likes988 views
The document introduces Oracle Business Intelligence 11g, which provides a comprehensive and integrated business intelligence platform. It offers best-in-class products for query and analysis, OLAP, reporting, scorecards, and more on a unified foundation. Key features include interactive dashboards, spatial analysis, in-memory OLAP, report building, alerts, search, collaboration, and system management. Performance testing showed it can support over 1 million users with peak concurrency of 30,000 to 50,000 users on 20TB of data.
Oracle BI 11g Insync presentation
- 1. Presentation Title Scott Tunbridge James Nguyen Oracle Corporation 16 th August 2010 The most comprehensive Oracle applications & technology content under one roof
- 2. Introducing Oracle Business Intelligence 11 g Most complete. Most integrated.
- 3. Complete. Oracle Business Intelligence 11 g Common Business Intelligence Foundation OLTP & ODS Systems Data Warehouse Data Mart Packaged Applications (Oracle, SAP, Others) Excel XML/Office Business Process OLAP Sources Exadata Unstructured & Semi-Structured Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Detect & Alert Office Integration Search Embedded Data Integration Mobile Scorecards Collaborate
- 4. Open. Oracle Business Intelligence 11 g Common Business Intelligence Foundation OLTP & ODS Systems Data Warehouse Data Mart Packaged Applications (Oracle, SAP, Others) Excel XML/Office Business Process OLAP Sources Exadata Unstructured & Semi-Structured Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Detect & Alert Office Integration Search Embedded Data Integration Mobile Scorecards Collaborate
- 5. Integrated. Oracle Business Intelligence 11 g Common Enterprise Information Model Common Metadata Foundation across all Data Sources Common Security, Access Control, Authorization, Auditing Common Request Generation and Optimized Data Access Services Common Clustering, Workload Management, & Deployment Common Systems & Operational Lifecycle Management OLTP & ODS Systems Data Warehouse Data Mart Packaged Applications (Oracle, SAP, Others) Excel XML/Office Business Process OLAP Sources Exadata Unstructured & Semi-Structured Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Detect & Alert Office Integration Search Embedded Data Integration Mobile Scorecards Collaborate
- 6. Most Powerful End User Experience Complete. Consistent. Accurate. Interactive Dashboards Geospatial Visualization Office Integration Mobile Reports Applications & Portals Search Ad-hoc Queries Collaboration Scorecards
- 8. Extensive user interface improvements Find what you want quickly Do want you want easily Task Oriented User Experience Focus on the Answer, Not the Tool
- 9. New Interactive Visualizations Gain Insight Quicker with Greater Visibility Rich Interactive Visualizations Animated transitions Range and Paging sliders Legend-based interactions Master-Detail linking Extensive and extended set of chart types Consistent, hi-fidelity charting across Oracle product line
- 10. Oracle Scorecard and Strategy Management Strategy Management & Goal Setting Integrated BI component KPIs as core metadata Thresholds, owners, history Auto-generated interactive analyses Linked objectives & initiatives Automatic detection KPI alerts triggered by thresholds Strategy visualization Strategy Maps and Trees Cause and Effects Watchlists Annotations & override All methodologies Balanced scorecard, six sigma, Baldrige
- 11. Spatial Intelligence New Depth and Breadth of Analysis In effect, Oracle is "flipping the switch" and turning spatial into a product feature when such a capability is needed . It will be daunting to compete against this company. Microsoft, beware… we haven't heard much about geospatial and SQL Server integration lately… you are in danger of becoming a non-player. And IBM continues to play with ESRI only, and resists striking out on its own in what could be a missed opportunity. Most BI data already contains geographic dimension of analysis Deliver deeper analytical insights through Spatial visualisation and data Increase the ROI of BI & GIS systems
- 12. ROLAP Query & Analysis
- 13. Oracle BI Server EE Leading ROLAP Server Complete BI Tools Suite Consistent UI, metadata, calculations, data access, security Best ROLAP Performance Intelligent Request Generation Intelligent Function Shipping With multi-pass calculations Intelligent Aggregate Navigation Intelligent Caching Optimized Distributed Data Access Multi-user Development Enterprise consolidation & scale Heterogeneous Data Sources Relational, OLAP, unstructured Common Enterprise Information Model ORACLE BI SERVER Complete. Open. Integrated.
- 14. Best-in-Class Query & Analysis User Interface Powerful dashboards Visually appealing Intuitive 100% thin client Across all styles of analysis ROLAP, MOLAP, Scorecards, Reporting, Collaboration, Actions Across all data sources Simplified model for users Federated data access On-the-fly calculations, even with complex share and time series Custom members & groups Share, collaborate, & publish Consistency & alignment
- 15. MOLAP
- 16. Oracle Essbase Leading MOLAP Server Self-Service and Departmental Analysis Forward-looking: Prediction & what-if analysis Simple to model complex business scenarios Sophisticated, cross-dimensional calculations Procedural, financial, time series & custom calculations Custom analytic applications Multi-user write-back Best MOLAP Performance & Scalability Flexible storage – Block, Aggregate & Hybrid Optimized load performance, trickle feed High-availability clustering Benchmarked sub-second response time with 20,000 concurrent users, 15 dimensions, 1 billion records Integrated with Oracle BI and Oracle EPM Shared metadata, calculations, dimensions, security
- 17. Best-in-Class MOLAP User Interface First, seamless ROLAP & MOLAP Browser Interface OLAP Query Building with member selection Member selection Calculated members Hierarchical calculations Custom aggregates Navigate across relational and multidimensional sources Shared metadata, calculations, dimensions, security Ragged & skip-level hierarchies Performance for each source Microsoft Office Integration
- 19. Oracle BI Publisher Leading Report Server Lightweight, easy to use Easy to embed: 5 MB Download Relational, OLAP, unstructured sources Multiple output formats: XML, HTML, Word, PPT, PDF, RTF, Open Office, … Powerful & highly scalable server 1,000,000 Reports/Hour on 2 CPUs Highly scalable: Optimal resource and print queue management Active-Active clustering Separates data extraction, formatting, delivery models Dynamic font substitution Dynamic language substitution Pre-packaged reporting templates Integrated with Oracle BI Catalog
- 20. Best in Class Report Builder 100% pure thin client interface No plug-ins, native AJAX 100% lifecycle support Access data, design, schedule, manage all in thin client For interactive reporting Web-centric design For production reporting Pixel-perfect documents Microsoft Office Integration Excel, PowerPoint, Word Microsoft Office 2003, 2007 & 2010
- 21. Action Framework
- 22. First Closed-Loop Business Intelligence Solution THE OLD WAY Disconnected. Open Ended. The New Way: ACTION FRAMEWORK Integrated. Actionable.
- 23. Oracle BI Action Framework Alerting & Insight-to-Action Sense Detect business events & conditions. Respond automatically Generate and deliver reports Alert and Notify users Initiate business Processes and workflows Monitor Progress Track resolution and progress FULLY AUTOMATIC Define actions in response to insights Associate with key business conditions Navigate Guide users to relevant analysis, web content and transactional systems Take Action Initiate workflows & business processes HUMAN-DRIVEN Navigate to further analysis Initiate a business process Execute a workflow Deliver BI content Call a Web service Collaborate
- 24. Further capabilities, Deployment, System Management
- 25. Oracle BI Search Secure Enterprise Search All BI objects are searchable Metadata, dimensions, prompts, hierarchies, reports, … All data sources Full text search Full security enforced Functional & data security For users Easily locate reports, analysis and dashboards Execute selected report with correct context For analysts Find all objects affected by business model changes
- 26. Oracle BI Collaboration WebCenter Workspaces & Collaboration Integrated with WebCenter Search, tagging, tag clouds Linking & document association Discussion forums Chat, presence, & real-time collaboration Workspaces Community lists Business Intelligence in portals Dashboards, dashboard pages, scorecards, reports embeddable Standards-based portlet integration Context passing & run-time editing Personalization & skinning Oracle & other portals
- 27. Oracle BI Operational Management Comprehensive Support in Enterprise Manager Unified systems management Across all components Across entire lifecycle Performance monitoring & tuning Diagnostics & troubleshooting Across single instance & clusters 1-click scale-out & online clustering Dynamic capacity management Automate all operational tasks Develop, test, deploy Scale-out & tune Patch & upgrade cycles HA patching (rolling restart)
- 28. Summary
- 29. Oracle Business Intelligence 11 g R1 Summary Delivers best-of-breed products for Query and Analysis, OLAP, Reporting, and Scorecards On a complete, open, and architecturally unified Business Intelligence Foundation Coupled with leading packaged business intelligence and enterprise performance management applications Providing customers with superior alignment, visibility, and fastest time to value
- 30. Performance and Scalability Oracle Business Intelligence Over 1 Million named users Peak concurrency: 30,000 – 50,000 users 20 TB data
- 31. For More Information www.oracle.com/businessintelligence11g Launch webcast Demos Videos Podcasts Technical Whitepapers Data sheets Events and social media
- 32. Tell us what you think… http://feedback.insync10.com.au