JMP can easily import CSV and Excel files, but it is not simple to process data that exceeds the Excel row limit of approximately 1.04 million or when adding conditions to the import.
The presenter analyzes emergency medical data using JMP , analyzing data on 6 million emergency transport cases per year, created in CSV and Excel files. In this presentation, he will introduce a method for loading large amounts of data using the Query Builder, which he learned during the analysis process. He will also introduce a method for loading and aggregating over 1.04 million pieces of data using Excel 's Power Query . He hopes that these techniques will be useful to practitioners who analyze large amounts of data.
