DataFlux Data Management Studio: Data Profiling

Essential data discovery for data management initiatives

DataFlux Data Management Studio provides industry-leading data profiling of data, capturing statistics that provide insight into the data. Data profiling is vital in identifying the root cause of poor-quality and disparate data sources. Through a data discovery program, Data Management Studio helps you gain the knowledge to design effective data quality, data integration and master data management (MDM) business rules to support every data-driven initiative.

Data profiling allows for a complete assessment of your organization's data, examining the structure, completeness and suitability of your data assets. Data Management Studio lets you:

  • Develop a complete assessment of the scope and nature of data quality issues
  • Create an inventory of data assets
  • Inspect data for errors, inconsistencies, redundancies and incomplete information
  • Build the foundation for future data management initiatives

DataFlux data profiling also provides industry-leading capabilities, including:

  • Business rule validation – Ensure your data meets organizational standards for data quality and business processes by validating data against standard statistical measures as well as customized business rules
  • Relationship discovery – Uncover relationships across tables and databases – and across different source applications
  • Outlier detection – Detect data that falls outside of predetermined limits and gain insight into source data integrity
  • Data validation – Verify that data in your tables matches its appropriate description
  • Pattern analysis – Ensure that your data follows standardized patterns to analyze underlying data and build validation rules
  • Statistical analysis – Establish trends and commonalities in corporate information and examine numerical trends via mean, median, mode and standard deviation

White Paper

Observing Data Quality Service Level Agreements

This white paper by David Loshin from Knowledge Integrity examines how to measure data quality and what to do when the data does not meet the level of acceptability.

White Paper

Enterprise Data Governance - How Established Is It in the Marketplace?

Mike Ferguson from Intelligent Business Strategies analyzes the results of a 2008 online survey to form a picture of where companies worldwide stand with their data governance initiatives.