1.Describe the roles purpose of data warehouse and date marts in an organization.
-data warehouse is a logical collection of information gathered from many different operational databases that support business analysis and decision-making tasks.
-data marts-contains a subset of date warehouse information
2.Compare the multidimensional nature of data warehouse with the two-dimensional nature of databases.
-data base contain information in a series of two dimensional tables which means that you can only ever view two dimensional of information at one time.In a database warehouse and data marts information is multidimensional it contains layers of colums and rows.Each layer in a data warehouse or data marts represents information according to an additional dimension.Dimensions could such things as products,promotion,stores,category,region.stock price,date,time and even the weather.The ability to look information from different dimensions can add tremendous business insight.
3.Identify the importance of ensuring the cleanliness of information throughout an organization.
-maintain high quality data in the data warehouse.a process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information,contact information in an operational system,standardizing customer name from operational system,information cleansing activities and accurate and complate information quality management.
4.Explain the relationship between business intelligence and data warehouse.
-business intelligence is the information that people use to support their decision-making efforts.
-data warehouse a logical collection of information-gathered from many different operational databases-that supports business analysis activities and decision-making tasks.
-
No comments:
Post a Comment