Microsoft Excel Simple Data Profiling Spreadsheet, Analysis, Data Quality, Stats
I have created a Microsoft Excel template that provides you with column Data Profiling. A column profile determines the characteristics of columns in a data source, such as value frequency, percentages, and patterns.
Column Profiling discovers the following facts about data:
The number of: null, zero, number and string values in each column, expressed as a percentage.
Statistics about string lengths and: min, max, average and median.
Statistics about each column values, such as min, max, average and median.
Patterns of data in each column and the frequencies with which these values occur.
Check it out here and many other great templates. https://excel-template.co.uk/shop
Posted by excel-template on
There are currently no replies to the "Data Profiling in Excel" topic of the Excel Help Forum for Automating Data Analysis Tasks.