Jason Wiggins, Sr. Systems Engineer, JMP
If you work with data, you have probably heard the adage that preparing your data for analysis makes up most of the time spent on analysis -- often as much as 80% or more! This talk focuses on using tools in JMP to gain knowledge from messy historic oil and gas drill rig count data. Though specific to a rig count use case, the example applies broadly to anyone who needs to gain insights from data sources, such as Excel with questionable formatting, structure and cleanliness.
The first part of the talk covers importing raw data obtained from a website, restructuring data tables, identifying errors and recoding errors with Recode. This is the 80% that must be done to get to the more exciting 20% where we glean insights. Next, I demonstrate how to use Graph Builderto gain insights from the data. The talk wraps up with using dashboards to share the insights.
