DATA QUALITY ASSESMENT IN DATA WAREHOUSES AND ANALYTIC TOOLS

Data quality assessment and assurance are very important issues in data management and overseeing their benefits may cause serious consequences for the effectiveness and efficiency of organizations and businesses. To be successful, companies need high-quality data on inventory, supplies, customers, vendors and other vital enterprise information. Data profiling and data cleaning are two essential activities in a data quality process, along with data integration, enrichment and monitoring. Data warehouses require and provide extensive support for data cleaning These loads and renew continuously huge amounts of data from a variety of sources, so the probability that some of the sources contain "dirty data" is great. Also, analytics tools offer, to some extent, facilities for assessing and assuring data quality as a built in support or by using their proprietary programming languages. This paper emphasizes the scope and relevance of a data quality assessment initiative within data management or business analytics projects, by the means of two intensively used tools such as Oracle Warehouse Builder and SAS 9.3.