LEADER 05289nam 2200709 a 450 001 9910452700003321 005 20200520144314.0 010 $a1-283-51966-6 010 $a9786613832115 010 $a1-84968-549-5 035 $a(CKB)2550000000111282 035 $a(EBL)995560 035 $a(OCoLC)802882491 035 $a(SSID)ssj0000736635 035 $a(PQKBManifestationID)12268269 035 $a(PQKBTitleCode)TC0000736635 035 $a(PQKBWorkID)10783210 035 $a(PQKB)10046818 035 $a(MiAaPQ)EBC995560 035 $a(CaSebORM)9781849685481 035 $a(PPN)228047900 035 $a(Au-PeEL)EBL995560 035 $a(CaPaEBR)ebr10583712 035 $a(CaONFJC)MIL383211 035 $a(EXLCZ)992550000000111282 100 $a20120803d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBusiness intelligence cookbook$b[electronic resource] $ea 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 /$fJohn Heaton 205 $a1st edition 210 $aBirmingham $cPackt Pub.$d2012 215 $a1 online resource (368 p.) 225 0 $aEnterprise : professional expertise distilled 300 $a"Quick answers to common problems." 300 $aIncludes index. 311 $a1-84968-548-7 327 $aCover; 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 327 $aBuilding 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 327 $aCreating 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 327 $aDecomposing 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 327 $aValidating 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 327 $aBuilding changing information data profiling scripts 330 $aOver 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. 606 $aRelational databases 606 $aOpen source software 606 $aDatabase management 608 $aElectronic books. 615 0$aRelational databases. 615 0$aOpen source software. 615 0$aDatabase management. 676 $a005.7565 700 $aHeaton$b John$0131864 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910452700003321 996 $aBusiness intelligence cookbook$92199922 997 $aUNINA