How to do Advanced Data Analysis with ChatGPT
Data analysis is now easier and more reliable than ever with GPT-4o.
Within seconds you can do a correlation analysis, segmentation analysis, trend analysis, and even generate (interactive) charts that you can edit and download.
There are only two things you need:
- The Advanced Data Analysis GPT
- Clean data
Clean data means that your data file has the following attributes:
- Clean and clear headers
- One row per record
- ‘Raw’ data. So no filters or formulas applied
When you export data from a tool like Hubspot or Typeform, you (most of the time) get raw data, so it’s good to go.
If you want to see an example of clean data and follow along, here’s a Google Sheet you can download (export as CSV or .xlsx).
Here’s how you do quick data analysis in a couple of steps:
1/ Open the Advanced Data Analysis GPT
Visit this link to directly get access to the GPT. Regardless of your subscription type, it should be accessible.
2/ Upload your file
Upload your file that you want to get analyzed.
You don’t have to give a special prompt. Only submitting the file is enough.
It will automatically do a quick data exploration to see if ChatGPT can read the contents, and give you a quick summary of the contents to confirm its understanding the data you provided.
3/ Choose a specific type of analysis, or ask what you want answered
Once the initial data exploration is done ChatGPT will give you a couple of suggestions on the type of analysis it can do for you.
Of course you can deviate from these suggestions and just ask what you would like to know from the dataset.
4/ Optional: Visualize your findings
All the data analysis that ChatGPT does can be visualized in any type of chart you want.
Some charts are even interactive (like bar charts) and be customized.
You can download all charts that you generate instantly and place them in your email or presentation.
There are tons of opportunities. And if you are unsure of what’s possible with the data analysis GPT, you can always just ask the GPT itself.
It will suggest ways you can analyze it and how you can best visualize it.
