Data profiling Service (DPSERV)

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.

 

 

 

 

 

 

More information on pages White Papers, ServicesProducts or Support.