Monday, 10 September 2012

chapter 8

Assalammualaikum  ^_^


What do you all know about ‘data warehouse’?



That are system that gather more than one database/ information from many different operational database that about business analysis activities and decision-making tasks.

The reason why data warehouse be important, because to aggregate various information into single repository for make decisions.

Basic that involve in data warehouse

E – Extraction, T- Transformation , L- Loading   ( process that extract information from external and internal database, transform the information using a common set of enterprise definitions, and loads the  Information into a data warehouse.)



Data mart which subset information from data warehouse.




In the data warehouse, information is multidimensional that contains layer of columns and rows.

Data mining – process of analyze data extract information not offered by the raw data alone.
When data mining users to perform, they need data mining tools that are uses variety of techniques to find patterns and relationships in large volumes of information and follow the rules while making a decisions.



If the organization have observe mistake they will apply ‘information cleansing or scrubbing’ to throw information that inconsistent, incomplete or incorrect.

Information that people use to support their decision-making efforts known as Business Intelligence enablers in technology, people, and culture.

 that's all for today... assalammualaikum 



No comments:

Post a Comment