Advanced Data Preparation: 10 Essential Tools in JMP® to Get From “Messy” to “Analysis Ready” (2019-US-TUT-291)

[#1]

Level: Intermediate

Julian Parris, JMP User Acquisition

Rarely, if ever, do data come to us in an “analysis ready” format. Luckily, JMP has a rich and expansive set of tools that enable you to efficiently prepare your data for analysis. In this tutorial we explore 10 of the essential tools in JMP that help us get our data from “messy” to “analysis ready,” including methods for handling table restructuring and joining, computed and derived variables, outliers and influential points, recoding of variables, missing values and more. After we explore each of the 10 essential tools in depth and discuss best practices (and even some “off-label” uses for certain tools), we’ll work through three case studies where we will apply these tools in various ways to efficiently import, recode, restructure and reorganize complex and challenging data sets. Previous experience using JMP is highly recommended, though not strictly necessary.

Advanced Data Preparation - 10 Essential Tools

Video Player is loading.

Play Video

Play

Mute

Current Time 0:00

/

Duration 1:31:13

Loaded: 0.00%

0:00:00

Stream Type LIVE

Seek to live, currently behind liveLIVE

Remaining Time -1:31:13

1x

Playback Rate

Chapters

• Chapters

Descriptions

• descriptions off, selected

Captions

• captions settings, opens captions settings dialog
• captions off, selected

Audio Track

• en (Main), selected

Picture-in-PictureFullscreen

This is a modal window.

Beginning of dialog window. Escape will cancel and close the window.

Text

ColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-Transparent

Background

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparent

Window

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque

Font Size

50%75%100%125%150%175%200%300%400%

Text Edge Style

NoneRaisedDepressedUniformDropshadow

Font Family

Proportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall Caps

Reset restore all settings to the default valuesDone

Close Modal Dialog

End of dialog window.

Close Modal Dialog

This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.

[PatrickGiuliano]

For an excellent tutorial which provides a roadmap of tools to the avid user. 

The video post to this presentation can be found here: 

https://www.youtube.com/watch?v=faRPP8RRqcM&t=568s

[hogi]

Amazing: drag a column from summary table to the original table
~ 42min

Difficult to find this feature by chance. If the click is too short, the column stays where it is and you miss the magic.