Oracle business intelligence applications : deliver value through rapid implementations / Simon Miller, William Hutchinson.

Format:

Book

Author/Creator:

Miller, Simon (Oracle sales consultant), author.

Hutchinson, William, author.

Language:

English

Subjects (All):

Oracle (Computer file).

Business--Data processing.

Business.

Management information systems.

Business intelligence--Computer programs.

Business intelligence.

Physical Description:

1 online resource (1 v.) : ill.

Edition:

1st edition

Place of Publication:

New York : Oracle Press, McGraw-Hill Education, [2013]

Language Note:

English

System Details:

text file

Summary:

Implement Oracle Business Intelligence Applications Provide actionable business intelligence across the enterprise to enable informed decision-making and streamlined business processes. Oracle Business Intelligence Applications: Deliver Value Through Rapid Implementations shows how to justify, configure, customize, and extend this complete package of BI solutions. You'll get a technical walkthrough of Oracle Business Intelligence Applications architecture--from the dashboard to the data source--followed by best practices for maximizing the powerful features of each application. You will also find out about stakeholders critical to project approval and success. Optimize performance using Oracle Exalytics In-Memory Machine Deliver timely financial information to managers with Oracle Financial Analytics Enable a streamlined, demand-driven supply chain via Oracle Supply Chain and Order Management Analytics Provide end-to-end visibility into manufacturing operations with Oracle Manufacturing Analytics Optimize supply-side performance through Oracle Procurement and Spend Analytics Use Oracle Human Resources Analytics to provide key workforce information to managers and HR professionals Track the costs and labor required to maintain and operate assets with Oracle Enterprise Asset Management Analytics Maintain visibility into project performance via Oracle Project Analytics Provide actionable insight into sales opportunities using Oracle Sales Analytics Enable superior customer service with Oracle Service Analytics

Contents:

Cover

Title Page

Copyright Page

About the Authors

About the Technical Editor

Contents

Foreword

Acknowledgments

From Simon Miller

From Will Hutchinson

Introduction

Chapter 1: Crash Course in Data Warehouse Survival

The History of BI Applications

Simon Miller's Experiences

Will Hutchinson's Experiences

Requirements for a BI Application

Types of BI Applications (Kimball vs. Inmon)

Top-Down vs. Bottom-Up Approach

Operational Reporting vs. Analytical Applications

Conclusion

Chapter 2: Don't Reinvent Any Wheels

Data Warehouse Primer

What Is a BI Application?

Why Buy, When You Can Build?

Creating a Work Estimation Model

Roadmap to a Custom Built Solution

Design and Develop the Project Plan

Develop a Competency Center Around Design and Architecture Best Practices

Gather Detailed Requirements

Perform Source System Analysis

Perform Architectural Design

Design the Physical Data Model

Design the Logical Data Model and Review It with End Users

Define Security Integration Requirements

Design Test Plan

Design the BI Semantic Layer

Design ETL

Develop ETL

Test ETL

Develop Reports

Document the Application

Perform Power-User Training on the BI Platform

Perform Rollout to Production

Test Performance and Tuning

Perform End-User Training

Bringing It All Together with a Prebuilt Solution

Common Objections to BI Applications

I Already Have a Specific Technology Investment

I Have Different Data Sources, Not All Oracle

I Only Need a Handful of Reports

What About My Existing Data Warehouse?

I Need to Implement EBS First

How Do I Know This Will Be a Good Fit?

I Can Build It Myself

I Need an MDM Solution First

My Data Is Too Dirty to Report On.

I Don't Know What My Requirements Are and Users Can't Define What They Want

BI Applications Are Too Expensive

What Happened to Discoverer and Daily Business Intelligence (DBI)?

I Don't Want to Hire an Implementer

What's the Point of Implementing a Prebuilt Application If I Have to Customize?

I Already Have OBIEE, So Why Do I Need a BI Application?

Chapter 3: Oracle BI Applications Architecture

OBIEE Dashboard

OBIEE Ad-hoc Queries

OBIEE and the Semantic Layer

Physical Layer

Business Model and Mapping Layer

Presentation Layer

DAC: Execution Plan and Dependencies

Informatica: Mapping Walkthrough

Universal Adaptors

SDE Mappings

SIL Mappings

PLP Mappings

Oracle SQL Developer: Physical Data Model

What's New with DAC 11g

Security

Upgrade Considerations

Chapter 4: Exalytics: Go Fast, Not Slow

Primer on Data Warehouse Tuning

Who's in Control of the Data Design?

DBA Objections

Picking the Right Aggregates

How to Implement

How to Maintain, Monitor, and Refine

Shifting Priorities Within a Month, Quarter, or Year

