LEARNING OUTCOMES
1)DESCRIBE THE ROLES AND PURPOSES OF DATA WAREHOUSE AND DATA MARTS IN AN ORGANIZATIONAL.
-DATA WAREHOUSE IS A LOGICAL COLLECTION OF INFORMATION TO GATHERED FROM MANY DIFFERENT OPERATIONAL DATABASES THAT SUPPORTS BUSINESS ANALYSIS ACTIVITIES AND DECISION MAKING TASKS.
THE PRIMARY PURPOSE OF DATA WAREHOUSE IS TO AGGREAGATE INFORMATION THROUGHOUT INTO A SINGLE REPOSITORY FOR DECISION-MAKING PURPOSES.
-DATA MARTS CONTAINS A SUBSET OF DATA WAREHOUSE INFORMATION.
2)COMPARE THE MULTIMEDIMENSIONAL NATURE OF DATA WAREHOUSE (AND DATA MARTS) WITH THE TWO-DIMENSIONAL NATURE OF DATABASES.
-Databases
contain information in a series of two-dimensional tables, which means that you
can only ever view two dimensions of information at one time. In a data
warehouse and data mart, information is multidimensional, it contains layers of
columns and rows. Each layer in a data warehouse or data mart represents
information according to an additional dimension. Dimensions could include such
things as products, promotions, stores, category, region, stock price, date,
time, and even the weather.The ability to look at information from different
dimensions can add tremendous business insight.
3)IDENTIFY THE IMPORTANCE OF ENSURING THE CLEANLINESS OF INFORMATION THROUGHOUT AN ORGANIZATION.
-An
organization must maintain high-quality information in the data warehouse.Information
cleansing and scrubbing is a process that weeds out and fixes or discards
inconsistent, incorrect, or incomplete information.Without
high-quality information the organization will be unable to make good business
decisions.
4)EXPLAIN THE REALTIONSHIP BETWEEN BUSINESS INTELLIGENCE AND A DATA WAREHOUSE.
-DATA WAREHOUSE IS THE PRIMARY PURPOSE OF DATA WAREHOUSE IS TO AGGREAGATE INFORMATION THROUGHOUT INTO A SINGLE REPOSITORY FOR DECISION-MAKING PURPOSES.
BUSINESS INTELLIGENCE IS A IONFORMATION THAT PEOPLE USE TO SUPPORT THEIR DECISION-MAKING EFFORTS.
Tiada ulasan:
Catat Ulasan