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

The ChatGPT-4o update enhanced the data analysis feature dramatically!
👉🏼AiF Community: swiy.co/aifcommunity
👉🏼ChatGPT Mastery Course: hi.switchy.io/chatgpt-mastery...
--------------------
🛒AI Templates, Prompts and Courses for ChatGPT and Midjourney:
aifoundations.io/shop
📰Subscribe to my newsletter:
aifoundations.io
🔗Follow me on Linkedin:
/ drake-surach-823530203
🐥Follow me on twitter:
/ drake0dte
--------------------
⌚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

[@ai-foundations]

👉🏼The BEST Ai Community: swiy.co/aifcommunity 👉🏼ChatGPT Mastery Course: hi.switchy.io/chatgpt-mastery-course

[@jdrodrigues7]

This is what Tableau has been designed to do for years before ChatGPT existed.

[@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.

[@morrazzo4432]

Good explanation

[@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.

[@ajil2766]

yuo wrong🤦‍♂️🤬👎

[@Achielezz]

True!

[@LuisRiveraRomero]

all that can be corrected or avoided simply with more detailed instructions, this is not a problem at all.

[@ajil2766]

@@LuisRiveraRomero wrogn🤬👎

[@rachkaification]

That's exactly what I thought. What if even one value is wrong? Depending on the situation this one mistake could be fatal although if you do this for fun I guess it's not an issue.

[@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! :)

[@drakedesuniga2584]

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

[@AaronLowe1]

Thank you sir! You are awesome!❤

[@ai-foundations]

Thank you for the kind words and feedback Aaron!

[@Achielezz]

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

[@greenthumb3440]

Well done!

[@dwss6727]

Great job buddy !

[@faiggorial1424]

Thanks a lot. Great video. May God bless you

[@SocialMediaKeyWest]

Great video!

[@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

[@learnerelias3]

Great video like this

[@gendi07]

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

[@MicheleSblendorio]

Great content! Can I ask you the Top 50 companies dataset? Thnks

[@zhanibekussenbek1176]

Thank you

[@adnan_alganimi]

I like it , very good presentation

[@ProductiveDude]

Let’s gooo!

[@ai-foundations]

Yessir!

[@ProductiveDude]

@@ai-foundations This video is popping brother. So much value and love from you in this one. ♥

[@yilacaiaphas7993]

Great thanks 🙏

[@ai-foundations]

Of course!

[@WhatNowTommy]

@@ai-foundations I want to sign up for your community. I love learning A.I and one day make it into a career. Does the course inside provide certifications or credit that I can put on my linkend? Thank you Sir.

[@kwaku_2023]

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

[@SocialMediaKeyWest]

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

[@marcuspetersen2131]

Good studf here ... ty

[@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 ✌️ 🙏 🙇‍♂️

[@mra1385]

thanks for the video. did you notice your browser slowing down to a crawl after a few messages with code interpreter? how did you solve that?

[@80085games]

Nice!

[@ai-foundations]

Thank you :)

[@Ecstasio]

Claude 3.5: "Hold my beer"

[@edmplayer1226]

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?

[@waltherleonardo8652]

We expose ourselves into gpt hallucinations while cleaning. I suggest use that with caution. 😐

[@Samtechhindi668]

Is it valid for only premium members

[@jacobtrindade6728]

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

[@Jediluvs2kill]

Not everytime and even humans mistakes are dumb mistakes

[@3rdtwirl494]

Is data entry a good way to earn extra cash ?

[@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 .

[@ProductiveDude]

Hey thanks for the tips! You should join the Ai Foundations Community. You'd be able to help people out a ton with this info my friend. Check it out: swiy.co/aifcommunity

[@snithsn8159]

This seems it can analyze and visualize basics of analysis only

[@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.

[@stephenr85]

Cleaning data can include changing or removing it, especially without more specific boundaries/instructions, and if the desired outcome is to normalize the data, formatting is the correct term. This is a non-trivial, technical difference, not just how you feel about the 2 terms.

[@sethlamancusa]

@@stephenr85 all the more reason to be specific when using an lm for data analysis!

[@CM-zl2jw]

Agreed. Even ChatGPT admits it sucks at math

[@a.akacic]

167k vs

[@CM-zl2jw]

There are lies, damn lies and statistics

[@stephenr85]

I was the one to point out the issue with the word "clean", and I appreciate some of the nuanced term tweaks in this video compared to the last, or at least the acknowledgement. It may seem pedantic to many, but part of the problem with all this AI stuff is people not understanding the actual process or meaning of anything produced by the model, and that is an ignorant, dangerous destination.

[@ai-foundations]

Yes, thanks for pointing it out!

[@wolf8605]

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

[@ai-foundations]

I think they should be excited about this. They will have all the pro knowledge of Data Analytics and an assistant that makes their life 10x easier.

[@ProductiveDude]

Don't be nervous - what will matter in the future is: What you're most Passionate about AND what Value you bring to your Community or area of expertise. Be innovative, embrace these tools, go places others aren't. It's an opportunity right in front of us. Actually so many opportunities, just choose one and go! I wish you luck.

[@Xarabek]

Yes, now someone who was in the business 10-20 years and now is redundant, will get retrained and won't give you the position you want

[@wolf8605]

@@Xarabek Actually I have around 3.5 years of exp, what should I do to be safe.

[@Xarabek]

@@wolf8605 depends what you like really, going into ML is a good oath considering you already have experience

[@remymorthier4032]

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?

[@ai-foundations]

Yes you could! Great thinking man

[@yoagcur]

Yep. Relationship would be a better term. Trend implies something changing over time

[@remymorthier4032]

@@yoagcur yes you’re right, my mistake. English is not my first language, so my vocabulary is probably not as precise as it should be 😅

[@jwdeepsky]

Holy crap everything changed again?! That's the 10th time this week!

[@ProductiveDude]

This industry changes fast. It really does.

[@jwdeepsky]

@@ProductiveDude but these click bait titles never do

[@faheeta5036]

Why doesn't ChatGPT read online videos anymore?

[@ai-foundations]

Not sure, run python on make.com and pull KZbin transcript api

[@TheAndrewPR93]

Likely due to the fact that the video doesn’t have a transcript or subtitles. Happens with Chat GPT Custom GPTs and Gemini.

[@Forwardoperationbase]

This kid says chatgpt and average of 23.5 times per video. This statistics was given to me by chatgpt.

[@maikvanrossum]

So a light weight version of #Google #Sheets and graphs is changing the whole Data #Analytics industry…? It looks like the only difference demonstrated is the data source within #ChatGPT… so please, guide me to see the light 💡 here.

[@ai-foundations]

I think the biggest thing where this stand out is you can simply prompt and ask questions about your data. Can you ask google sheets a question using natural language and get a response and suggestions for what your data means? LLMs + Data and Analytics is a huge step especially for those who don't know how to interpret data with a confusing tool like sheets and excel. You can ask simple elementary questions and get beautiful insights, trend identification, graphs, etc. Super simple to use and super easy to get started and super powerful having the ability to chat with an LLM about anything relating to your data.

[@maikvanrossum]

@@ai-foundations from the Side Panel in Sheets within #Workspace, so directly on your data within it, you can use ask Gemini to analyze the data. From #Gemini Advanced you can do this by first uploading your (other) data. But as GPT changed it all, I would think you already knew this. Just like Microsoft, Google is ways ahead when it comes to business usage by integrating GenAI assistants into their offerings, where OpenAI has to build these things / tools around their LLM offering. Also look for: Gemini for Data Scientist and Analysts. It showcases AI and data visualization from a real business (or security) analytics perspective, not just a couple of rows in a spreadsheet.

[@maikvanrossum]

@@ai-foundations reply is gone. Short: yes, from the side panel in Sheets. And yes, by uploading your data. Have a look at #Gemini for Data Scientists and Analysts for a broader analytics perspective.

[@nefyodov7626]

​@@ai-foundationsI can ask power bi for example, this functionality has been available a long time ago.

[@todd1547]

I hate learning stuff from people who look like they’ve just finished playing a middle school basketball game.

[@ai-foundations]

This mentality >>> 🔥 Great wisdom Todd!

[@aayushroka5243]

​@@ai-foundationsI disagree

[@anonymouswikileaks2451]

I found this video is very value, before you say a bad thing show-us what better content you offer!.

[@aayushroka5243]

@@anonymouswikileaks2451 i agree with you

[@SilviaManentFinancialAdvisor]

That’s so rude. What’s wrong with you? Be thankful people will take the time out of their day to post great content for free so you can learn.

[@faheeta5036]

You're a nerd 😂

[@ai-foundations]

🤓

[@dg-ov4cf]

dude SHUT UP i cant heaer myself think

[@koen.mortier_fitchen]

‘This could replace Google sheets in the future.’ Bro plz. This makes me stop the vid. Honest feedback

[@Hustonwehaveaprobem]

This kid is making a KZbin channel like everyday- it’s pathetic- crime, court, reality he is making a fool of us

[@jarad4621]

Good work, you guys alwysys make the skool groups so expensive to stsrt loook into the low ticket backend strategy you will make far far more money starting cheaper líke 7 bucks so it's an impulse buy and packing it with people and then upselling more expensive upgrades in the back end, its been proven to make more every time