ChatGPT Data Analysis for Beginners in 2024! (Full Guide)

[@ai-foundations]

Become a Top 1% ChatGPTer: 👉🏼ChatGPT Mastery Course: hi.switchy.io/chatgpt-mastery-course

[@junkokato-weinstein9356]

😮

[@mrme123ee]

You make great videos. It has helped a great deal. PS.. You are a very good looking dude if you didn't know. :)

[@rupalirahane2617]

Thanks for amazing info

[@brainactivity737]

Remember this is also a revolutionary learning machine. Yes, it will help with analysing loads of things but take advantage by asking it questions to further enhance your understanding. You can also ask it to make a quiz for you to ensure you've covered everything. This is a game changer and the humans that are smart enough to leverage AI will be the ones creating the future. Be one of them 🧠

[@AmanKhajanchi]

One can also change the colors of the graphs by writing a prompt "Change the blue color in the graph to green" Extending it still further, it also accepts requests for very specific colors if you provide it with a HEX Color Code.

[@DavidT99999]

Your videos are always excellent. Thanks very much!

[@ai-foundations]

Wow, thanks for the generous donation! Much appreciated

[@richardmichael7523]

Very simple to grasp and it is great you acknowledge the flexibility of analysis depending on one's particular study.

[@YT-pv8fn]

Good approach if you have the cleaned data.

[@FamNice7]

Working on my dissertation, this video was a jewel! Thanks.

[@eddym230]

Whats your dissertation about?

[@FamNice7]

@@eddym230 Telemental health implementation and training during COVID. I'm looking at worker satisfaction and if training improved worker satisfaction during that time.

[@zapfenmeister123]

How has this helped you so far? Curious, because I'll start my Dissertation in October (using Production Data)

[@growden100]

This is very helpful. I’m helping a friend analyze and report her data to her senior staff and will be using this feature.

[@rajeshbhosale2008]

Thanks for the quick nugget on ChatGPT use cases! 👍🏻

[@edosadewo]

Thanks, its made my job done in short way

[@matthewjames5090]

Great video mate. Thanks

[@sheet-chat]

Thank you, blogger. The video was excellent. 👍

[@denwo1982]

How does the enterprise licence work? If we want to use Data Analysis for work purposes I don’t want OpenAI to store our company data on their servers?

[@premrawat6700]

Right ✅️

[@jayethompson3414]

Install your own LLM on your server, like Llama, it would actually allow you to better train it for internal use.

[@denwo1982]

@@jayethompson3414 cheers will check this out. Do you recommend anything on Azure also?

[@ub03764]

That was a great 101 class. Thanks

[@emangarrison]

This is helpful. Do you have a video that shows how ChatGPT can convert spreadsheet data to a document, basically column data to sections in a report?

[@alex_316]

I think your interpretation of the box plot by the level was incorrect. You just looked at the outliers (dots) while the most important part of the chart for comparison is boxes

[@ai-foundations]

True, good call

[@Potemkin2000]

Exactly what I thought, but man is this powerful! Thanks!

[@JeanPhilippeCunniet]

interpreting / cleaning / analysis

[@estebanlucas0317]

Do you have Any resources for a biominformatic approach to the analysis? Metagenomic studies and such.

[@ak-uj2sy]

But what about data safety and company's privacy ? That data are later on processed right ?

[@DavidEide-ow5yz]

Very awesome work I hope iwill be able to keep up

[@irim.8948]

Impressive that ChatGPT can do this, but the box plots are not trends, trends refer to a time dimension by definition.

[@ChrisEck24]

is there a custom gpt that does these steps for you?

[@Detorock]

really helpfull for me as a beginner. Thumb up and sub 4 u.

[@SD-eu7ht]

Can Chat GPT do entity resolution? One of the main issues with data is quality, consistency, and standardisation. Any thoughts?

[@aurelioruprest3185]

Ok, nice video, but what if I couldn’t upload the data file for reasons of secrecy? How can I use chatgpt to help me analyze data?

[@latlov]

