Dario Schiraldi : How can I use JMP to analyze and integrate travel data from different sources into my website?

[#1]

Hello everyone,
I’m Dario Schiraldi, CEO of Travel Works from Dubai. I’m looking to use JMP to analyze and integrate travel data from multiple sources like flights, hotels, and car, rentals into my website to enhance my online business presence.

Can anyone suggest the best approach or tools within JMP to integrate these different data sources efficiently? I’m eager to learn how to use JMP for better data management and analysis, and any advice on implementation or best practices would be greatly appreciated!

Regards

Dario Schiraldi 

[#2]

I'm guessing the best approach would be to use the Python package integrated into JMP 18 and use it for web scraping. I'm further assuming you eventually want a structured dataset for analysis in JMP, which is at least where I'd put in your data flow.

[#3]

Web page data can also be crawled using JSL.

[#4]

I know. But my impression is that information is scant, and Python looks much better suited for this job.

[#5]

Hi @darioschiraldi1,

There are few ways that data can be brought in to JMP - either through direct file imports (like excel, txt, pdf) where you can use tools like the import wizard to grab, prepare, clean and import the data into JMP. This can be paired together with non-coding platforms like the Workflow Builder to set up a process that can automatically import, analyze and report your data. Alternatively it's possible to connect to databases and a variety of data sources with in-built data connectors . Again this tool can be combined with the query builder to set up an automated process for data import and analysis. You can also connect to web-pages to pull data out from them as well (which I assume will be a potential option for you). The Query builder is a nice way of having multiple data-sources/tables that can be joined together into one primary data table for your analysis.

Hope that helps,

Ben