Business intelligence cookbook a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects
Over 80 quick and advanced recipes that focus on real world techniques and solutions to manage, design, and build data warehouse and business intelligence projects with this book and ebook.
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub
2012.
|
| Edición: | 1st edition |
| Colección: | Enterprise : professional expertise distilled
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627730506719 |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; 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 structureIdentifying 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 artifactsCreating 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 requirementsDefining 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 modelCreating 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