How to analyze datasets bigger than 1GB? should we connect chatgpt to an external database? how to achieve that?

[@ai-foundations]

I would look for a file compressor if possible, I’m not sure about connecting to external databases. You could try for manageable chunks of data as well

[@MichealScott24]

❤thank you soo mucch for amazing insights!!

[@MatbiangShadap]

Just bought your 300 custom persona, but I don't know what is happening with chatgpt currently, it is not reading any of my csv file. I have tried arranging the data to make it very simple. It cannot read the file, it will always say error analyzing. How do I go about this?

[@RodoElshoff]

I would add to be careful with cleansing. Ensure the clean up is accurate and you ensure integrity of the data

[@seanwong8249]

Yes, I wanted to know if there was a way to check the accuracy of the data after cleaning. My biggest issue with GPT is not being able to fully trust without going in and confirming the data

[@RodoElshoff]

@ this is the most difficult part. I tend to ask the prompt to do the check between the output file and the original at least at COUNT LEVEL. Either units, total gross amount, etc. Still, having to do triple checks is not effective.

[@jamesneal7762]

This guy is so legit. 💪🏽

[@b.5815]

Great clip thank you!

[@dr.jimdunnigan2784]

Excellent. work

[@DavidBBergen]

love it

[@ishajeon5238]

if i have to questionnaires do i blend the data collected and download it in chatgpt or do each questionnaire data by itself?

[@philipptietjen5719]

Hi please revise the section on how to interpret boxplots. The dots, you pointed out at the top end of the ranges are merely outliers (outside of the box). Thanks!

[@coolingicon48]

Heloo

[@shabchique7149]

Love it thanks !

[@alberttakaruza5612]

NB the 1000th like was mine ❤

[@a.account8011]

Can chat gpt update excel spreadsheet with formulas. What’s the best prompt. I found sometimes it does sometimes gets lazy

[@fernandodiaz8231]

Thank you for the information. }i have a question. Whats is the limit of records that chatGPT can drive?. Can does it worrk with 10k records?

[@macbelwoldie6201]

Can you do this with normalized data? 🙏🏼

[@chrismachabee3128]

Berry, berry good. Financial analysis be my purpose. OK.

[@jimimoris8257]

Great!

[@symeonmandrinos9528]

Thank you

[@jje984]

Having unduplicated 1000s of files in my life I'd be curious to see how it did the dedup. Removing duplicates from flat denormalized files can become extremely challenging.

[@proflead]

Interesting 👍

[@BriellaEvans-if4wf]

Good video

[@GK-qc5ry]

Excel has a data analysis feature too

[@BabuK-s2f]

Bro excellent 👌

[@MultiSangtea]

Can gpt 4 access real time data?

[@stephenmicaiah3170]

% designation and authority

[@maverick657]

great stuff, thanks,

[@scottd1342]

Go straight to about 1:36 to avoid the waffling

[@profetik777]

Love it when everyone tells us "you are not using it the right way" if you don't use this one sub feature that they are just telling us about lol

[@stephenmicaiah3170]

% function authority 2024

[@JohnMoran]

Add '...to losing your ability to do anything yourself.'

[@aminben1447]

good

[@paulm5441]

But are you able to do all that by yourself?

[@kidanetesfay4653]

Yoyr program is very interesting and timely important. Hoevere, as your followers ar from all around the world, try to present in loud and slow manner so as to make all your audiences underdtans.

[@stephenmicaiah3170]

% application 2024

[@AIRollout]

cool

[@andhivan]

You need to take more statistics classes and you understand more what ChatGPT tells you which are not quite correct!

[@Shapeshifter1210]

Where will your data be stored? I probably wont be using this sub feature for the reason that company data will be stored on their servers.

[@rayfellers]

Based on the terminalogy you use to describe the results, this video is definitely not for beginners who know nothing about the various forms of graphs and charts you mention.

[@paddy1144]

Yeah this is like learning to drive by dismantling an engine! This is for beginners who know how to analyse and visualise data! Anyone who doesn’t know the basics of that shouldn’t be starting here…

[@ccevideo]

