Oracle business intelligence applications deliver value through rapid implementations
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, confi...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
Oracle Press, McGraw-Hill Education
[2013]
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628261506719 |
Tabla de Contenidos:
- 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.
