Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology: 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.

Arrow left icon
Profile Icon John Heaton
Arrow right icon
Free Trial
Full star icon Full star icon Full star icon Full star icon Half star icon 4.3 (4 Ratings)
Paperback Jul 2012 368 pages 1st Edition
eBook
NZ$14.99 NZ$77.99
Paperback
NZ$96.99
Subscription
Free Trial
Arrow left icon
Profile Icon John Heaton
Arrow right icon
Free Trial
Full star icon Full star icon Full star icon Full star icon Half star icon 4.3 (4 Ratings)
Paperback Jul 2012 368 pages 1st Edition
eBook
NZ$14.99 NZ$77.99
Paperback
NZ$96.99
Subscription
Free Trial
eBook
NZ$14.99 NZ$77.99
Paperback
NZ$96.99
Subscription
Free Trial

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Chapter 2. Establishing the Project

Successful projects are like good directions—they have step-by-step instructions on how to get from your origin to the destination. A good foundation with an efficient, lightweight, set standard work practice, aids greatly in the success of a project and establishes an effective project delivery methodology. This chapter has recipes to set up the project delivery phases for a consistent way to deliver, manage, and estimate the efforts for a project. Recipes include:

  • 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

  • Building a standard work breakdown structure

  • Identifying and quantifying the effort drivers

  • Creating your estimation tool

Introduction

This chapter explores the recipes designed to show you how to build repeatable phases for your project with standard tasks. Once you have the standard tasks, you are in...

Introduction


This chapter explores the recipes designed to show you how to build repeatable phases for your project with standard tasks. Once you have the standard tasks, you are in a position to determine effort drivers and build an estimation tool.

Creating Definition work practice


The definition work practice outlines the definition phase of the project. The purpose of this work practice is to highlight the major deliverables/products and processes. The definition phase defines the project and captures the requirements.

Getting ready

Before starting, it is important to have an understanding of your project methodology and determine:

  • The existing work practices

  • The key roles which will be involved in the work practice

How to do it...

Work practices are best created as a visual tool. To do this, start up a diagramming tool such as Microsoft Visio or Microsoft PowerPoint.

  1. 1. In the diagramming application, create a new diagram called Work Practices.

  2. 2. Create a tab or a slide called Definition.

  3. 3. On the diagram, create swimlanes. In each swimlane, add the key role.

  4. 4. Step through this phase of the project logically, and add the key products/deliverables and processes.

  5. 5. A sample definition work practice is shown here:

  6. 6. Once you have...

Creating Data Discovery work practice


The data discovery work practice outlines the data discovery phase of the project. The purpose of this work practice is to highlight the major deliverables/products and processes. The data discovery phase analyzes the sources of information in detail, to determine patterns, and also to determine the similarities and differences of the source systems. This is a very interactive and exploratory phase.

Getting ready

Before starting, it is important to have an understanding of your project methodology and determine the key roles that will be involved in the work practice.

How to do it...

Work practices are best created as a visual tool. To do this, start up a diagramming tool such as Microsoft Visio or Microsoft PowerPoint:

  1. 1. In the diagramming application, create a new tab or slide called Data Discovery.

  2. 2. On the diagram, create swimlanes. In each swimlane, add the key role.

  3. 3. Step through this phase of the project logically, and add the key products/deliverables...

Creating Development work practice


The development work practice outlines the development phase of the project. The purpose of this work practice is to highlight the major deliverables/products and processes. The development phase defines the way the project deliverables are built, and the major components required.

Getting ready

Before starting, it is important to have an understanding of your project methodology and determine:

  • The existing work practices

  • The key roles which will be involved in the work practice

How to do it...

Work practices are best created as a visual tool. To do this, start up a diagramming tool such as Microsoft Visio or Microsoft PowerPoint:

  1. 1. In the diagramming application, create a new tab or slide called Development.

  2. 2. On the diagram, create swimlanes. In each swimlane, add the key role.

  3. 3. Step through this phase of the project logically, and add the key products/deliverables and processes.

  4. 4. A sample development work practice is shown here:

  5. 5. Once you have created...

Creating Testing work practice


The testing work practice outlines the testing phase of the project. The purpose of this work practice is to highlight the major deliverables/products and processes. The testing phase defines how deliverables will be assessed, and defects corrected. This work practice does not cater to all the different testing that can be performed on a project, but rather for testing specific components of the project.

Getting ready

Before starting, it is important to have an understanding of your project methodology and determine:

  • The existing work practices

  • The key roles which will be involved in the work practice

  • If testing is executed within your projects

How to do it...

