ChatGPT for Data Analytics: Beginner Tutorial

Поділитися
Вставка
  • Опубліковано 22 лис 2024

КОМЕНТАРІ • 116

  • @LukeBarousse
    @LukeBarousse  10 місяців тому +6

    Data Nerds! I've decided to make this full course available on UA-cam 👉ua-cam.com/video/uhyMqbZI6rM/v-deo.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
      @catalinagalan 10 місяців тому

      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?

    • @KikiA-lk6cv
      @KikiA-lk6cv 6 місяців тому

      i should have read this comment first

  • @LukeBarousse
    @LukeBarousse  11 місяців тому +3

    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
      @grabik4402 11 місяців тому

      2 issues with this:
      1. How do you find a friend?
      2. How do you find a friend that has gpt4?

  • @michaelmcmanus2186
    @michaelmcmanus2186 11 місяців тому +3

    Kudos to Luke for continuing the democratization of education!!!!

  • @phineasndhlau7618
    @phineasndhlau7618 10 місяців тому +1

    Excellent teaching style. Swift and fluid. 🙏🏾

  • @Pegasus4213
    @Pegasus4213 4 місяці тому

    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!

  • @seanbill942
    @seanbill942 11 місяців тому +2

    Great video and nice job explaining how ChatGPT data analytics works for us lay people!

  • @tosinwilliams9343
    @tosinwilliams9343 9 місяців тому

    Please do more videos on this ChatGPT for Data Analytics 🙏🙏🙌🙌🙌🙌

  • @hilmanagung
    @hilmanagung 8 місяців тому

    Excellent Video! Thank you so much, I learned a lot in an hour

  • @gregNFL
    @gregNFL 9 місяців тому

    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.

  • @zabashhd459
    @zabashhd459 Рік тому +1

    This Video Is Gold

  • @nicolastarazona4196
    @nicolastarazona4196 Рік тому +5

    What is the purpose of studying tools for Data Science, such as Python, Numpy, Pandas, and Scikit-learn, with chatgpt4?

    • @Flylikea
      @Flylikea Рік тому +7

      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
      @LukeBarousse  Рік тому +10

      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
      @nicolasmcontreras 11 місяців тому

      You simply wouldn't understand the output. Or you will learn by doing it with the chat.

    • @InnocentiusLacrimosa
      @InnocentiusLacrimosa 10 місяців тому

      There have always been and always will be different tiers of data analysts.

    • @alexstrums
      @alexstrums 9 місяців тому +1

      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

  • @dingdingligeding
    @dingdingligeding 7 місяців тому

    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.

  • @realgouravverma
    @realgouravverma 9 місяців тому

    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.

  • @Abhi_Nav
    @Abhi_Nav 10 місяців тому +1

    Such a valuable video! 👏 Looking forward for the full course.. Thanks for doing what you! I learn a lot from you. 🙏💙

  • @kushkhurana2523
    @kushkhurana2523 9 місяців тому

    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
    @milicy 10 місяців тому

    Hi Luke, i see your course is on hold - when will it be available for watching?

  • @bamideledamilare5940
    @bamideledamilare5940 Рік тому +1

    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
      @LukeBarousse  11 місяців тому

      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
      @eduardoactd 11 місяців тому

      @@LukeBarousse I asked for it like 10 days ago and today I already added the sub with my credit card =)

    • @fabiogal1811
      @fabiogal1811 11 місяців тому +1

      I could upgrade today it's awesome

    • @denwo1982
      @denwo1982 11 місяців тому

      Early members should be given shares to OpenAI, new members are so desperate for the paid service now

  • @joostsluijs
    @joostsluijs 9 місяців тому

    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)

  • @keylanoslokj1806
    @keylanoslokj1806 10 місяців тому

    Which extensions have you implemented on chatgpt for Data analytics

  • @nicolasmcontreras
    @nicolasmcontreras 11 місяців тому

    Thanks Luke. I finally watched it. ❤

  • @AladdinAlswaifi
    @AladdinAlswaifi 10 місяців тому

    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
      @LukeBarousse  10 місяців тому +1

      It's no longer located in settings, it's auto included in the most advanced model

  • @The_Creative_1983
    @The_Creative_1983 11 місяців тому

    that amazing. I'm on the waiting list for cheatgpt 4

    • @LukeBarousse
      @LukeBarousse  11 місяців тому +1

      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
      @The_Creative_1983 11 місяців тому

      Thanks. I just got it today.

  • @rajakr2096
    @rajakr2096 10 місяців тому

    Terrific video. Keep it up❤

  • @MuslimFriend23
    @MuslimFriend23 11 місяців тому

    You've come a long way my friend, all the best insh'Allah

    • @LukeBarousse
      @LukeBarousse  11 місяців тому +1

      Thanks my friend!

    • @MuslimFriend23
      @MuslimFriend23 11 місяців тому

      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 👏👏👏

  • @edilmagiraldo9366
    @edilmagiraldo9366 11 місяців тому

    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
      @LukeBarousse  11 місяців тому +2

      Advanced Data Analysis is now included as part of the core model of GPT-4, there is no need to select it

    • @LukeBarousse
      @LukeBarousse  11 місяців тому +1

      7:54

  • @salmanthebestful
    @salmanthebestful Рік тому

    thank you for this Luke!!

  • @rsandilyav
    @rsandilyav 10 місяців тому

    ⁠@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
      @LukeBarousse  10 місяців тому

      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

  • @ayushgoyal9734
    @ayushgoyal9734 2 місяці тому

    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 🤔🤔

  • @a.c.bonneville189
    @a.c.bonneville189 10 місяців тому

    I like this guy

  • @PillsLifestyleReviews
    @PillsLifestyleReviews Рік тому

    Thank You for the Amazing lesson.

  • @xiaojietian3397
    @xiaojietian3397 11 місяців тому

    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
      @LukeBarousse  11 місяців тому +2

      It's now included in the core model of "GPT-4", you no longer need to select it

  • @JeezLeWeeze
    @JeezLeWeeze 11 місяців тому

    How do you deal with floating point imprecision in Python?

  • @h_kvideography3286
    @h_kvideography3286 9 місяців тому

    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
      @LukeBarousse  9 місяців тому

      It's no longer included in the menu, it's auto-included so don't worry about it

    • @h_kvideography3286
      @h_kvideography3286 9 місяців тому

      Thanks a lot
      @@LukeBarousse

  • @abhasmalguri2905
    @abhasmalguri2905 Рік тому

    Great Luke! Was expecting this type of video 😊❤

    • @abhasmalguri2905
      @abhasmalguri2905 Рік тому

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

  • @ilhemdjenane9447
    @ilhemdjenane9447 10 місяців тому

    I just purchased the Chatgpt 4 but when I ask it to analyse something it keeps saying there was an error generating a response.

  • @abdellahbourachdi7100
    @abdellahbourachdi7100 Рік тому +1

    Where are the video chapters Luke ?

    • @LukeBarousse
      @LukeBarousse  Рік тому

      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

  • @miZnIce01
    @miZnIce01 10 місяців тому

    Does this tutorial suit for 3.5 model as well?

  • @micbab-vg2mu
    @micbab-vg2mu 11 місяців тому

    Nice - thank you

  • @derien5433
    @derien5433 9 місяців тому

    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
      @LukeBarousse  9 місяців тому

      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

  • @realdataboy
    @realdataboy 10 місяців тому

    im trying to buy your course, but it's paused. When will it be available

    • @LukeBarousse
      @LukeBarousse  10 місяців тому

      more details come out next week, going to make it publicly avaiable on youtube

  • @GeonQuuin
    @GeonQuuin Рік тому

    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
      @grabik4402 Рік тому +2

      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
      @LukeBarousse  Рік тому +1

      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

  • @tarinitup17
    @tarinitup17 11 місяців тому

    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
      @LukeBarousse  11 місяців тому +1

      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
      @Papiaso 9 місяців тому

      What do they charge for gpt enterprises (approximately)? ​@@LukeBarousse

  • @hong9862
    @hong9862 10 місяців тому

    Do you have any idea why I do not see Advanced Data Analysis under Beta features?

    • @LukeBarousse
      @LukeBarousse  10 місяців тому

      It's no longer there, it's auto enabled

  • @juanlauroaguirre5646
    @juanlauroaguirre5646 10 місяців тому

    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
      @LukeBarousse  10 місяців тому +4

      Hey Juan, i'm currently working to package it up and make it freely accessible on UA-cam, should have it launched in the next couple of weeks!

    • @juanlauroaguirre5646
      @juanlauroaguirre5646 10 місяців тому

      @@LukeBarousse freely available? So it won’t cost 100 bucks? Thanks man you rock !!

  • @zabashhd459
    @zabashhd459 11 місяців тому

    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
      @LukeBarousse  11 місяців тому +1

      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

  • @guillermodevivanco7957
    @guillermodevivanco7957 8 місяців тому

    Hi Luke, I subscribed to ChatGPT 4 but my beta features only include plugins, no data analytics. What could be happening? Thanks

    • @LukeBarousse
      @LukeBarousse  7 місяців тому

      data analytics is automatically included, you no longer have to select it as I did in the video

  • @grabik4402
    @grabik4402 Рік тому

    Nice video, thanks.
    I am unable to upgrade to gpt4 due to the freeze, is there anyone able to share a referral?

  • @rodrigojimenez8602
    @rodrigojimenez8602 11 місяців тому

    Do the course videos have Spanish subtitles?

    • @LukeBarousse
      @LukeBarousse  11 місяців тому +2

      No so sorry, only English subtitles RN; if there is enough interest I can see about adding some Spanish subtitles

    • @felipehenao100
      @felipehenao100 11 місяців тому

      ​@@LukeBarousse te agradeceriamos mucho que agregaras subtitulos en español, precisamente estaba revisando si comprarlo pero nose como podria traducirlos por mi cuenta

  • @wayne_vt
    @wayne_vt 11 місяців тому

    Finally had the waitlist removed, and upgraded. Now Advanced Data Analysis isn't available?! Anyone else have a similar problem?

    • @LukeBarousse
      @LukeBarousse  11 місяців тому +1

      You don't need to turn on Advanced Data Analysis; it's included in the most advanced GPT-4 model

  • @ebandaezembe7508
    @ebandaezembe7508 8 місяців тому

    my dream would be to have chatgpt plus😫❤

  • @landonman3959
    @landonman3959 11 місяців тому

    How is Jones oklahoma with a population of around 2,000 on there?

    • @LukeBarousse
      @LukeBarousse  11 місяців тому

      It has to do with where the jobs are being scraped from... lots of jobs being scraped from the mid-west

    • @landonman3959
      @landonman3959 11 місяців тому

      Should probably manually verify that one
      @@LukeBarousse

  • @SEOHARD
    @SEOHARD 11 місяців тому +2

    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
      @LukeBarousse  11 місяців тому

      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

  • @haris4748
    @haris4748 11 місяців тому

    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
      @LukeBarousse  11 місяців тому +1

      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
      @haris4748 11 місяців тому

      ​​@@LukeBaroussethank you! And keep making these awesome content 🎉

  • @rudyvaldez
    @rudyvaldez Рік тому

    Have you tried bing chat?

    • @LukeBarousse
      @LukeBarousse  Рік тому +1

      Yeah, been testing it out as well; seems like a great option for general research for Window users

    • @davidmiller-td1sl
      @davidmiller-td1sl Рік тому

      What about AskJeeves?

  • @mohammadrezadadkhah2104
    @mohammadrezadadkhah2104 7 місяців тому

    Hi
    I S she course accessible for blind

  • @MW-cs8zd
    @MW-cs8zd Рік тому

    Sup...

  • @sunnyahmed5935
    @sunnyahmed5935 11 місяців тому

    will DA extinct soon ?

    • @violentfox
      @violentfox 11 місяців тому +2

      Likely so. What we will be calling DA is gonna be something different.

    • @LukeBarousse
      @LukeBarousse  11 місяців тому +2

      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
    @gd8205 10 місяців тому

    This is already pretty dated. Especially with the GPT store.
    This is why I’m not making courses it’s never ending lol

  • @joostsluijs
    @joostsluijs 9 місяців тому +1

    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)