GPT-4o Changed Data Analysis Forever... (Full Guide)

The ChatGPT-4o update enhanced the data analysis feature dramatically!

--------------------
🛒AI Templates, Prompts and Courses for ChatGPT and Midjourney:

📰Subscribe to my newsletter:

🔗Follow me on Linkedin:

🐥Follow me on twitter:
--------------------

⌚Chapters:
0:00 - GPT-4o CHANGED Data Analysis
0:45 - The Best Place to Learn AI
1:59 - Data Analysis is Now FREE
2:17 - How to Find and Create Datasets
4:25 - Cleaning and Formatting Your Data
6:29 - Different Ways of Viewing Data
7:06 - Comparing Your Data
9:29 - Showing Parts of a Whole
12:10 - New Interactive GPT-4o Updates
13:07 - Viewing Trends Over Time
15:30 - Adding Another Factor
17:13 - Viewing Data Spreads
22:55 - Your Final Stop for Artificial Intelligence

#gpt4o

[ericmaza]

Great video. You were fine with cleaning as it’s different than formatting. Cleaning=duplicates, typos, unnecessary characters, character vs value (1 vs “1”), field integrity. Formatting= uniformity, readability. Cleaning is how we solve manual data entry errors, formatting is how we ensure the input is readable and avoid output errors.

[Prof_LK]

The term "clean" can be problematic because it implies removing or correcting outlier observations. Since you cannot be certain of what changes an AI might make in the background, it becomes unclear whether the charts reflect the original dataset or a modified, "cleaned" version. This lack of transparency poses a risk, as the modifications might go unnoticed, leading to potential misinterpretations of the data.

[JennTheWriter]

Very good overview on what's changed with data analysis. So glad you pointed out the cleaning and formatting part because I am sure a lot of people are NOT doing that! I like what they have done with pie charts and graphs regarding changing colors. Thank you for your video! :)

[Achielezz]

Out of the different things that can be called data analysis, this is at most descriptive and visualizing.

[drakedesuniga]

Keep slaying bro, 🔥🔥 I appreciate all your teachings.

[yoagcur]

With the scatteplot, you should take into account that your variables are limited and rounded i.e. integers (rounded to the nearest 10 in case of activity). I think you said you had more than 300 data points but 250 of them could have been a sleep rating of 9 and an activity of only 30 and the graph would, misleadingly, look the same. You could roll-over every point but would be better served to introduce some jitter into the points when graphing

[sethlamancusa]

The word clean is fine it's letting ChatGPT make the decisions about how to clean it that's problematic. What is it doing with outliers? How about nas? Is it normalizing? How? I would just add a step where you ask it to suggest strategies for cleaning the data based on the dataset and then choose specific things for it to do so that you know what you're actually doing to the data.

[ArcherScience-uw]

Should I be using the ChatGPT's Data Analyst GPT instead of the ChatGPT interface? What is the difference??

[gendi]

Excluding user input. Is the data live, or is it pulling from old sources?

[deezplace]

I hear you but I figure 1) everyone has something to learn and something to teach, 2) young folk doing anything just make me feel old - if I want them to forgive my age I need to forgive their youth, 3) don't be a hater lol
✌️ 🙏 🙇‍♂️

[remymorthier]

Instead of trying to see if there’s a trend in the scattered plot trend, couldn’t you just ask chatgpt if there’s a correlation? Or ask it to draw a regression line?

[wolf]

If someone is learning Data Analytics currently, should they be worried about this?

[Suleimanharasis]

I use GPT Chat, the paid version.. How can you make a visual representation of the data interactive and not just an image?

[renurenu]

Can one become data analyst using chatgpt only?? Plz reply

[jacobtrindade]

Ok, but it can make dumb mistakes leading you to wrong conclusions, so you can never be sure of the acuracy of the analysis..

[nicton_T]

9:25 if you have asked it to make it more beautiful or more "visulized" it wouldve made it better, im using data analysis 1 year now for visualizing a dataset its better than humans but you need to go in and out a little bit to get the good visualization that top humans can do, for example you couldve used these prompts "make it more colorful" or "make it 3d" or "makethe visualization more advanced" . i rate the update 1/10 since no new ground breaking feature were added and we already couldve used it to create more advanced vizualization .

[SocialMediaKeyWest]

It seems the updated (cleaned and formatted) spreadsheet is not downloaded. Would there be a reason the updated data sheet does not download?

[faiggorial]

Thanks a lot. Great video. May God bless you

[edmplayer]

Wait where the data taken from itself, I mean the source? And if it is generated like not-real data, how can it be bring into report?

[kwaku_]

@ai-foundation how are you able to generate the spreadsheets in chatgapt-4o? I have susbcribed but my sample data comes in text format.