Work practices are best created as a visual tool. To do this, start up a diagramming tool such as Microsoft Visio or Microsoft PowerPoint.

  1. 1. In the diagramming application, create a new tab or slide called Testing.

  2. 2. On the diagram, create swimlanes. In each swimlane, add the key role.

  3. 3. Step through this...

Creating Promote work practice


The promote work practice outlines the promote phase of the project. The purpose of this work practice is to highlight the major deliverables/products and processes. The promote phase defines how the deliverables migrated from the development to the production environment.

Getting ready

Before starting, it is important to have an understanding of your project methodology and determine:

  • Existing work practices

  • The key roles which will be involved in the work practice

How to do it...

Work practices are best created as a visual tool. To do this, start up a diagramming tool such as Microsoft Visio or Microsoft PowerPoint:

  1. 1. In the diagramming application, create a new tab or slide called Promote.

  2. 2. On the diagram, create swimlanes. In each swimlane, add the key role.

  3. 3. Step through this phase of the project logically, and add the key products/deliverables and processes.

  4. 4. A sample promote work practice is shown here:

  5. 5. Once you have created your products and processes...

Creating Production work practice


The production work practice outlines the production phase of the project. The purpose of this work practice is to highlight the major deliverables/products and processes. The production phase defines how the application will transition from a project to a production system.

Getting ready

Before starting, it is important to have an understanding of your project methodology and determine:

  • The existing work practices

  • The key roles which will be involved in the work practice

  • How production support is delivered within your organization

How to do it...

Work practices are best created as a visual tool. To do this, start up a diagramming tool such as Microsoft Visio or Microsoft PowerPoint:

  1. 1. In the diagramming application, create a new tab or slide called Production.

  2. 2. On the diagram, create swimlanes. In each swimlane, add the key role.

  3. 3. Step through this phase of the project logically, and add the key products/deliverables and processes.

  4. 4. A sample production work...

Building a standard work breakdown structure


A work breakdown structure is a deliverable that decomposes the project into smaller components.

Getting ready

Before starting, it is important to have an understanding of your project methodology and determine:

  • Your new work practices

How to do it...

Your work practices have new productions and processes outlined. Start up a tool such as Microsoft Excel or Microsoft Project, and begin recording these work practices and their associated products and processes:

  1. 1. Open a spreadsheet application.

  2. 2. Create a tab called DW WBS:

  3. 3. Start by entering your work practice names or project phases:

  4. 4. Start to decompose the phases with the major products and processes from your work practices:

  5. 5. Assign a number to each major product or process identified within your work practices.

  6. 6. Further decompose these products and processes to the major deliverable components or work tasks required by the project:

How it works...

By decomposing your work practices to...

Identifying and quantifying the effort drivers


Effort or task drivers are those components which increase the time taken to complete a task.

Getting ready

Before starting, it is important to have an understanding of the size of the project and, if possible, some historical data from past projects.

How to do it...

Once you have created the work breakdown structure, reopen this spreadsheet:

  1. 1. Create a column called Effort Drivers:

  2. 2. For each task, identify what will drive an increase or decrease in the amount of effort required to complete the task:

  3. 3. Complete step 2 for all the tasks identified at the lowest level.

  4. 4. Add an additional column for the number of effort drivers, for example, Number of Interviews - 5

How it works...

By identifying the task drivers, you are getting an understanding of the number of components or variables within your project, which can drive the scope and duration.

There's more...

Lessons learned, or historical data from past projects, is a great asset to be used...

Creating your estimation tool


An estimation tool is a great asset to a project as it defines a standard way to deliver and size a project.

Getting ready

Before starting, it is important to have an understanding of how long standard tasks take within your organization and which algorithms are used for estimation.

How to do it...

Once you have created the work breakdown structure, reopen this spreadsheet:

  1. 1. Decide on an estimation algorithm, for example, three point estimation with a weighted average and standard deviation:

  2. 2. For each task, identify how many hours you estimate a single task or component will take.

  3. 3. Apply your formula across each task.

  4. 4. Sum the tasks at the end to get a grand total of effort:

How it works...

Identifying the task drivers, base hours, and a standard estimating tool makes it easier to get a realistic effort for your project. This is, however, only an effort for one resource, and not duration. For an extra step, you will need to add dependencies and resources to...

Left arrow icon Right arrow icon

Key benefits

  • 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

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.

