Mining for Quality: Apply Adaptive Data Quality with SQL Server Data Mining

Written by Donald Farmer. Posted in SSAS Data Mining Webcasts

Good quality data is essential to a successful business intelligence application. You are probably aware that Microsoft SQL Server includes some useful data quality tools such as Fuzzy Grouping or Fuzzy Lookup. However, there is one tool you may have overlooked—SQL Server Data Mining. When used operationally, SQL Server Data Mining is extremely useful for finding data that lies outside the boundaries of known good data, and it finds these outliers inductively rather than relying on exhaustively hard-coded rules. In this webcast, we introduce this new, adaptive approach to data quality and we show how adaptive quality can be applied at many phases of the business intelligence project—whether data entry, during warehouse loading, or during analysis.