Oracle Business Intelligence Applications

Name: Oracle Business Intelligence Applications | Deliver Value Through Rapid Implementations
Brand: McGraw-Hill Education
Price: 161.99 EUR
Availability: OnlineOnly

Deliver Value Through Rapid Implementations

William Hutchinson Simon Miller(Author)

McGraw-Hill Education (Publisher)

1st Edition

Published on 12. June 2013

425 pages

E-Book

ePUB with Adobe-DRM

System requirements

978-0-07-180415-8 (ISBN)

€161.99incl. 7% vat

System requirements

for ePUB with Adobe-DRM

E-Book Single Licence

Available for download

Description

More details

Other editions

Content

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?
Conclusion
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
Conclusion
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
Conclusion
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
Conclusion
Chapter 6: Order Management and Supply Chain Analytics
Description of the Business Process
Order Management Process
Supply Chain (Inventory Management) Process
Business Benefits
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
Key Stakeholders
Cross-Functional Analysis
Subject Areas
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
Typical Configurations and Customizations
What to Watch Out For
Conclusion
Chapter 7: Manufacturing Analytics
Description of the Business Process
Business Benefits
Improving Manufacturing and Execution
Increasing the Number of Perfect Orders Delivered
Key Stakeholders
Cross-Functional Analysis
Subject Areas
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
Inventory Balances
Inventory Transactions
Finished Goods BOM (Bill of Materials)
Supply and Demand
Typical Configurations and Customizations
What to Watch Out For
Conclusion
Chapter 8: Procurement and Spend Analytics
Description of the Business Process
Business Benefits
Key Stakeholders
Cross-Functional Analysis
Subject Areas
Purchase Requisitions and Purchase Request Status
Purchase Orders
Purchase Receipts
Purchase Cycle Lines
Invoice Lines
Supplier AP Transactions
Supplier Performance
Procure to Pay
Employee Expenses
Typical Configurations and Customizations
Strategic Sourcing
What to Watch Out For
Spend Classification
Description of the Business Process
Operation
How to Classify the Data
Advanced Model Creation
Integration with E-Business Suite iProcurement
Final Thoughts on Spend Classification
Conclusion
Chapter 9: HR Analytics
Description of the Business Process
Business Benefits
Key Stakeholders
Cross-Functional Analysis
Subject Areas
Absence
Compensation
Learning Enrollment and Completion
Performance
Recruitment
U.S. Statutory Compliance
Workforce Profile
Typical Configurations and Customizations
What to Watch Out For
Conclusion
Chapter 10: Enterprise Asset Management Analytics
Description of the Business Process
Business Benefits
Key Stakeholders
Cross-Functional Analysis
Subject Areas
Asset Failure Analysis
Asset History
Asset Maintenance Cost
Asset Maintenance Work Orders
Asset Meter Reading
Asset Quality
Inventory Aging
Maintenance Material Usage
Maintenance Resource Availability
Maintenance Resource Usage
MRO Inventory
Common Configurations and What to Watch Out For
Conclusion
Chapter 11: Project Analytics
Description of the Business Process
Business Benefits
Key Stakeholders
Cross-Functional Analysis
Procurement and Spend Analytics
Financial Analytics
Subject Areas
Metrics and KPIs
Budget
Commitments
Forecasts
Costs
Billings
Agreements and Funding
Performance
Revenue
Typical Configurations and Customizations
What to Watch Out For
Conclusion
Chapter 12: Sales Analytics
Description of the Business Process
Business Benefits
Key Stakeholders
Cross-Functional Analysis
Subject Areas
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
Typical Configurations and Customizations
What to Watch Out For
Conclusion
Chapter 13: Service Analytics and Contact Center Telephony Analytics
Description of the Business Process
Business Benefits
Key Stakeholders
Cross-Functional Analysis
Subject Areas
CRM Activities
CRM Agreements
CRM Assets
CRM Customer Satisfaction
CRM E-mail Response
CRM Orders
CRM Products
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
Typical Configurations and Customizations
What to Watch Out For
Conclusion
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
Security
Multicurrency
Analytical Workflows
Multiple Languages
Multiple Source Systems
Multiple Tenants
Multiple Time Zones
Tuning
EBS Flex Fields and Other Extension Fields
Testing and Validation
Training
Rollout Plan: How Big a Bang Should You Handle?
Dealing with a Source System Upgrade
Why a Source System Upgrade Is the Ideal Time to Implement BI Applications
How a Source System Upgrade Impacts an Existing Oracle BI Application
The Role of a Steering Committee and Center of Excellence
Adding New Content
General Customization Guidelines
Informatica
DAC
Data Model
Adding New Columns End to End
Modifying Existing Columns
Additional Tips for Category 2 and 3 Changes
How to Set Up and Configure Multicurrency
Conclusion
Chapter 15: Conclusion
Going Live Is Just the Start
More Data
More Users
More Complex Analyses
Managing the Change
The Role of Trust or Credibility of the Data
The Self-Funding Roadmap
The Roadmap Going Forward
Case Studies
Implementation Stories
Business Benefit Stories
Index

System requirements

Save as PDF Copy link into clipboard

Schweitzer Fachinformationen

Oracle Business Intelligence Applications

Description

More details

Other editions

Additional editions

Content

System requirements