Unfortunatly, this is not happening when it comes to data anlysis.
Getting meaning out of a set of data is not possible if you don’t trust the source of the data or the way it was collected. else, your analysis would be as good as the input!
it is advised to reflect and follow best practices before setting up an your operational systems or any related changes.
Also, it is advised to setup data #governance teams to close the gaps bettween OPS and Data teams.
Long story short, avoid using free text fields in your systems if you plan to analyse that #data afterword.
