1st Edition

Oracle Business Intelligence and Essbase Solutions Guide




ISBN 9781482234077
Published December 12, 2016 by Auerbach Publications
216 Pages 110 B/W Illustrations

USD $74.95

Prices & shipping based on shipping country


Preview

Book Description

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.

Table of Contents

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

...
View More

Author(s)

Biography

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 [email protected]