Data Cleaning Made Easy Using JMP Automation

[#1]

This presentation walks you through one of the most important but time-consuming analytics processes, i.e Automating Data Cleaning Process

- Introduction to JMP Automation using Action Recorder & Enhanced Log (no coding required)

- Common Data Cleaning Problem:

1. Multiple Columns Name Cleanup
2. Multiple Rows Removal
3. Duplicated Rows Handling
4. Typing Errors Treatment
5. Missing Value Treatment
6. Outliers Treatment
7. Imbalanced Data Treatment

- Common Data Transformation Method:

1. Formula for Text Data Extraction
2. Formula Creation Shot-cut

- Useful Data Aggregation Method

- Additional: Datetime Data Cleaning

- Automating data-cleaning and graph-building processes as displayed

Data Sample Website : https://data.gov.sg/dataset/graduate-employment-survey-ntu-nus-sit-smu-suss-sutd

Add-ins Links : 

Data Cleaning Script Assistance : https://community.jmp.com/t5/JMP-Add-Ins/Data-Cleaning-Script-Assistant/ta-p/277748

Data Table Tools Add-ins : https://community.jmp.com/t5/JMP-Add-Ins/Data-Table-Tools-Add-in/ta-p/28582

Understanding Outliers JMP Community Series : https://community.jmp.com/t5/tag/understanding%20outliers/tg-p/board-id/jmp-blog 

You can download a copy of the Q&A with answers & guide below.