05151nam 2200673 a 450 991081399080332120240516182216.01-282-88220-197866128822031-84968-119-8(CKB)2670000000055944(EBL)944000(OCoLC)796383604(SSID)ssj0000519317(PQKBManifestationID)11375356(PQKBTitleCode)TC0000519317(PQKBWorkID)10497830(PQKB)11635617(Au-PeEL)EBL944000(CaPaEBR)ebr10428650(CaONFJC)MIL288220(PPN)228010918(FR-PaCSA)88851857(MiAaPQ)EBC944000(EXLCZ)99267000000005594420101206d2010 uy 0engur|n|---|||||txtccrOracle Business Intelligence the condensed guide to analysis and reporting /Yuli Vasiliev1st ed.Birmingham [England] Packt Pub.20101 online resource (184 p.)Enterprise : professional expertise distilledIncludes index."A fast track guide to uncovering the analytical power of Oracle Business Intelligence : Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder."1-84968-118-X Cover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting Business Information from Data; Data, information, and Business Intelligence; The kind of business questions you may need to answer; Answering basic business questions; Answering probing analytical questions; Asking business questions using data-access tools; Deriving information from existing data; Answering business questions from your data; Comparing and analyzing data; Accessing transactional and dimensional data; Reporting against a transactional databaseUsing historical dataAggregating dimensional data; Summary; Chapter 2: Introducing Oracle Business Intelligence; What Oracle Business Intelligence is comprised of; Oracle Business Intelligence components; Composing a Business Intelligence system; Sitting on top of Oracle Database; Installing Oracle Business Intelligence software; The software you will need; Where to get the software; Installation process; Installing the Oracle Business Intelligence Tools package; Post-installation tasks; Summary; Chapter 3: Working with Database Data; Using analytic SQL functions; Answering simple questionsMultidimensional data analysis with SQLCubing; Generating reports with only summary rows; Ranking; Windowing; Accessing external sources; Discovering SQL in Discoverer; Relational implementation of the dimensional model; Database structures behind an EUL; Summary; Chapter 4: Analyzing Data and Creating Reports; Analyzing and reporting with Discoverer; Preparing your working environment with Discoverer Administrator; Exploring the Discoverer Plus IDE; Maintaining a business-oriented view of relational data; Analyzing data; Using Discoverer Viewer; Using Oracle ReportsStarting up the Reports ServerBuilding reports with Reports Builder; Summary; Chapter 5: Warehousing for Analysis and Reporting; Data organization in multidimensional data sources; Getting started with Oracle Warehouse Builder; Installing Oracle Warehouse Builder; Creating a Warehouse Builder repository schema; Creating a Warehouse Builder workspace; Building dimensional data stores with Oracle Warehouse Builder; Launching Design Center; Defining source metadata; Creating a source module; Importing database objects; Designing target structures; Creating a target module; Creating dimensionsCreating a cubeBuilding a staging table; Creating a staging mapping; Loading the staging table with data; Creating mappings for loading data into dimensions; Creating a product mapping; Creating the REGION mapping; Creating a cube mapping; Deploying; Executing; Summary; Chapter 6: Pivoting Through Data; Making database data available for use in Discoverer; Creating a crosstab worksheet in Discoverer Plus; Pivoting worksheet items; Creating a calculation; Changing the worksheet layout; Pivoting using the drag-and-drop feature; Summary; Chapter 7: Drilling Data Up and Down; What is drilling?Drilling to a related itemA fast track guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder with this book and eBookBusinessData processingBusiness report writingData processingBusinessData processing.Business report writingData processing.005.7565Vailiev Yuli1702831MiAaPQMiAaPQMiAaPQBOOK9910813990803321Oracle Business Intelligence4087646UNINA