Efficiently Managing Data from a Data Center in JMP

[#1]

Hi JMP Community,

I’m working on a project where I need to analyze a large dataset extracted from a data center. The dataset includes various metrics like server performance, energy consumption, and network latency. JMP has been great for visualizing these trends, but I’m looking for advice on how to handle real-time updates effectively.

For example, has anyone used JMP to create dashboards that automatically update when new data is uploaded? Additionally, I’m exploring ways to incorporate predictive models to forecast server performance based on historical data.

Any tips or workflows would be greatly appreciated!

[#2]

Hi @Harry_Cmary ,

JMP has a few tools/platforms to help with analysing large datasets being generated constantly, the level of 'real-time' depends on your needs and how much you need to consume the data (is it every second, minute, hour?). Here's a few areas that will be of interest:

- Data Connectors - these will allow you to communicate with your data centre to pull in your data using SQL queries - you will need an ODBC connector for your specific database. You can schedule how often the data is brought in and analyzed with JMP (going back to the question of how 'real time' you want it.

- You can create dashboards  of your analyses to provide an overview of your data that updates as new data is brought in.

- You can also automate analyses to occur regularly (i.e. a certain report and email needs to be sent out every day) by using tools like Windows Scheduler.

- From your descriptions, I would also consider looking at JMP Live - which will help to run your analyses as data comes in and presents it to your colleagues and wider company. There are some great customer successes from using this tool, if you're interested reach out to your local sales team.

Hope that's helpful.

Thanks,

Ben