Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
eBook - ePub

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

  1. 368 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Book details
Book preview
Table of contents
Citations

About This Book

In Detail

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.

Approach

This book is written in a simple, easy to understand format with lots of screenshots and step-by-step explanations.

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.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology by John Heaton in PDF and/or ePUB format, as well as other popular books in Computer Science & Databases. We have over one million books available in our catalogue for you to explore.

Information

Year
2012
ISBN
9781849685481
Edition
1

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology


Table of Contents

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 Program
Introduction
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 also
Organizing 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 Matrix
Creating 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
Getting ready
How to do it...
How it works...
Installing client tools for a collaborative environment
Getting ready
How to do it...
How it works...
4. Wrapping Up the Project
Introduction
Creating OWB code artifacts
Getting ready
How to do it...
How it works...
There's more...
Creating OBIEE code artifacts
Getting ready
How to do it...
How it works...
Creating APEX code artifacts
Getting ready
How to do it...
How it works...
There's more...
Creating ODI code artifacts
Getting ready
How to do it...
How it works...
There's more...
Creating script artifacts
Getting ready
How to do it...
How it works...
Building a continuous development capability for enhancements
Getting ready
How to do it...
How it works...
Creating a constant feedback and communications loop
Getting ready
How to do it...
How it works...
5. The Blueprint
Introduction
Outlining your business processes
Getting ready
How to do it...
How it works...
There's more...
Categorizing your metrics, analysis, and reports within the business process
Getting ready
How to do it...
How it works...
There's more...
Decomposing your analysis and reports to define business entities
Getting ready
How to do it...
How it works...
There's more...
Devel...

Table of contents

  1. Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology