ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

Assalamualaikum bloggers. For this time, I will talk about data warehouse. It is a logical collection of information gathered from many different operational databases that supports business analysis activities and decision making tasks. Data warehouse is needed to aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

 

Data warehouse compiles information from internal database or transactional/operational databases and external databases through extraction, transformation and loading (ETL), which is a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse. Data warehouse then sends subsets of the information to data marts, which contains a subset of data warehouse information. 

Most data warehouse and data marts are multidimensional database. A cube is the common term for the representation of multidimensional information. 

Yet, there should be business intelligence which is applications and technologies that are used to gather, provide access to, and analyze data and information to support decision making efforts. To enable business intelligence, TECHNOLOGY, PEOPLE and CULTURE should be used to gain sustainable competitive advantages. 

Goodbye. Thanks for reading. :)