Oracle Business Intelligence [[electronic resource] ] : the condensed guide to analysis and reporting / / Yuli Vasiliev

• Record Nr.: UNINA9910785350403321
• Autore: Vailiev Yuli
• Pubbl/distr/stampa: Birmingham [England], : Packt Pub., 2010
• ISBN: 1-282-88220-1; 9786612882203; 1-84968-119-8
• Descrizione fisica: 1 online resource (184 p.)
• Collana: Enterprise : professional expertise distilled
• Disciplina: 005.7565
• Soggetti: Business - Data processing; Business report writing - Data processing
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.; "A fast track guide to uncovering the analytical power of Oracle Business Intelligence : Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder."
• Nota di contenuto: 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 database; Using 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 questions; Multidimensional 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 Reports; Starting 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 dimensions; Creating 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 item
• Sommario/riassunto: A 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 eBook