Enter Exalytics

How You Can Improve Your End-User Experience

How Does It Work?

Sample Case Study

Exalytics and BI Applications

Chapter 5: Financial Analytics

Description of the Business Process

Comparing BI Applications to Other Reporting Options

Financial Reporting Options

Business Benefits

Key Stakeholders

Cross-Functional Analysis

Subject Areas

AR and AP Balances

AR and AP Overview

AR, AP, and GL Transactions

AR and AP Invoice Aging

GL Budget and Expenses

GL Balance Sheet

GL Cash Flow

Profitability

Revenue Analysis

EBS R12 SLA Transactions

Typical Configurations and Customizations

Essbase vs. Relational Database Storage.

Out-of-the-Box (OOTB) Approach

Alternative (Essbase) Approach

Other Recommended Enhancements

What to Watch Out For

Chapter 6: Order Management and Supply Chain Analytics

Order Management Process

Supply Chain (Inventory Management) Process

Faster Receipt of Cash (Via Shorter Cycle Times)

Raising On-Time Shipment Rates

Lowering Finished Goods Inventories

Better Visibility into What Orders to Ship at Month or Quarter End

Sales Overview

Orders, Backlog and Invoices Overview

Order Process

Inventory and Backlog

Backlog History

Sales Receivables

Customer Activity

Order Lines

Sales Revenue

Orders and Invoices

Backlog Lines

Booking Lines

Invoice Lines

Pick Lines

Schedule Lines

Inventory Balances

Inventory Transactions

Finished Goods BOM (Bill of Materials)

Customer and Supplier Returns

Chapter 7: Manufacturing Analytics

Improving Manufacturing and Execution

Increasing the Number of Perfect Orders Delivered

Actual Production

Discrete Quality

Kanban

Lot Genealogy

Material Usage

Inventory Pegging

Plan to Produce

Process Quality

Production Cost

Production Plan

Resource Usage

Resource Utilization

Work Order Aging

Work Order Cycle Time

Work Order Performance

Work Order Snapshot

Inventory Aging

Supply and Demand

What to Watch Out For.

Conclusion

Chapter 8: Procurement and Spend Analytics

Purchase Requisitions and Purchase Request Status

Purchase Orders

Purchase Receipts

Purchase Cycle Lines

Supplier AP Transactions

Supplier Performance

Procure to Pay

Employee Expenses

Strategic Sourcing

Spend Classification

Operation

How to Classify the Data

Advanced Model Creation

Integration with E-Business Suite iProcurement

Final Thoughts on Spend Classification

Chapter 9: HR Analytics

Absence

Compensation

Learning Enrollment and Completion

Performance

Recruitment

U.S. Statutory Compliance

Workforce Profile

Chapter 10: Enterprise Asset Management Analytics

Asset Failure Analysis

Asset History

Asset Maintenance Cost

Asset Maintenance Work Orders

Asset Meter Reading

Asset Quality

Maintenance Material Usage

Maintenance Resource Availability

Maintenance Resource Usage

MRO Inventory

Common Configurations and What to Watch Out For

Chapter 11: Project Analytics

Procurement and Spend Analytics

Financial Analytics

Metrics and KPIs.

Budget

Commitments

Forecasts

Costs

Billings

Agreements and Funding

Revenue

Chapter 12: Sales Analytics

CRM Customer Overview

CRM Forecasting

CRM Orders

CRM Pipeline

CRM Products

CRM Quotes

CRM Sales Activity

CRM Usage Accelerator Current

CRM Usage Accelerator Summary

Other Areas

Chapter 13: Service Analytics and Contact Center Telephony Analytics

CRM Activities

CRM Agreements

CRM Assets

CRM Customer Satisfaction

CRM E-mail Response

CRM Service Requests

Customer Service Overview

Enterprise Contact Center Overview

IVR

Service Delivery and Costs

Service Delivery and Costs Overview

ACD/CTI

Agent Activity

Agent Benchmarks and Targets

Agent Performance Overview

Contact Center Benchmarks and Targets

Contact Center Marketing

Contact Center Performance Overview

Contact Center Sales

Contact Center Sales Overview

Chapter 14: Making It Yours Without Ruining the Foundation

Approaching the Implementation

You Will Need to Pick an Implementer

You Will Need a Governance Process

You Will Need to Pick Your Team

The Implementation Itself

Multicurrency

Analytical Workflows

Multiple Languages

Multiple Source Systems

Multiple Tenants

Multiple Time Zones

Tuning.

EBS Flex Fields and Other Extension Fields.

Notes:

Includes index.

Description based on print version record.

ISBN:

9780071804141

0071804145

9780071804158

0071804153

OCLC:

857814757