Business Intelligence

It’s a waste of time to think about unthinkable. In this way, Business Intelligence tools are designed to take exposure and to track transactional system, using Cubes. A Cube is a logical schema that contains fact and dimensions.
When I first noticed Oracle BI, it surprised me and astonished me, how this useful tool increase process efficiency and effectiveness. I said to myself that I need an extra- effort to understand key lessons.

Well, seven month or more run along, and after all, I forgot all about difficulties, on accounts of being glad and full of thinking. Now, Oracle BI, it’s a tool that I know mighty well and sure enough.

As it's well known, in order to guarantee that service levels are not affected, transactional module is meant for operations, not for analysis. In this way, analyzed process activities and supporting performance metrics can be based by an analytic module such as Oracle BI.

Within an Business Intelligence tool, two factors are often useful to create business value:

• 
  
  Automated action-taking ( into the Operational enviorment).


• 
  
  Provide an User-friendly business intelligence application.

Architecture as it's shown below, consist of:

1. Oracle BI:

We enable end-user receives feed-back from transactional system. In this way, OBI displays details about front-office eficiency, where we can include KPIs, reports and alerts. In concret, consist of the following lays:

• Physical layer: We define physical tables and connections.


• Logical layer: We define relationship between facts and dimentions.


• Presentation layer is where data is presented.

2. Informatica Power Center:

Focus on inform the analytical system, we define a set of instructions (called a workflow) in order to extract, transform and load information that receives from transactional system (executing mappings defined in the Designer). We can also monitor workflows (that we may want to perform) in the Workflow Monitor.

Best regards.
Joan.