Data Nerds! I've decided to make this full course available on TH-cam 👉th-cam.com/video/uhyMqbZI6rM/w-d-xo.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 👌🏼
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
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.
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?
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
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?
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
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.
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
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
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)
i have a doubt regarding the PLUGIN I want to know is there any other Ai or any other Plugin which provide us a service to connect Ai to database., Just like Noteable had a feature like that but it's closed so i want to know any alternative for it 🤔🤔
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)
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.
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.
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.
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
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
@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?
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?
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
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
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
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?
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
@@LukeBarousse te agradeceriamos mucho que agregaras subtitulos en español, precisamente estaba revisando si comprarlo pero nose como podria traducirlos por mi cuenta
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
@@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
Data Nerds! I've decided to make this full course available on TH-cam 👉th-cam.com/video/uhyMqbZI6rM/w-d-xo.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 👌🏼
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?
i should have read this comment first
Excellent Video! Thank you so much, I learned a lot in an hour
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
2 issues with this:
1. How do you find a friend?
2. How do you find a friend that has gpt4?
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.
I like this guy
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.
Advanced Data Analysis is now included as part of the core model of GPT-4, there is no need to select it
7:54
How do you deal with floating point imprecision in Python?
Hi Luke, I subscribed to ChatGPT 4 but my beta features only include plugins, no data analytics. What could be happening? Thanks
data analytics is automatically included, you no longer have to select it as I did in the video
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?
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
Finally had the waitlist removed, and upgraded. Now Advanced Data Analysis isn't available?! Anyone else have a similar problem?
You don't need to turn on Advanced Data Analysis; it's included in the most advanced GPT-4 model
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?
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
@@LukeBaroussethank you! And keep making these awesome content 🎉
Hi
I S she course accessible for blind
How much is the course price
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?
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
What is the purpose of studying tools for Data Science, such as Python, Numpy, Pandas, and Scikit-learn, with chatgpt4?
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.
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
You simply wouldn't understand the output. Or you will learn by doing it with the chat.
There have always been and always will be different tiers of data analysts.
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
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)
i have a doubt regarding the PLUGIN
I want to know is there any other Ai or any other Plugin which provide us a service to connect Ai to database.,
Just like Noteable had a feature like that but it's closed so i want to know any alternative for it 🤔🤔
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)
This is already pretty dated. Especially with the GPT store.
This is why I’m not making courses it’s never ending lol
Kudos to Luke for continuing the democratization of education!!!!
Heck yeah! Thank you!!
Great video and nice job explaining how ChatGPT data analytics works for us lay people!
Glad it was helpful 🙌
my dream would be to have chatgpt plus😫❤
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.
At the speed you travel with words they fly by so fast I don't catch sight of them! If you skip any faster it would be a blur! 🙂 Nice one!
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.
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.
I just purchased the Chatgpt 4 but when I ask it to analyse something it keeps saying there was an error generating a response.
Please do more videos on this ChatGPT for Data Analytics 🙏🙏🙌🙌🙌🙌
Which extensions have you implemented on chatgpt for Data analytics
Excellent teaching style. Swift and fluid. 🙏🏾
Much appreciated!
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.
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
@@LukeBarousse I asked for it like 10 days ago and today I already added the sub with my credit card =)
I could upgrade today it's awesome
Early members should be given shares to OpenAI, new members are so desperate for the paid service now
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?
It's no longer located in settings, it's auto included in the most advanced model
This Video Is Gold
Where are the video chapters Luke ?
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
@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?
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
Nice video, thanks.
I am unable to upgrade to gpt4 due to the freeze, is there anyone able to share a referral?
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?
It's now included in the core model of "GPT-4", you no longer need to select it
hi Luke there is this eror regarding the cap of chatgpt You've reached the current usage cap for GPT-4, please try again
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
Hi Luke, i see your course is on hold - when will it be available for watching?
Hopefully sooon!
im trying to buy your course, but it's paused. When will it be available
more details come out next week, going to make it publicly avaiable on youtube
Do you have any idea why I do not see Advanced Data Analysis under Beta features?
It's no longer there, it's auto enabled
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
It's no longer included in the menu, it's auto-included so don't worry about it
Thanks a lot
@@LukeBarousse
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?
Hey Juan, i'm currently working to package it up and make it freely accessible on TH-cam, should have it launched in the next couple of weeks!
@@LukeBarousse freely available? So it won’t cost 100 bucks? Thanks man you rock !!
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?
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.
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
Terrific video. Keep it up❤
Does this tutorial suit for 3.5 model as well?
Unfortunately not
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?
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
What do they charge for gpt enterprises (approximately)? @@LukeBarousse
Sup...
Thank You for the Amazing lesson.
Nice - thank you
How is Jones oklahoma with a population of around 2,000 on there?
It has to do with where the jobs are being scraped from... lots of jobs being scraped from the mid-west
Should probably manually verify that one
@@LukeBarousse
Thanks Luke. I finally watched it. ❤
Hope you enjoyed it!
You've come a long way my friend, all the best insh'Allah
Thanks my friend!
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 👏👏👏
that amazing. I'm on the waiting list for cheatgpt 4
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!
Thanks. I just got it today.
thank you for this Luke!!
Do the course videos have Spanish subtitles?
No so sorry, only English subtitles RN; if there is enough interest I can see about adding some Spanish subtitles
@@LukeBarousse te agradeceriamos mucho que agregaras subtitulos en español, precisamente estaba revisando si comprarlo pero nose como podria traducirlos por mi cuenta
Have you tried bing chat?
Yeah, been testing it out as well; seems like a great option for general research for Window users
What about AskJeeves?
will DA extinct soon ?
Likely so. What we will be calling DA is gonna be something different.
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
Such a valuable video! 👏 Looking forward for the full course.. Thanks for doing what you! I learn a lot from you. 🙏💙
Great Luke! Was expecting this type of video 😊❤
@@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