Summary: This course teaches you how to approach writing a new script in a methodical way. A realistic case study is used to illustrate the typical steps. A separate case study is developed in the course exercises. A storyboard showing the results from the script, the JMP objects that will be used by the script, and the steps necessary for the script to carry out is developed at the beginning of the course, and it is further developed throughout the course. The results are used to determine the necessary data, so the next step is identifying the analysis variables and their original data stores. Techniques to import data, cleanse and harmonize data, and derive new variables complete the first half of the course. The second half of the course teaches how to script the conversion of the variables into results. JMP objects are used to create a working framework. Each object is then customized or extended as necessary. Optional results or computations are captured in a user dialog to finish the script.
Duration: 14 hours of content.
Modalities:
- live online with instructor -- This course is available periodically in our public course schedule. The public courses are an opportunity to learn this content with a live instructor, but they are currently only offered in English and at times most convenient to a US audience (because most of our instructors are in US time zones). Don't see what you are looking for? Let us know.
- through a third-party training vendor -- Any course in our JMP Curriculum could be taught by a licensed training vendor, including through the training department at your own company. Contact your JMP representative to learn more.
Prerequisites: Before attending this course, you should complete the JMP®: Introduction to the JMP® Scripting Language course or have equivalent experience.
Learning Objectives:
- Design and build a script end to end.
- Identify data sources.
- Import data from flat files and Excel workbooks.
- Clean and transform data.
- Build a presentation from JMP objects.
- Customize objects for final results.
Course Outline:
Script Design
- Introduction.
- Identifying the data.
Data Import Design
Data Preparation
- Formatting and shaping.
- Data cleansing.
- Transformations.
Building Analytics, Reports, and Visualizations
- Building the framework.
- Building the expressions.
- Capstone and best practices.
Script the Second Analysis (Appendix)
- Script design.
- Data import design.
- Data preparation.
- Building analytics, reports, and visualizations.
Database Access (Appendix)
- Importing data stored in a relational database.