This book highlights the practical aspects of using Oracle Essbase and Oracle Business Intelligence Enterprise Edition (OBIEE) as a comprehensive BI solution. It explains the key steps involved in Oracle Essbase and OBIEE implementations. Using case studies, the book covers Oracle Essbase for analytical BI and data integration, using OBIEE for operational BI including presentation services and BI Publisher for real-time reporting services, Self-service BI- in terms of VLDB, scalability, high performance, stability, long-lasting and ease of use that saves time, effort, and costs, while maximizing ROI.
, Lakshman Bulusu
Apple Academic Press Inc.
Country of Publication:
12 December 2016
Professional and scholarly
Introduction A Basic Business Need What Is Business Intelligence? Why BI? Enabling a Competitive Advantage BI and Reporting Categories Summary Why Oracle Essbase Now OBIEE and Essbase: History and Importance Why Essbase Now: From History to Historical, Analytical, and Beyond Summary Oracle Essbase and Oracle BI: Successful Players and Products The Primary Vendors: Inventors and Presenters The Primary Products and Tools Set: Inclusions and Exclusions The Primary Users: Evaluators, Investors, Implementers and Eventual Benefiters References Analysis, Evaluation, and Selection Essential Criteria for Requirements Analysis of Oracle Essbase and OBIEE as a Comprehensive BI Solution Key and Critical Deciding Factors in Selecting Such a Solution The Final Pick is a Customer-Centric Solution: Key Indicator Checklist References Data Integration, Implementation, and Customization Using Essbase Building an Integrated Approach for Data Implementation Specifics of Data, from Data Source to Data Analytics Semantic Integration between OBIEE and Essbase, Using OBIEE as a Data Source for Oracle Essbase Extending and Customizing Essbase References Using Essbase for Analytical BI Introduction What Kind of Analytics Are Good for Essbase Cubes? Implementation Specifics of Using Analytical BI Using Essbase References Using OBIEE for Operational BI Don't Let Your Tool Wag Your Data Categories for Business Intelligence and Reporting What Is Operational Business Intelligence? Delivering Operational BI The Operational Data Store Option Using OBIEE for Self-Service BI In Search of Self-Service BI Enter OBIEE as a Solution OBIEE for Self-Service BI Big Data and Self-Service BI Best Practices for Solution Implementation and Customization Establishing a Data Foundation Based on a Logical Model Extending the Logical Data Model for Implementation and Customization The Logical Model as a Scalable Best Practice Solution Use Case Scenarios The Challenge The Resolution The Prize for the Price: A Win-Win or Not The True Value of Expertise Data-Driven Development A 360-Degree View of a Holistic Solution Oracle Big Data and the Cloud for Analytics Using the Cloud To Unleash the Potential of Big Data Oracle's Role in Cloud Services and Big Data Beyond BI References Slides from Data Warehouse Architectures Overview of the Corporate Information Factory and Dimensional Modeling Slides from OBIEE 12c Presentation Oracle Data Sheets Index
From military intelligence to business intelligence, Rosendo Abellera has made a lifelong career out of utilizing data as a critical asset. His early career in software development began with several commercial software packages across various industries and business areas, including work order management, telecom billing, prescription refill, and even voter registration. This extensive hands-on experience of developing data-driven applications has contributed heavily to his expertise and proven, successful approach to Business Intelligence (BI) and Analytics solutions development. As an early adopter and pioneer of BI coupled with modern data warehousing (DW) approaches and technologies, he has successfully architected DW and BI solutions from the ground up for leading companies, including AAA, Comcast, John Hancock Financial, Koch Industries, LexisNexis, Mercury Systems, and State Street Bank. Additionally, Rosendo has consulted a multitude of leading organizations across various industries both in the government and commercial realm. As a DW and BI Subject Matter Expert (SME) and proven successful practitioner, he has held key management positions to establish the DW and BI practices of several major, prolific consulting organizations. A consummate entrepreneur, he has founded DW and BI irms including a former Oracle Partner as well as a Big Data Analytics company. Lakshman Bulusu is a Senior Oracle Consultant with 23 years of experience in the fields of Oracle RDBMS, SQL, PL/SQL, EDW/BI/EPM, and Oracle-related Java. As an Enterprise-level data warehouse, and business intelligence solution architect/technical manager in the ORACLE RDBMS space, he focused on a best-fit solution architecture and implementation of the Oracle Industry Data Model for telecom. He has worked for major clients in the pharma/healthcare, telecom, financial (banking), retail, and media industry verticals, with special emphasis on cross-platform heterogeneous information architecture and design. He has published eight books on Oracle and related technologies, all published in the United States, as well as four books on English poetry. He serves on the development team of qteria.com and Qteria Big Data Analytics. Bulusu is OCPcertified and holds an Oracle Masters credential. He was selected as a FOCUS Expert for his research briefs titled Raising your `SIQ' (Social Intelligence Quotient): 5 Key Business Indicators, Raising your `BIQ' (Business Intelligence Quotient): 5 Things Your Company Can Do NOW, and High- Fives for an Innovative HR Strategy on FOCUS.com. He has written a host of technical articles and spoken at major Oracle conferences in the United States and abroad. He can be reached at firstname.lastname@example.org.