Choose Language Hide Translation Bar

Automated Report Creation: From Data Import to Publication ( 2019-EU-TUT-079 )

Level: Beginner
Job Function: Programmer
Brian Corcoran, JMP Director of Research and Development, SAS

JMP is a powerful analysis and visualization tool, but it is often only part of the workflow. Data can reside in a database or in an Excel file. The consumers of your report may not have JMP, and may not want to know the details of producing the end result. Finally, you may need to have this task done every day, automatically. This talk looks at an end-to-end automating of report creation using JMP Query Builder, JSL, GraphBuilder, and publishing to JMP Journals, interactive HTML and even JMP Public with help from the operating system task scheduling mechanism.

Comments
chuck_boiler

Thanks Brian!  So many will need this.  Chuck

Bass_Masri

Thanks for this Brian,

 

In a previous role I created something similar using task scheduler to query manufacturing data, create a crontrol chart and save it as a jpg picture to a server every ten minutes. A website page that pointed to the picture would refresh every ten minutes (in the html code) to show near real time statistical process control charts that the manufacturing team could use to monitor production for trends, patterns and any outliers. Very useful application.

 

Thanks Bass