It is important for us to understand the need of Business Intelligence before studying it.
Managers need information in order to run an effective and profitable company. Good information lets managers know what types of changes will shift things in the company towards a more profitable end products. Today's economy is driven by information. BI helps the manager to get important information and make necessary decisions.
It is good for any BI student to read this article. It gives student an overview of the subject and I think the point is very simple and straight forward thus easy to understand.
Above Image shows the Virtuous Cycle of BI. Results become more accurate after each cycle.
BI require the support from data warehouse. Database will be created from a data warehouse. There are three types of database.
- Star Schema
- Snowflake Schema
- Constellation Schema
The star schema (sometimes referenced as star join schema) is the simplest style of data warehouse schema. The star schema consists of one tables referencing any number of dimension tables.
Snowflake Schema
A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake in shape. Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.
From one dimension can be broken down to many dimension
Constellation Schema
It contain more than one fact tables.
Detail of the three database can be found in this article. Personally I like this article as the color and the example clearly explain the linkage and difference between the three database.
Lecture 1 gives me an overall view of BI and here are some of the important tools of BI: Database, OLAP cube, Scorecards and Dashboards.
No comments:
Post a Comment