
Oracle Business Intelligence Applications
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional 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
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.