ChatGPT for Data Analytics: Beginner Tutorial
Рет қаралды 80,852
Күн бұрын⚠️ Update⚠️ The full course is now available for FREE 👉 • ChatGPT for Data Analy...
(If you watched this full video, then skip over to 1:03:27 in that video)
Resources Mentioned in this Video
==================================
💬 ChatGPT Chat History: lukeb.co/chat_ada
💽 Kaggle Job Posting Data Set: lukeb.co/FreeData
🤖 Course Chatbot: lukeb.co/chatgpt_chatbot
📝 Sign up for ChatGPT cheat sheet: lukebarousse.com/
🌠 Pictures for Image Exercise: lukeb.co/chatgpt_images
Other Courses for Data Nerds
==================================
📜 Google Data Analytics Certificate 👉🏼 lukeb.co/GoogleCert
🐍 Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
💿 SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 lukeb.co/ExcelBusinessAnalyst
📈 PowerBI for Data Viz 👉🏼 lukeb.co/PowerBI
📊 Tableau for Data Viz 👉🏼 lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 lukeb.co/RforDataScienceJH
➕ Coursera Plus Subscription (7-day free trial) 👉🏼 lukeb.co/CourseraPlus
👨🏼🏫 All courses 👉🏼 kit.co/lukebarousse/data-anal...
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 kit.co/lukebarousse/book-reco...
📗 Data Analyst Must Read 👉🏼 geni.us/StorytellingWithData
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebarousse/computer-...
🪟Windows Virtual Machine for Mac (Parallels) 👉🏼 lukeb.co/ParallelsFreeTrial
Social Media / Contact Me
======================
👾 r/DataNerd 👉🏼 / datanerd
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
🙋🏼♂️Newsletter: www.lukebarousse.com/
As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
00:00 Intro
01:43 🤖 Options & Setup
05:58 🚶♂️ Walkthrough
10:56 💬 Prompting
15:27 ⚙️ Settings
19:41 🌠 Images
25:39 My Course: ChatGPT for Data Analytics
28:06 ⏱️ Timeout Issues w/ ADA
29:38 🧑💻 Project Intro
31:28 🧮 Intro to Advanced Data Analysis
39:14 🗳️ Connect to Data
42:28 🔍 Explore Data
47:21 🧹 Clean Data
49:34 📊 Visualize Data
53:55 🔮 Predict Data
01:01:07 ⚠️ Limitations & Security
01:05:22 🏁 Course Wrapup
#datanerd #dataanalyst #datascience
@LukeBarousse 3 ай бұрын
Data Nerds! I've decided to make this full course available on KZfaq 👉kzfaq.info/get/bejne/q86pgNSTv6-aooE.html P.S. If you watched this full video then just skip over to 1:03:27 in that video, you'll pick right up where we left off 👌🏼
@catalinagalan 3 ай бұрын
Hi! I was watching another video of yours where you said that your chat gpt course was cancelled last year??? I’m confused, is this a newer one?
@Abhi_Nav 4 ай бұрын
Such a valuable video! 👏 Looking forward for the full course.. Thanks for doing what you! I learn a lot from you. 🙏💙
@LukeBarousse 5 ай бұрын
Video Updates: 4:45 ChatGPT waitlist is no longer being implemented (Source: Sam Altman Tweet on 12/13/23) 17:39 & 36:14 - Enable ADA in Settings - This is no longer required to be enabled in settings
@grabik4402 5 ай бұрын
2 issues with this: 1. How do you find a friend? 2. How do you find a friend that has gpt4?
@phineasndhlau7618 4 ай бұрын
Excellent teaching style. Swift and fluid. 🙏🏾
@LukeBarousse 4 ай бұрын
Much appreciated!
@salmanthebestful 5 ай бұрын
thank you for this Luke!!
@seanbill942 5 ай бұрын
Great video and nice job explaining how ChatGPT data analytics works for us lay people!
@LukeBarousse 5 ай бұрын
Glad it was helpful 🙌
@hilmanagung 2 ай бұрын
Excellent Video! Thank you so much, I learned a lot in an hour
@pillslifestylereviews6714 5 ай бұрын
Thank You for the Amazing lesson.
@rajakr2096 4 ай бұрын
Terrific video. Keep it up❤
@zabashhd459 5 ай бұрын
This Video Is Gold
@nicolasmcontreras 5 ай бұрын
Thanks Luke. I finally watched it. ❤
@LukeBarousse 5 ай бұрын
Hope you enjoyed it!
@tosinwilliams9343 3 ай бұрын
Please do more videos on this ChatGPT for Data Analytics 🙏🙏🙌🙌🙌🙌
@user-mr5zq5ey9t 3 ай бұрын
Hi Luke thank you for this awesome tutorial. It realy makes me happy! i have a question. I have followed the instructions, but chatgpt reponds it cannot build a model. In stead is responds a method to build a random forrest model with python etc. Has something changed of am i doing something wrong? thank you for a response. Joost (The Netherlands)
@michaelmcmanus2186 5 ай бұрын
Kudos to Luke for continuing the democratization of education!!!!
@LukeBarousse 5 ай бұрын
Heck yeah! Thank you!!
@abhasmalguri2905 5 ай бұрын
Great Luke! Was expecting this type of video 😊❤
@abhasmalguri2905 5 ай бұрын
@@FolisaaLuke sir keep his content updated. If you look at the videos he posted in past 2-3 month his content was usage of ai tools in data analysis. So it become obvious the content would converge to a one shot video of this topic. Regards
@MuslimFriend23 5 ай бұрын
You've come a long way my friend, all the best insh'Allah
@LukeBarousse 5 ай бұрын
Thanks my friend!
@MuslimFriend23 5 ай бұрын
I would like to add something, your are a facilitator, you made it easy for me to restart coding (the "how I use python" video)@@LukeBarousse 👏👏👏
@The_Creative_1983 5 ай бұрын
that amazing. I'm on the waiting list for cheatgpt 4
@LukeBarousse 5 ай бұрын
I hear you can skip the waitlist if you get a referral code from a ChatGPT Plus user; reach out to your friends and ask!
@The_Creative_1983 5 ай бұрын
Thanks. I just got it today.
@micbab-vg2mu 5 ай бұрын
Nice - thank you
@dingdingligeding 27 күн бұрын
Hi, can you talk about more about the right excel formatting for ChatGPT? I usually get a very specific excel sheet for the user tests results. It seems to be very difficult for ChatGPT to get all the information.
@tarinitup17 5 ай бұрын
Hey Luke, great video. Do you have any major concerns about uploading data sets and files that could contain private/sensitive customer information to ChatGPT? It would be really useful for my job but I am hesitant to upload any data that might contain any sensitive customer-related data (e.x. phone, name, address, etc) to Chat since I don't know how they store or handle data on their end. Any thoughts?
@LukeBarousse 5 ай бұрын
it really depends on the data; i would check with your employer. ChatGPT Enterprise seems to be the go to solution for what companies can use to protect their data and ensure it's secure, but that's something your company will need need to provide for you
@Papiaso 3 ай бұрын
What do they charge for gpt enterprises (approximately)? @@LukeBarousse
@keylanoslokj1806 4 ай бұрын
Which extensions have you implemented on chatgpt for Data analytics
@bamideledamilare5940 5 ай бұрын
Unfortunately, I couldn’t upgrade to GPT 4 as according to OpenAI there’s tons of request at the moment. Will definitely be trying this.
@LukeBarousse 5 ай бұрын
Let me know when you get access, I'm curious on the wait times; I applied with a seperate account and am also monitoring, but curious if it's the same for others
@eduardoactd 5 ай бұрын
@@LukeBarousse I asked for it like 10 days ago and today I already added the sub with my credit card =)
@fabiogal1811 5 ай бұрын
I could upgrade today it's awesome
@denwo1982 4 ай бұрын
Early members should be given shares to OpenAI, new members are so desperate for the paid service now
@realgouravverma 3 ай бұрын
Please explain the difference between data analysis and data analytics. And also explain that data engineering and data science. All of these are so much confusing because all looks same to me.
@xiaojietian3397 5 ай бұрын
Thank you for this nice tutorial video. I have upgraded ChatGPT to Plus, but in my settings-Beta features, there is only a "Plugins" button, but no "Advanced data analysis". The whole part "Advanced data analysis" is not there. Could you give me some advice for this?
@LukeBarousse 5 ай бұрын
It's now included in the core model of "GPT-4", you no longer need to select it
@coindivision388 5 ай бұрын
How do you deal with floating point imprecision in Python?
@rsandilyav 4 ай бұрын
@lukebarousse Great Video. Thanks for doing this. I have a sales transactions excel file with about 120K rows (transactions). ChatGPT seems unable to process it and keeps erroring out. Is there a limit on the number of rows ChatGPT can handle?
@LukeBarousse 4 ай бұрын
I only know of the file size limits, not necessarily of a row size limit. If the file fits ChatGPT should be able to handle it
@grabik4402 5 ай бұрын
Nice video, thanks. I am unable to upgrade to gpt4 due to the freeze, is there anyone able to share a referral?
@AladdinAlswaifi 3 ай бұрын
Great video. Thank you, Luke. I subscriped for ChatGPT plus but I can not find the Advanced data tool in the settings. How can I sort this out?
@LukeBarousse 3 ай бұрын
It's no longer located in settings, it's auto included in the most advanced model
@a.c.bonneville189 4 ай бұрын
I like this guy
@kushkhurana2523 3 ай бұрын
Loving the program so far, but small problem: When I drag the attachment or use the paperclip, ChatGPT doesn't allow me to send it. The send button is grayed out and the Enter button skips a line. I think it's because the zip file is 60 MB and ChatGPT's maximum is 50 MB.
@milicy 3 ай бұрын
Hi Luke, i see your course is on hold - when will it be available for watching?
@LukeBarousse 3 ай бұрын
Hopefully sooon!
@nicolastarazona4196 5 ай бұрын
What is the purpose of studying tools for Data Science, such as Python, Numpy, Pandas, and Scikit-learn, with chatgpt4?
@Flylikea 5 ай бұрын
To get paid more in order to fix the data analytics the gpt analytics people will try to generate Edit: a couple of months have passed and I'll give you some more reasons on why to learn this stuff -> gpt can help you do things faster, but if you don't know what you are doing you can easily go faster in the wrong direction. Do you know how that translates to a work environment? Underqualified drama queens wasting time with theatrics and politics of vanity.
@LukeBarousse 5 ай бұрын
It's still worthwhile to learn, and I feel even more accessible to learn and implement with these types of tools. As great as ChatGPT is at automating tasks, it's good to have a core understanding of the technologies that it's using to make sure you're getting the correct results
@nicolasmcontreras 5 ай бұрын
You simply wouldn't understand the output. Or you will learn by doing it with the chat.
@InnocentiusLacrimosa 4 ай бұрын
There have always been and always will be different tiers of data analysts.
@alexstrums 2 ай бұрын
I guess it’s like playing the guitar. You can just learn songs via online videos OR you can learn some basic theory which will allow you to understand how a song is created and also give you options to improvise. Knowing the foundations will make you a better data analyst/scientist
@gregNFL 3 ай бұрын
If anyone is confused when they do not see 'Advanced Data Analysis' toggle in Beta Features, don't despair. It has been removed by Open AI. Advanced Data Analysis is enabled by default for all Plus users.
@h_kvideography3286 3 ай бұрын
Hello Luke, Thank you for the efforts meanwhile I am facing a problem< i cant see the option of advance data analysis option to turn on, in CHAT GPT 4 . What is the problem
@LukeBarousse 3 ай бұрын
It's no longer included in the menu, it's auto-included so don't worry about it
@h_kvideography3286 3 ай бұрын
Thanks a lot @@LukeBarousse
@derien5433 3 ай бұрын
is 40 messages per 3 hrs sufficient for you? Would it make sense to create a company account with a / some friend(s) to have unlimited cap?
@LukeBarousse 3 ай бұрын
in most cases it is, I feel I run into it only ever so often; so for me getting a company account wouldn't be worth it
@benjamindevoe8596 5 ай бұрын
Browse with Bing and Advanced Data Analysis were not available as plugins on ChatGPT-4. Do you have any alternate suggestions you would prefer someone taking this course to use?
@LukeBarousse 5 ай бұрын
Advanced Data Analysis & Browse with Bing are now included as part of the core model of GPT-4, there is no need to select it
@LukeBarousse 5 ай бұрын
7:54
@benjamindevoe8596 5 ай бұрын
@@LukeBarousse I knew that but I let my OCD win the day apparently! Sigh! Lol! thanks!
@juanlauroaguirre5646 4 ай бұрын
Hi Luke, I tried buying your course but it’s halted right now ☹️ so just registered at your waitlist. Do you have any idea when you will restart it?
@LukeBarousse 4 ай бұрын
Hey Juan, i'm currently working to package it up and make it freely accessible on KZfaq, should have it launched in the next couple of weeks!
@juanlauroaguirre5646 4 ай бұрын
@@LukeBarousse freely available? So it won’t cost 100 bucks? Thanks man you rock !!
@ilhemdjenane9447 4 ай бұрын
I just purchased the Chatgpt 4 but when I ask it to analyse something it keeps saying there was an error generating a response.
@GeonQuuin 5 ай бұрын
I'm very tempted to use this for my project. But would I be violating our company's confidentiality if I feed chatgpt data generated by our company?
@grabik4402 5 ай бұрын
Juat don't, it's not worth the risk. You are not gaining much by using company data, yet there is chance you get fired/sued for that.
@LukeBarousse 5 ай бұрын
Yeah for company data, you need to be careful and consult your manager for how to handle this. ChatGPT Enterprise is the safe solution that companies can implement in order to ensure that there data is protected, while also being aware that their employees are using it with company data
@edilmagiraldo9366 5 ай бұрын
I don't see the Advanced Data Analysis in the Beta features in my ChatGPT, still going to finish the video and see if I can still do everything.
@LukeBarousse 5 ай бұрын
Advanced Data Analysis is now included as part of the core model of GPT-4, there is no need to select it
@LukeBarousse 5 ай бұрын
7:54
@hong9862 3 ай бұрын
Do you have any idea why I do not see Advanced Data Analysis under Beta features?
@LukeBarousse 3 ай бұрын
It's no longer there, it's auto enabled
@guillermodevivanco7957 Ай бұрын
Hi Luke, I subscribed to ChatGPT 4 but my beta features only include plugins, no data analytics. What could be happening? Thanks
@LukeBarousse Ай бұрын
data analytics is automatically included, you no longer have to select it as I did in the video
@diversifai-- 4 ай бұрын
im trying to buy your course, but it's paused. When will it be available
@LukeBarousse 4 ай бұрын
more details come out next week, going to make it publicly avaiable on youtube
@miZnIce01 3 ай бұрын
Does this tutorial suit for 3.5 model as well?
@LukeBarousse 3 ай бұрын
Unfortunately not
@ebandaezembe7508 2 ай бұрын
my dream would be to have chatgpt plus😫❤
@rodrigojimenez8602 5 ай бұрын
Do the course videos have Spanish subtitles?
@LukeBarousse 5 ай бұрын
No so sorry, only English subtitles RN; if there is enough interest I can see about adding some Spanish subtitles
@felipehenao100 5 ай бұрын
@@LukeBarousse te agradeceriamos mucho que agregaras subtitulos en español, precisamente estaba revisando si comprarlo pero nose como podria traducirlos por mi cuenta
@zabashhd459 5 ай бұрын
hi Luke there is this eror regarding the cap of chatgpt You've reached the current usage cap for GPT-4, please try again
@LukeBarousse 5 ай бұрын
Yeah, ChatGPT limits the number of chats you can do at a time: 40 messages every 3 hours Based on the demand of chatGPT, it looks like this is a way to ensure their servers don't crash; I don't find this too limiting in my analysis; you just have to make sure that you are very intentional about your chats and don't waste them
@abdellahbourachdi7100 5 ай бұрын
Where are the video chapters Luke ?
@LukeBarousse 5 ай бұрын
I have more details on the video chapters here: lukeb.co/chatgpt But here is a general overview 1: Intro to ChatGPT (first portion of this video) 2: Intro to ADA (second portion of this video) 3: Basic Analysis 4: Advanced ChatGPT 5: Intro to Plugins 6: Data Collection 7: Data Cleaning 8: Capstone Setup 9: Capstone Project
@landonman3959 5 ай бұрын
How is Jones oklahoma with a population of around 2,000 on there?
@LukeBarousse 5 ай бұрын
It has to do with where the jobs are being scraped from... lots of jobs being scraped from the mid-west
@landonman3959 5 ай бұрын
Should probably manually verify that one @@LukeBarousse
@wayne_vt 5 ай бұрын
Finally had the waitlist removed, and upgraded. Now Advanced Data Analysis isn't available?! Anyone else have a similar problem?
@LukeBarousse 5 ай бұрын
You don't need to turn on Advanced Data Analysis; it's included in the most advanced GPT-4 model
@haris4748 5 ай бұрын
If not replace data analyst it will definitely make some data analyst jobless with more productivity and there will be fewer jobs in future. Isnt it correct?
@LukeBarousse 5 ай бұрын
With how this technology is going i'm seeing it becoming more of an AI assistant vice replacer. There are a few studies i've shared on Twitter and LInkedin showing that AI is not destroying jobs but instead helping jobs grow; so i'm optimistic
@haris4748 5 ай бұрын
@@LukeBaroussethank you! And keep making these awesome content 🎉
@rudyvaldez 5 ай бұрын
Have you tried bing chat?
@LukeBarousse 5 ай бұрын
Yeah, been testing it out as well; seems like a great option for general research for Window users
@davidmiller-td1sl 5 ай бұрын
What about AskJeeves?
@SEOHARD 5 ай бұрын
First, I'm not a hater or something. I just tried doing some analysis with Chat GPT and it keeps crashing, providing unreliable numbers, and ignoring some of the instructions. I just don't understand how a person who is doing data analysis for a living can recommend this. It's unreliable, it makes mistakes. Why should others use it? Isn't it better to learn several excel formulas instead?
@LukeBarousse 5 ай бұрын
I'm not sure how you're prompting it, but I feel a lot of the issues you speak of can be fixed with better prompting. Regarding the crashing, I have experienced this. However, the time it saves in streamlining tasks compared to the time i've spent dealing with crashes is FAR lower and is worth the cost. ChatGPT is not perfect, but when used correctly it saves me so much time... so that's why I recommend it
@MW-cs8zd 5 ай бұрын
Sup...
@mohammadrezadadkhah2104 Ай бұрын
Hi I S she course accessible for blind
@mohammadrezadadkhah2104 Ай бұрын
How much is the course price
@sunnyahmed5935 5 ай бұрын
will DA extinct soon ?
@violentfox 5 ай бұрын
Likely so. What we will be calling DA is gonna be something different.
@LukeBarousse 5 ай бұрын
Did the invention of electronic spreadsheets take accountants jobs... No... and I feel the same can be applied to AI... it's a tool to help DA's with their jobs
@gd8205 4 ай бұрын
This is already pretty dated. Especially with the GPT store. This is why I’m not making courses it’s never ending lol
@user-mr5zq5ey9t 3 ай бұрын
Hi Luke thank you for this awesome tutorial. It realy makes me happy! i have a question. I have followed the instructions, but chatgpt reponds it cannot build a model. In stead is responds a method to build a random forrest model with python etc. Has something changed of am i doing something wrong? thank you for a response. Joost (The Netherlands)
Tips Workshop
Рет қаралды 61 МЛН