Business intelligence cookbook [electronic resource] : a project lifecycle approach using Oracle technology / John Heaton.

ISBN:

9781849685498

9781849685481

Title:

Business intelligence cookbook [electronic resource] : a project lifecycle approach using Oracle technology / John Heaton.

Author:

Heaton, John.

Personal Author:

Heaton, John.

Publication Information:

Birmingham : Packt Pub., 2012.

Physical Description:

1 online resource.

General Note:

Title from PDF title page (viewed Aug. 1, 2012).

Contents:

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology; Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions.

1. Defining a ProgramIntroduction; Program or a project; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Mapping your business culture; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Organizations that have grown through acquisition; Organizations that have grown organically; Organizations and growth phases; Metric driven organizations; Report managed organizations; See also; Adapting your project delivery methodology; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Assessing your project team; How to do it ... ; How it works ...

See alsoOrganizing your project team; How to do it ... ; There's more ... ; See also; 2. Establishing the Project; Introduction; Creating Definition work practice; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating Data Discovery work practice; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating Development work practice; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating Testing work practice; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating Promote work practice; Getting ready; How to do it ...

How it works ... There's more ... ; Creating Production work practice; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Building a standard work breakdown structure; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Identifying and quantifying the effort drivers; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating your estimation tool; Getting ready; How to do it ... ; How it works ... ; There's more ... ; 3. Controlling the Project; Introduction; Requirements Traceability Matrix; Getting ready; How to do it ... ; How it works ... ; There's more ...

Oracle Application Express and a Requirements Traceability MatrixCreating an effective risk register; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating an effective issue management register; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Creating a defect and enhancement register; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Oracle Application Express and bug tracking; Creating a cyclical build and test process; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Setting up a collaborative environment.

Local Note:

eBooks on EBSCOhost

Subject Term:

Business intelligence -- Computer programs.

Management information systems.

Format:

Electronic Resources

Electronic Access:

Click here to view

Publication Date:

2012

Publication Information:

Birmingham : Packt Pub., 2012.

Available:*

Shelf Number	Material Type	Copy	Shelf Location	Status
658.4038011 23	1:E-BOOK	1	1:ONLINE	Searching... Unknown

Bound With These Titles

On Order

Summary

Take your data warehousing and business intelligence to the next level with this practical guide to Oracle Database 11g. Packed with illustrations, tips, and examples, it has over 80 advanced recipes to fine-tune your skills and knowledge.

Key Features Full of illustrations, diagrams, and tips with clear step-by-step instructions and real time examples to perform key steps and functions on your project Practical ways to estimate the effort of a data warehouse solution based on a standard work breakdown structure. Learn to effectively turn the project from development to a live solution Best practices to create a blueprint for the business intelligence solution Book Description Oracle Database 11g is a comprehensive database platform for data warehousing and business intelligence that combines industry-leading scalability and performance, deeply-integrated analytics, and embedded integration and data-quality all in a single platform running on a reliable, low-cost grid infrastructure. This book steps through the lifecycle of building a data warehouse with key tips and techniques along the way.Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology outlines the key ways to effectively use Oracle technology to deliver your business intelligence solution. This is a practical guide starting with key recipes for project management then moving onto project delivery.Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology is a practical guide for performing key steps and functions on your project. This book starts with setting the foundation for a highly repeatable efficient project management approach by assessing your current methodology to see how suitable it is for a business intelligence program. We also learn to set up the project delivery phases to consistently estimate the effort for a project. Along the way we learn to create blueprints for the business intelligence solution that help to connect and map out the destination of the solution. We then move on to analyze requirements, sources, and data. Finally we learn to secure the data as it is an important asset within the organization and needs to be secured efficiently and effectively. What you will learn Master some of the key techniques and components to enable you to visualise and interrogate information effectively Understand additional and advanced techniques to enhance your ETL/ELT solution Learn to build the data model using Oracle SQL Data Modeller and the Oracle Database to build your logical and physical data model and OBIEE to build the presentation data model. Develop data discovery scripts to uncover data issues and gaps Learn to reverse engineer source data models and map data sources to business requirements using Oracle SQL Data Modeller. Get to grips with mapping information into semantic definitions Understand the ways to define a security model Who this book is for

If you are Project Managers or IT professionals looking to design and develop a data warehouse and business intelligence solution, then this is the best guide for you. This book assumes that you have a fundamental knowledge of data warehouse and business intelligence projects.