Ad
related to: 6 dimensions of data quality analysis ppt
Search results
Results From The WOW.Com Content Network
Data quality assurance is the process of data profiling to discover inconsistencies and other anomalies in the data, as well as performing data cleansing [17] [18] activities (e.g. removing outliers, missing data interpolation) to improve the data quality.
Larry English prefers the term "characteristics" to dimensions. [6] In fact, a considerable amount of information quality research involves investigating and describing various categories of desirable attributes (or dimensions) of data. Research has recently shown the huge diversity of terms and classification structures used. [7]
Data profiling refers to the analysis of information for use in a data warehouse in order to clarify the structure, content, relationships, and derivation rules of the data. [3] Profiling helps to not only understand anomalies and assess data quality, but also to discover, register, and assess enterprise metadata.
Data mining is a particular data analysis technique that focuses on statistical modeling and knowledge discovery for predictive rather than purely descriptive purposes, while business intelligence covers data analysis that relies heavily on aggregation, focusing mainly on business information. [4]
ISO 8000 is the international standard for Data Quality and Enterprise Master Data.Widely adopted internationally [1] [2] [3] it describes the features and defines the requirements for standard exchange of Master Data among business partners.
The seven basic tools of quality are a fixed set of visual exercises identified as being most helpful in troubleshooting issues related to quality. [1] They are called basic because they are suitable for people with little formal training in statistics and because they can be used to solve the vast majority of quality-related issues. [2]
For example, a company might wish to summarize financial data by product, by time-period, and by city to compare actual and budget expenses. Product, time, city and scenario (actual and budget) are the data's dimensions. [3] Cube is a shorthand for multidimensional dataset, given that data can have an arbitrary number of dimensions.
The system should offer an architecture that can cleanse data, record quality events and measure/control quality of data in the data warehouse. A good start is to perform a thorough data profiling analysis that will help define to the required complexity of the data cleansing system and also give an idea of the current data quality in the ...