The aim (imho) is to push his $375 course he wants you to buy. This is a cursory primer at best, not really for the masses or general education.

[@zest01]

I dunno. I’m a marketer and i haven’t fount anything advanced here. The info looks pretty clear to me, a casual user. I reckon the real data science is much more complicated than this mere example.

[@paddy1144]

@@zest01 apart from maybe the spelling of found! ;)

[@AvalanchePerformance]

I didn't see anything that wasn't for beginners. He isn't analyzing data, it's a "how to use chat gpt to analyze data" video, which is very basic. And he even explains to use chat gpt to elaborate on anything that's confusing.

[@madhuriediga5319]

BTW you are sooo cuteee

[@markwrede8878]

First prepare your food, then pop it in the microwave. Wasn't that easy?

[@coolingicon48]

Want some frends FROM AMERICA FOR EDUCATION PURPOSE .Im from INDIA 😊

[@Hiaha]

Interesting but dangereous and was already implemented partly in other tools. First, please do not simply upload company or customer data to chatgpt. At least in the EU it can get you fired. Check before with your companies IT. Second, allthough it is nice for a quick overview, actual data analysis is way more tedious and messy. You need domain knowledge and look at specific data points to understand what is going on and how you can use that data to draw conclusion or move forward to e.g. ML. Data Analysis tools have for years had in built tools to automatically clean your data, but in reality nobody uses them for good reason.

[@picklenickil]

You know the amount of data , something "REAL" uses? 😂😂

[@stephenr85]

All of this content feels like it was created by GPT. Repeatedly saying things as broad as "clean your data" with no qualifiers or exceptions shows a massive lack of data experience. "Format" would be a much more appropriate term here. And telling people that they can be a data analyst by uploading a file and asking a basic question is about as ridiculous as the term "prompt engineering". Asking a question does not make someone a data analyst or engineer. Also no mention of validating results of "cleaning" or the analysis itself. Having written thousands of scripts to MUTATE data over my career, this is an incredible feature, but if you aren't/can't validate results at multiple steps, its reliability is highly suspect.

[@ai-foundations]

Thanks for the feedback. This content was created by me so I’ll take the compliment hahah. I found using the word ‘clean’ in an LLM setting had the best results when reformatting the data, removing incomplete data or duplicates. Doesn’t mean it’s right or wrong, I just have to see what the LLM responds to best. I’m just a normal dude trying to show others how they can get a good understanding of their data and spreadsheets through ChatGPT. Good starting point for those who don’t have time or money to spend years in school studying data I think! Thanks again for the feedback man. You should give it a shot to validate the process yourself, it’s quite amazing.

[@stephenr85]

@@ai-foundations appreciate the thoughtful response. I think the only way to really validate the resulting datasets is to run them through a code validator. To automate this, it probably needs to be done via the API. I'm currently creating some data analysis tools via the API for a work project, so I think the use case is coming shortly... A semantics suggestion - prompting AI does not make someone the thing they're prompting for. This probably really irritates anyone from a respective profession. Asking it to write you a book does not make you a writer, and asking it to write some code does not make you a programmer. Using language like "you have the power of a [data analyst, writer, coder, etc] at your fingertips" would be much more correct. But, in the same way that GPT gets A LOT of facts wrong, the integrity of those results should ALWAYS come with a caveat.

[@jeetgorasia6634]

Why go to get data, GPT will make up the data for you

[@achillesglacia7700]

5 minutes into a 15minute video; and the first thing we need to do?? what you been doing for 5 mins pouring out words, clean data, pretty clean data, much clean sheet of data. smh

[@osomartinez]

this was a non value add ed video

[@StyleViewStudio]

Learn to be selective in the answers provided. ChatGPT “knowledge” stops before 2022.

[@ai-foundations]

It's April of 2023 now

[@LeonardLay]

With web browsing ability it can answer questions with more up to date information

[@adarsh-india]

useless

[@latlov]

4:16 What are radar charts 🗒

[@hadexxx]

Talks about cleaning data… uses a clean data set…. Pffff