首頁 > 經濟 > 統計 審計 > Business Intelligence Cookbook：A Project Lifecycle Approach Using Oracle Technology
舉報 
會員
Business Intelligence Cookbook：A Project Lifecycle Approach Using Oracle Technology
最新章節：
Index
Thisbookiswritteninasimple,easytounderstandformatwithlotsofscreenshotsandstep-by-stepexplanations.IfyouareProjectManagersorITprofessionalslookingtodesignanddevelopadatawarehouseandbusinessintelligencesolution,thenthisisthebestguideforyou.Thisbookassumesthatyouhaveafundamentalknowledgeofdatawarehouseandbusinessintelligenceprojects.
最新章節
- Index
- Enabling Virtual Private Database in OBIEE
- Configuring OBIEE catalog security
- Configuring OBIEE privileges
- Creating and configuring OBIEE roles
- Integrating Microsoft Active Directory into OBIEE
品牌：中圖公司
上架時間：2021-08-13 16:50:47
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-08-13 18:26:53
- Enabling Virtual Private Database in OBIEE
- Configuring OBIEE catalog security
- Configuring OBIEE privileges
- Creating and configuring OBIEE roles
- Integrating Microsoft Active Directory into OBIEE
- Configuring OBIEE for multiple security providers
- Creating Virtual Private application context
- Creating a column-level Virtual Private Database
- Creating a row-level Virtual Private Database (VPD)
- Creating an APEX custom authentication procedure
- Introduction
- Chapter 14. Security
- Enabling multi-language for the shared captions
- Enabling dynamic descriptions
- Enabling dynamic column headings
- Consolidating reports using the column selector
- Creating multi-table hierarchies
- Developing level-based hierarchies
- Abstracting your tables using aliases
- Developing your standards and guidelines
- Introduction
- Chapter 13. Optimizing the Access
- Creating the Upload interface
- Defining the APEX Upload application
- Defining the audit triggers
- Developing the journal tables to track changes
- Creating your application tables
- Creating your application schema
- Introduction
- Chapter 12. Enhancing the Data
- Designing a notification routine
- Designing ETL data reconciliation routines
- Designing ETL error trapping and detection routines
- Adding additional columns to facilitate error trapping and correction
- Separating your extraction from your loading and transforming routines
- Abstracting your source system
- Introduction
- Chapter 11. Defining the ETL/ELT
- Creating your enterprise data models
- How to forward engineer your logical data model to a relational data model
- Adding Standard columns to your data model
- Creating your glossary
- Creating your domains
- How to reverse engineer your relational data model to a logical data model
- How to import data models
- Synchronizing data model changes with Subversion
- Checkout data models from Subversion
- Importing data models into Subversion
- Connecting Oracle SQL Data Modeler to Subversion
- Introduction
- Chapter 10. Constructing the Data Model
- Building automated data profiling with Oracle Warehouse Builder
- Building changing information data profiling scripts
- Building significant columns data profiling scripts
- Building data lengths data profiling scripts
- Building hierarchy data profiling scripts
- Building density data profiling scripts
- Building record count profiling scripts
- Building domain/distinct values profiling
- Building high and low data profiling scripts
- Introduction
- Chapter 9. Analyzing the Data
- Defining the detailed transformations
- Developing the data lineage
- Creating a source matrix
- Creating a report requirements matrix
- Creating a business process matrix
- Validating and enhancing a conceptual data model
- Introduction
- Chapter 8. Analyzing the Sources
- Selecting the Third Normal Form or a Dimensional model
- Defining your database layout
- Choosing your database type
- Introduction
- Chapter 7. Architecture and Design
- Defining your data retention requirements
- Defining your security requirements
- Defining your data dictionary
- Adding metrics to your semantic data model
- Adding hierarchies to your semantic data model
- Prioritizing the business requirements
- Categorizing the business requirements by business drivers
- Defining the business rules
- Decomposing the reports and requirements
- Introduction
- Chapter 6. Analyzing the Requirements
- Building the blueprint
- Identifying your source of record for your business entities
- Developing your semantic data model
- Decomposing your analysis and reports to define business entities
- Categorizing your metrics analysis and reports within the business process
- Outlining your business processes
- Introduction
- Chapter 5. The Blueprint
- Creating a constant feedback and communications loop
- Building a continuous development capability for enhancements
- Creating script artifacts
- Creating ODI code artifacts
- Creating APEX code artifacts
- Creating OBIEE code artifacts
- Creating OWB code artifacts
- Introduction
- Chapter 4. Wrapping Up the Project
- Installing client tools for a collaborative environment
- Setting up a collaborative environment
- Creating a cyclical build and test process
- Creating a defect and enhancement register
- Creating an effective issue management register
- Creating an effective risk register
- Requirements Traceability Matrix
- Introduction
- Chapter 3. Controlling the Project
- Creating your estimation tool
- Identifying and quantifying the effort drivers
- Building a standard work breakdown structure
- Creating Production work practice
- Creating Promote work practice
- Creating Testing work practice
- Creating Development work practice
- Creating Data Discovery work practice
- Creating Definition work practice
- Introduction
- Chapter 2. Establishing the Project
- Organizing your project team
- Assessing your project team
- Adapting your project delivery methodology
- Mapping your business culture
- Program or a project
- Introduction
- Chapter 1. Defining a Program
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- Acknowledgement
- About the Author
- Credits
- Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
- coverpage
- coverpage
- Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Defining a Program
- Introduction
- Program or a project
- Mapping your business culture
- Adapting your project delivery methodology
- Assessing your project team
- Organizing your project team
- Chapter 2. Establishing the Project
- Introduction
- Creating Definition work practice
- Creating Data Discovery work practice
- Creating Development work practice
- Creating Testing work practice
- Creating Promote work practice
- Creating Production work practice
- Building a standard work breakdown structure
- Identifying and quantifying the effort drivers
- Creating your estimation tool
- Chapter 3. Controlling the Project
- Introduction
- Requirements Traceability Matrix
- Creating an effective risk register
- Creating an effective issue management register
- Creating a defect and enhancement register
- Creating a cyclical build and test process
- Setting up a collaborative environment
- Installing client tools for a collaborative environment
- Chapter 4. Wrapping Up the Project
- Introduction
- Creating OWB code artifacts
- Creating OBIEE code artifacts
- Creating APEX code artifacts
- Creating ODI code artifacts
- Creating script artifacts
- Building a continuous development capability for enhancements
- Creating a constant feedback and communications loop
- Chapter 5. The Blueprint
- Introduction
- Outlining your business processes
- Categorizing your metrics analysis and reports within the business process
- Decomposing your analysis and reports to define business entities
- Developing your semantic data model
- Identifying your source of record for your business entities
- Building the blueprint
- Chapter 6. Analyzing the Requirements
- Introduction
- Decomposing the reports and requirements
- Defining the business rules
- Categorizing the business requirements by business drivers
- Prioritizing the business requirements
- Adding hierarchies to your semantic data model
- Adding metrics to your semantic data model
- Defining your data dictionary
- Defining your security requirements
- Defining your data retention requirements
- Chapter 7. Architecture and Design
- Introduction
- Choosing your database type
- Defining your database layout
- Selecting the Third Normal Form or a Dimensional model
- Chapter 8. Analyzing the Sources
- Introduction
- Validating and enhancing a conceptual data model
- Creating a business process matrix
- Creating a report requirements matrix
- Creating a source matrix
- Developing the data lineage
- Defining the detailed transformations
- Chapter 9. Analyzing the Data
- Introduction
- Building high and low data profiling scripts
- Building domain/distinct values profiling
- Building record count profiling scripts
- Building density data profiling scripts
- Building hierarchy data profiling scripts
- Building data lengths data profiling scripts
- Building significant columns data profiling scripts
- Building changing information data profiling scripts
- Building automated data profiling with Oracle Warehouse Builder
- Chapter 10. Constructing the Data Model
- Introduction
- Connecting Oracle SQL Data Modeler to Subversion
- Importing data models into Subversion
- Checkout data models from Subversion
- Synchronizing data model changes with Subversion
- How to import data models
- How to reverse engineer your relational data model to a logical data model
- Creating your domains
- Creating your glossary
- Adding Standard columns to your data model
- How to forward engineer your logical data model to a relational data model
- Creating your enterprise data models
- Chapter 11. Defining the ETL/ELT
- Introduction
- Abstracting your source system
- Separating your extraction from your loading and transforming routines
- Adding additional columns to facilitate error trapping and correction
- Designing ETL error trapping and detection routines
- Designing ETL data reconciliation routines
- Designing a notification routine
- Chapter 12. Enhancing the Data
- Introduction
- Creating your application schema
- Creating your application tables
- Developing the journal tables to track changes
- Defining the audit triggers
- Defining the APEX Upload application
- Creating the Upload interface
- Chapter 13. Optimizing the Access
- Introduction
- Developing your standards and guidelines
- Abstracting your tables using aliases
- Developing level-based hierarchies
- Creating multi-table hierarchies
- Consolidating reports using the column selector
- Enabling dynamic column headings
- Enabling dynamic descriptions
- Enabling multi-language for the shared captions
- Chapter 14. Security
- Introduction
- Creating an APEX custom authentication procedure
- Creating a row-level Virtual Private Database (VPD)
- Creating a column-level Virtual Private Database
- Creating Virtual Private application context
- Configuring OBIEE for multiple security providers
- Integrating Microsoft Active Directory into OBIEE
- Creating and configuring OBIEE roles
- Configuring OBIEE privileges
- Configuring OBIEE catalog security
- Enabling Virtual Private Database in OBIEE
- Index 更新時間：2021-08-13 18:26:53
