Business Intelligence Cookbook: A Project Lifecycle Approach by John Heaton

By John Heaton

Over eighty fast and complex recipes that target real-world concepts and recommendations to control, layout, and construct facts warehouse and company intelligence projects.

* jam-packed with illustrations, diagrams, and information with transparent step by step directions and actual time examples to accomplish key steps and services in your project
* useful how one can estimate the trouble of a knowledge warehouse answer according to a customary paintings breakdown structure.
* learn how to successfully flip the venture from improvement to a dwell solution
* top practices to create a blueprint for the company intelligence solution

In Detail

Oracle Database 11g is a entire database platform for info warehousing and company intelligence that mixes industry-leading scalability and function, deeply-integrated analytics, and embedded integration and data-quality all in one platform working on a competent, reasonably cheap grid infrastructure. This ebook steps in the course of the lifecycle of creating an information warehouse with key guidance and strategies alongside the way.

Business Intelligence Cookbook: A undertaking Lifecycle technique utilizing Oracle expertise outlines the most important how you can successfully use Oracle know-how to convey your enterprise intelligence resolution. this can be a sensible consultant beginning with key recipes for undertaking administration then relocating onto venture delivery.

Business Intelligence Cookbook: A undertaking Lifecycle method utilizing Oracle expertise is a realistic advisor for appearing key steps and features in your project.

This ebook starts off with environment the basis for a hugely repeatable effective undertaking administration strategy through assessing your present technique to determine how compatible it's for a enterprise intelligence software. We additionally learn how to organize the venture supply levels to regularly estimate the trouble for a undertaking. alongside the way in which we discover ways to create blueprints for the enterprise intelligence answer that aid to attach and map out the vacation spot of the answer. We then flow directly to study standards, resources, and knowledge. ultimately we discover ways to safe the information because it is a vital asset in the association and desires to be secured successfully and effectively.

Show description

Read or Download Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology PDF

Similar oracle books

Oracle Database 11g PL / SQL Programming

Layout Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL functions with professional tips from an Oracle programming specialist. With complete assurance of the newest positive aspects and instruments, Oracle Database 11g PL/SQL Programming lays out each one subject along specified causes, cut-and-paste syntax examples, and real-world case reports.

Oracle Weblogic Server 11gR1 PS2: Administration Essentials

This ebook is written in an easy-to-read type, with a robust emphasis on real-world, functional examples. step by step factors are supplied for appearing vital management projects. when you are an online server administrator searching for a short consultant for appearing regimen and demanding WebLogic server management capabilities, together with configuring WebLogic server and deploying Java EE purposes, then it is a ideal ebook for you.

Oracle database 11g : the complete reference

The Definitive consultant to Oracle Database 11gGet complete info at the strong good points of Oracle Database 11g from this completely up-to-date Oracle Press advisor. Oracle Database 11g: the total Reference explains how you can use all of the new good points and instruments, execute robust SQL queries, build PL/SQL and SQL*Plus statements, and paintings with huge items and object-relational databases.

Extra info for Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Sample text

The problem is that the inventory table usually stores a row for a product when its quantity of available units changes. So, the rows stored in the inventory table might look like the following: PROD_id ------111 111 222 222 333 333 EVENT_DT QUANT --------- ----05-FEB-10 15 08-FEB-10 7 05-FEB-10 17 07-FEB-10 14 05-FEB-10 7 08-FEB-10 25 [ 19 ] Getting Business Information from Data As you can see, there are days when no event happened, and therefore, what you have here is a sparse dataset. In reports that you might want to create based on this table, you will most likely need this data to be represented differently, as a dense dataset.

As with an Oracle Business Intelligence suite installation, this installation is managed by the Oracle Universal Installer. If the Installer requirements are met, the first screen you should see is the Welcome screen—the same one you saw earlier in this chapter. To move on to the next screen, just click the Next button. 4. The next screen is the Specify File Locations screen, where you can change the paths to the source and destination of the installation. Then, click Next to continue. [ 41 ] Introducing Oracle Business Intelligence 5.

And in the End User Layer field, you can specify the name of the EUL you created earlier. For more detail, you can refer to the Connect to OracleBI Discoverer page help topic, which you can invoke by clicking the help link on the login page. Summary In this chapter, you learned how to install and configure an Oracle Business Intelligence solution. In particular, you walked through the steps of installing the Oracle Business Intelligence suite and Oracle Business Intelligence Tools suite, including configuration steps discussed in the "Post-installation tasks" section.

Download PDF sample

Rated 4.75 of 5 – based on 50 votes