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 / / John Heaton

• Autore: Heaton John
• Pubblicazione: Birmingham, : Packt Pub., 2012
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (368 p.)
• Disciplina: 005.7565
• Soggetto topico: Relational databases; Open source software; Database management
• Note generali: "Quick answers to common problems."; Includes index.
• Nota di contenuto: 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
• Sommario/riassunto: 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.
• Titolo autorizzato: Business intelligence cookbook
• ISBN: 9786613832115; 9781283519663; 1283519666; 9781849685498; 1849685495
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910962951503321
• Lo trovi qui: Univ. Federico II