Experian Data Quality Community
-
Date column recognized as "alphanumeric" while profiling
i have some date columns in my table (like below example). Just done profiling on those columns it recognizes their datatype as alphanumeric instead of date. after profiling i just right click and seen the values, there it shows as Date datatype all rows have date only in MM/DD/YY format because of this i am getting wrong…
-
Word Frequency
Every now and then a scenario crops up where it'd handy to know how often a given word occurs within a given dataset. For example you're profiling a reasonably standardised list of values (e.g. job titles) and you want to identify unusually common terms (like 'manager' 'executive' etc) or infrequent ones (like 'test123').…
-
Best approach- to do profiling for large dataset (20 million records)
Hello , I need to do profiling for tables which have more than 20million records and also the table will get update with new records as every week. 1) Is that right to do profiling for such a large dataset, will i get any performance issue? 2) as the table gets updated with new record as weekly basis, is that possible that…
-
🔎 Data profiling showcase
Ever since Aperture Data Studio’s pre-curser, Pandora, one of our most used features and most loved features of the software has been the profiling capabilities and in recent releases this has come on even further. Data profiling is fundamentally the process of rapidly evaluating data (during a discovery phase or…
-
Not been able to drill down from a view created from profile data step
I've created an interactive view from the profile data step however, after publishing the view I'm not able to drill down to the actual data. Is that the correct behaviour?