Business Intelligence Framework (BI Framework)

first, I'd like to brifing about BI Information Flow by below picture.
This is the basic BI flow diagram used in other education modules as well.

At the top is the production data being sent to the warehouse. It funnels through ETL Tools (Extract Tranform and Loading Tools) such as DB2 Warehouse Manager or Ascential DataStage where the data is consolidated and transformed before loading into the warehouse.
In the middle, data goes into Enterprise Data Warehose(EDW). Several RDBMS such as DB2, Oracle, SQLServe may be a good choice. Note the operational data store is inside the data warehouse, not in a separate database.
In the Line Of Business Data Mart Layer. EDW then feeds the dependent data marts with data. One of these marts will be OLAP Server -- a multidimensional OLAP cube.
In the user layer (Business Intelligence Front End),It's a presentation layer that we see the tools end users choose to aggregate and distill the data into its final business form. The predominant process here is query and reporting which is performed by business partner tools. Data Management Division has purposely chosen to not invest in building end user tools, instead relying on Cognos, Business Intelligence, MicroStrategy, Crystal Decisions, Business Objects, SAS, Hyperion, Information Builders and others for this capability.
Also in the user analytics layer are Intelligent Miner, Office Connect, and Query and Reporting Tools. While most of these tools are infrastructure components, they provide specific transforms to refine the data for its final use.

From BI Information Flow, we can summary components of BI Framework like this :
1. Operational System is a database from core application and the other application in organize.
2. Extract Transform Loading (ETL) is a ETL Tool for Extract the data from operation layer, Transform and Cleansing data become a usable format and Loading Informations to DataWarehouse.
3. Enterprise DataWarehouse is a huge database that consist of the whole data in multidimensional.
4. Line Of Business Data Mart is a part of information that we separate by business requirement such as sales datamart, financial datamart etc. (we use ETL Tools for loading)
5. Business Intelligence Front End is a presentation layer that communicate with end-user.

Beside a main component, We have some additional component to fullfill business requirement such as :
Data Quality, Integrity and cleansing Tools - process before ETL tool, It use for audit, verify the right information and eliminate gabage data.
Query and Reporting Tool - use for query and reporting a data in Enterprise Data Warehouse and Line of Business Data Mart
Analytic Application Tools - for specific function for analyze and making decision suchas budgeting and planning, performance management, balance scorecard (I'll say afterward)
Data Visulization - It's an interactive, graphical, and attractive presentation in front-end. such as Crystal Xcelcius, Visual Discovery etc.
Enterprise Portal and Business Dashboad - It's use for collaborative, control user right, personalize view and design for each business requirement

Next time, I'll suggest the products from key vendors in each component.