Clean data. Clear insights.
- Reduce cycle time spent preparing data for analysis to let you focus on innovation, experimentation and discovery.
- Remove complexity, particularly from data often thought to be unusable (such as text, images and functions), with visual and interactive tools.
- Transform and blend data to fit your problem, not the other way around. No need to be burdened by the way "data is" currently.
Shaping tables
- Subset
- Sort
- Stack
- Split
- Transpose
- Deleting columns
- Deleting rows
- Grouping columns
- Rearranging columns
- Adding rows
- Adding columns
Merging data
- Join
- Concatenate
- Update
Metadata
- Data types
- Modeling types
- Standardizing attributes
Anomaly detection
- Unusual observations
- Outlier detection
Missing data
- Imputation
- Informative missing
- Missing data pattern
Data cleanup
- Recoding
- Editing data values
- Excluding values
- Hiding values
- Finding matching cells
Transforming data
- Derived variables
- Feature creation
- Data transformations
- Binning data
- Indicator variable
- Dummy variable
Data workflow
- Saving scripts
- Repeatability
- Workflow builder
With JMP, we can automatically assess our data quality and make improvements, including reconstructing and repairing data sets. Our data quality is the best that it's ever been.”
Philip O’Leary
Data Integration Manager, Murata
Featured Resources
- JMP takes the struggle out of data wranglingThis paper provides an introduction to the unglamorous, time-consuming, laborious, and sometimes dreaded “dirty work” of statistical investigations – data preparation. The good news: JMP can perform these operations with ease.
- Glean and Visualize Deeper Insight from Your DataHear best practices from Procter & Gamble and Michelin! Gaining skills around a multistage process of turning data into useful insights is key. You will see how interactive, no-code analytics enable any scientist or engineer to turn data into actionable insights with a combination of data preparation.
JMP® Analytic Capabilities
See everything that JMP® can do for you and your organization, from data access and cleaning, to exploration and visualization, all the way through sharing and communicating your results.