Data profiling is the statistical analysis and assessment of data values within a data set for consistency, uniqueness and logic.

 

Many profiling tools exist but we are the only tool that permits:

• Complete automation of data profiling analysis

• Capability to do sampling instead of data profiling

• Storing data profiling results within the data model itself

• Controling what will be executed by table or view:

  • Check of string length

  • Count of distinct values

  • Count of nulls

  • Minimum and maximum values

  • Capture all values (if the number of values is below a specified threshold)

  • Controling parameters at a global level and populating on all tables/views

  • Association of business rules with tables or views; these business rules can be used to make cross-column analysis that can be used to expose embedded value dependencies and inter-table analysis allows the analyst to discover overlapping value sets

  • Using SAP PowerDesigner:

    • capacity to compare results in time

    • share information using a common portal or a dedicated viewer

 

Data profiling service is declined in two ways:

• Off site service: you provide accesses to the database (vpn/cloud) and we make the analysis for you.  After the analysis you receive the data model enriched with captured information plus a summary in Excel.

• On site service: we come in your site wand we make the work with you.