Who is this book 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.

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

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jul 17, 2012
Length: 368 pages
Edition : 1st
Language : English
ISBN-13 : 9781849685481

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Jul 17, 2012
Length: 368 pages
Edition : 1st
Language : English
ISBN-13 : 9781849685481

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just NZ$7 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just NZ$7 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total NZ$ 290.97
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
NZ$96.99
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
NZ$96.99
Oracle Advanced PL/SQL Developer Professional Guide
NZ$96.99
Total NZ$ 290.97 Stars icon
Banner background image

Table of Contents

14 Chapters
Defining a Program Chevron down icon Chevron up icon
Establishing the Project Chevron down icon Chevron up icon
Controlling the Project Chevron down icon Chevron up icon
Wrapping Up the Project Chevron down icon Chevron up icon
The Blueprint Chevron down icon Chevron up icon
Analyzing the Requirements Chevron down icon Chevron up icon
Architecture and Design Chevron down icon Chevron up icon
Analyzing the Sources Chevron down icon Chevron up icon
Analyzing the Data Chevron down icon Chevron up icon
Constructing the Data Model Chevron down icon Chevron up icon
Defining the ETL/ELT Chevron down icon Chevron up icon
Enhancing the Data Chevron down icon Chevron up icon
Optimizing the Access Chevron down icon Chevron up icon
Security Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.3
(4 Ratings)
5 star 25%
4 star 75%
3 star 0%
2 star 0%
1 star 0%
Delacroix Jul 31, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This a great book and I really enjoyed it. It contains everything you need to start from scratch your project and it is very useful if you have never conducted an OBIEE project. So if you want to succeed in your Business Intelligence project, get John's book !
Amazon Verified review Amazon
Julien & Emilie Oct 09, 2012
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book does a great job of introducing the various phases of a Business Intelligence project and provides practical and concrete examples of how to perform each of them successfully. Nothing is missing from 'Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology', it covers all aspects of a BI initiative from setting up the project to designing the ETL processes as well as analyzing the data and creating the data models.I don't necessarily fully agree with a few recipes in this cookbook but all in all this is an excellent book to get started on a BI project using Oracle technology.
Amazon Verified review Amazon
Paul van Rixel Sep 02, 2012
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book helps you in detail through the process of setting up a datawarehouse database. The book describes the several stages like the start of a project(team) until the creating of physical tables in the database and from a blueprint to detailed information about the code in the datawarehouse. Business events, matrixes, hierarchies, ETL, security are also covered in this book. You need to know APEX because a lot of the screenshots describes the working and combination with other tooling like SQL Developer and Modeler, Oracle Warehouse Builder (OWB), Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE) and setting up repositories. Also version control with other tooling is mentioned and are great add-ins.Furthermore the setup in APEX to audit tables (journaling) is covered in this book. Finally the presentation of the data is very well described with the OBIEE tool. It gives you an impression of formatting the data in a for the end-user readable way. And if an end-user is not allowed to see all the information the setup of a datawarehouse as a Virtual Private Database is the final stage. Almost forgot to mention a figure on page 142/3 where the several stages of a datawarehouse (sources, staging area, Datawarehouse) are linked to the tools needed (OWB, ODI, APEX, OBIEE). This will give a clear overview in which stage you need the right tooling.
Amazon Verified review Amazon
W Boudville Sep 27, 2012
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
The sheer complexity of Oracle's database products necessitates a book like this. Heaton offers this to someone perhaps trying to avoid wading through the voluminous official Oracle documentation on its vast product stack. Instead, it might be fruitful for you to invest some time in skimming through the 80 or so recipes given here, to see if any are germane to your current problems.The arrangement of the book is decidely top down. The first few chapters describe how to define a program, starting a project and controlling it. Most of these chapters do not directly use any Oracle product. Instead, the design can be recorded in any means convenient to your group. The recipes here are really indistinguishable from general guidelines in another book.You are advised to invest time early on, and not skip over the introductory chapters because they seem trivial. Bad high level decisions can ruin the implementation later on. You should also take care to flesh out the blueprint, as per chapter 5. As much detail as you can devise, perhaps, should be put into the blueprint. Write out a decomposition of the overall project into processes, where these can be manual or automated. If at all possible, define metrics for each process. These will be pertinant later in reporting analysis that provides a vital feedback loop for you to monitor the entire project.Later chapters are where, finally, you get down to using Oracle products. Like when analysing requirements. Oracle offers a SQL Developer data modelling tool to capture descriptions. The book even goes into giving an entire chapter on studying the sources of information that will be input to the project. Here the importance is in finding reliable sources. In part, this lets you validate your top data model.In summary, the book can be treated as not just specific to using Oracle products. Though of course you can certainly do just that. More broadly, it has many useful tips (recipes) on managing a data analysis project and team.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.