Describe the Data Problems Associated with BI Systems

Question

Examlex · Accepted Answer

The Answer is Most operational and purchased data have problems that inhibit their usefulness.When using operational data, some data may be incomplete and must be prepared before it can be analyzed.Problematic data are termed dirty data.
Purchased data often contain missing elements.Most data vendors state the percentage of missing values for each attribute in the data they sell.An organization buys such data because for some uses some data are better than no data at all.For BI applications, though, a few missing or erroneous data points can be worse than no data at all because they bias the analysis.
Inconsistent data is particularly common for data that have been gathered over time.Another problem is nonintegrated data.Data can also have the wrong granularity.Granularity is the level of detail of the data, and it can be too fine or too coarse.

Describe the Data Problems Associated with BI Systems

Definitions: