<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />C28 JMP Going Beyond Spreadsheet Analytics (Valente & Wise)
Authors: Dan Valente & Scott Wise
Background: Case files and instructional recording link used in the JMP Beyond Excel Analytically Speaking Webinar to show JMP on a typical supply chain issue.
Going Beyond Spreadsheet Analytics With Visual Data Discovery
Working with dirty data can be well….dirty. Getting the information needed to make decisions can prove difficult when your data is stored in a plethora of spreadsheets, databases and formats. You will walk away from this webcast knowing how to:
· Prepare data for analysis from multiple sources.
· Gain key insights using data visualization.
· Create helpful statistical models.
· Build compelling reports and dynamic dashboards.
Tiny URL to register: http://j.mp/1IXfZs3
Alternate URL: jmp.com/beyond
Why Good: Good data set to use to covert Excel users to JMP, especially around supply chain or other spreadsheet heavy application areas. Complete case from brining in data from database or excel, to graphing, to analyzing, to final reporting/dashboarding.
Scripts:
Graph Builder
Tables
Dashboards
Partition
Fit Model
Profiler
Files Attached:
- StoreDatabase.sqlite (Database Raw Data Tables)
- StoreDatabase.xls (Excel Raw Data Worksheets)
- BeyondSpreadsheets.jmp (Final JMP Joined Datatable w/ Scripts)
