vasabi academy
vasabi academy
  • Видео 29
  • Просмотров 170 060
ChatGPT Code Interpreter - Unlock insights with a single line prompt
Can we just drop the data file and let ChatGPT figures things out?
Watch to find out :)
#openai #chatgpt #chatgptexamples #dataanalysis #quantitativetechniques
Просмотров: 85

Видео

Excel AI vs. ChatGPT: Which product delivers the best insights from data?
Просмотров 165Год назад
This video will give you overview of the strengths and weaknesses of Excel Analyze Data and ChatGPT when it comes to delivering insights from your data. So, which one is right for you? Watch the video to find out! #exceltutorial #openai #chatgpt #chatgptexamples #dataanalysis
Qualitative Data Analysis with ChatGPT - Find themes, count keywords and more!
Просмотров 15 тыс.Год назад
Steps to do qualitative data analysis with ChatGPT 1. Prepare data (clean and anonymized data in this case) 2. Give prompts (e.g., context of the data, suggested categories or keywords) 3. Try how much the AI can handle for each chunk (e.g., 30 or 40 rows of text) 4. Once all the chunks are fed, ask for overarching theme and frequencies! #openai #chatgpt #chatgptexamples #dataanalysis #qualitat...
Using ChatGPT to analyze data and write report
Просмотров 96 тыс.Год назад
The clip shows how we can use ChatGPT to analyze data table, explain findings, and eventually write a report. #openai #chatgpt #chatgptexamples #dataanalysis
How to create a Pictogram in Excel
Просмотров 1,1 тыс.Год назад
Based on Effective data visualization: The right chart for the right data by Stephanie Evergreen (ISBN: 978-1544350882)
How to create a Waffle Chart in Excel
Просмотров 318Год назад
Based on Effective data visualization: The right chart for the right data by Stephanie Evergreen (ISBN: 978-1544350882)
How to create a Dot Plot in Excel
Просмотров 299Год назад
Based on Effective data visualization: The right chart for the right data by Stephanie Evergreen (ISBN: 978-1544350882)
How to create indicator dots in Excel
Просмотров 718Год назад
Based on Effective data visualization: The right chart for the right data by Stephanie Evergreen (ISBN: 978-1544350882)
How to create a horizontal bullet graph in Excel
Просмотров 1,3 тыс.Год назад
Based on a blog post "Multiple Horizontal Bullet" peltiertech.com/bullet-charts-in-excel/
How to create overlapping bars in Excel
Просмотров 380Год назад
Based on Effective data visualization: The right chart for the right data by Stephanie Evergreen (ISBN: 978-1544350882)
How to create benchmarks in Excel
Просмотров 3,3 тыс.Год назад
Based on Effective data visualization: The right chart for the right data by Stephanie Evergreen (ISBN: 978-1544350882)
How to create a stacked bar in Excel
Просмотров 408Год назад
Based on Effective data visualization: The right chart for the right data by Stephanie Evergreen (ISBN: 978-1544350882)
Flowgorithm function
Просмотров 2,9 тыс.3 года назад
Flowgorithm function - discussing the benefits of function, - difference between local and global (public) variable scopes
Flowgorithm arrays
Просмотров 11 тыс.3 года назад
Flowgorithm arrays - discussing the benefits of arrays in programming
Flowgorithm loops
Просмотров 12 тыс.3 года назад
Flowgorithm loops - While loop vs for loop
Digital Business Management - MSME 2020
Просмотров 3844 года назад
Digital Business Management - MSME 2020
How to use h5p interactive video
Просмотров 974 года назад
How to use h5p interactive video
MIS3131/BIS3315 Greeting
Просмотров 1294 года назад
MIS3131/BIS3315 Greeting
Flowgorithm basics
Просмотров 19 тыс.4 года назад
Flowgorithm basics
How to create a bump chart in Excel
Просмотров 7015 лет назад
How to create a bump chart in Excel
How to create Small Multiple Graphs in Excel
Просмотров 3405 лет назад
How to create Small Multiple Graphs in Excel
How to create a Slopegraph in Excel
Просмотров 5755 лет назад
How to create a Slopegraph in Excel
The design of BIS 3315 (MIS3131) Programming and Algorithms
Просмотров 1878 лет назад
The design of BIS 3315 (MIS3131) Programming and Algorithms
The design of BIS 1141 Business Software Application
Просмотров 988 лет назад
The design of BIS 1141 Business Software Application
Interview with the Programmer - Kaptan Teotrakool
Просмотров 53710 лет назад
Interview with the Programmer - Kaptan Teotrakool
Blended Learning Initiative Seminar Series #1: Current state of Blended Learning at AU
Просмотров 3410 лет назад
Blended Learning Initiative Seminar Series #1: Current state of Blended Learning at AU
Blended Learning Initiative Seminar Series #1: Current state of Blended Learning at AU
Просмотров 6810 лет назад
Blended Learning Initiative Seminar Series #1: Current state of Blended Learning at AU
Installing and Using Social Network Analysis [SNAPP] in Moodle [Thai]
Просмотров 77410 лет назад
Installing and Using Social Network Analysis [SNAPP] in Moodle [Thai]
Interview with the Programmer - Kittipat Kampa
Просмотров 1,6 тыс.10 лет назад
Interview with the Programmer - Kittipat Kampa

Комментарии

  • @lumbanimithi2186
    @lumbanimithi2186 4 месяца назад

    A report on the interviews we had ,now we need to have second selection

  • @DragonBlueSpirit
    @DragonBlueSpirit 6 месяцев назад

    Thank you so much!! I spent hours to get this done by myself 😭

  • @jonathanokey85
    @jonathanokey85 6 месяцев назад

    Thanks man ive been struggling with my class you’re super helpful 🙌🙌

  • @StevenKoster-p6t
    @StevenKoster-p6t 7 месяцев назад

    Great video. But i am not fully there yet. how do you easily copy this graph and use it for another table?

    • @vasabiacademy
      @vasabiacademy 7 месяцев назад

      Copy a graph to another table means you are changing the graph source data. This video might help ruclips.net/video/On_aGran4iw/видео.html

  • @StevenKoster-p6t
    @StevenKoster-p6t 7 месяцев назад

    Great video. But i am not fully there yet. how do you easily copy this graph and use it for another table?

  • @kidd1941
    @kidd1941 8 месяцев назад

    Thank you 🙏

  • @mehaknanda8551
    @mehaknanda8551 Год назад

    it says my data set is too long

    • @vasabiacademy
      @vasabiacademy Год назад

      Usually I don't give data longer than 1,000 words. if you have ChatGPT plus you can load data file to the chat :)

  • @cond.oriano4945
    @cond.oriano4945 Год назад

    I tried to find outliers in a data set but doesn't work for chatgpt because it has too many rows, instead I asked chatgpt to find outliers in a column in excel and it worked, how can you use chatgpt to write presentations for you?

  • @Smarttouch-kg3lt
    @Smarttouch-kg3lt Год назад

    Can you tell me if the data provided by ChatGPT at the 6:00 minute mark of the video are correct? Did they match the text you sent to him?

    • @vasabiacademy
      @vasabiacademy Год назад

      They are close to what I look for. But I would never trust the results though. It's better to recheck with other tools, or at least ask the Bot to list items that he put in each category. Hope this help!

  • @pookieburntear
    @pookieburntear Год назад

    And so...what happened when you checked this against the software? Was it accurate?

    • @vasabiacademy
      @vasabiacademy Год назад

      Sometimes, it's really depend on the prompts you gave.

  • @TheBasicStuff
    @TheBasicStuff Год назад

    So just to check, how does the thematic analytical outputs from the 6:00 mark by ChatGPT compare to the output of the software that you use for thematic analysis? Curious to know!

    • @vasabiacademy
      @vasabiacademy Год назад

      I haven't had the opportunity to use robust qualitative software for analysis (familiar with RQDA from R). That said, if I were to publish, I would ensure to validate the results using reliable qualitative software. Been using ChatGPT for other kinds of analysis and many times it's gone completely off track.

  • @licalgado1
    @licalgado1 Год назад

    How are we sure that results are trustable..??

    • @vasabiacademy
      @vasabiacademy Год назад

      We cannot trust, we need to double check every result.

  • @dfsed1057
    @dfsed1057 Год назад

    Been doing this type of analysis for a while. A couple things to note: 1. Because of the limits of gpt3, after about 4000 tokens are used (counting your input and output from chatgpt), it will forget your table data and start making up stuff so be careful 2. It is really really bad at math. If you wanted to do counts, sums, or any form of optimization, it will likely make up numbers. I tried to do analysis on multiple columns as long as the sum was less than a given number and it just didnt work regardless of my efforts. It is good for overall summaries though like this.

    • @vasabiacademy
      @vasabiacademy Год назад

      True, we ought to recheck the AI result in case it hallucinated

    • @skrozneobican
      @skrozneobican Год назад

      And what about only analyzing data? does it make mistakes at that point?

    • @vasabiacademy
      @vasabiacademy Год назад

      ​@@skrozneobican In my experience, it does. Sometimes as simple as getting descriptive stats wrong (e.g., sum, average). I guess it only help with gererating ideas and broad observation for now.

  • @dataanalyticssolutioninban4066

    Good initiative. Keep on doing this as this may help programmers

  • @tobiasurban8065
    @tobiasurban8065 Год назад

    Thanks for this input. Just speaking for myself. 1) I would never give ChatGPT real business data. 2) It might be the case that it gives you a new idea, but professionally it seems to be not frugal enough and wasting too much time for prompting. Just my opinion, investing the same time learning the stats and techniques instead of tweaking prompts for several rounds pays much more off long-term… also keep in mind, tranformers are language models with no algebraic logic. Don‘t trust any calculation made by a NLP.

    • @vasabiacademy
      @vasabiacademy Год назад

      Totally agree, it's a language model. I treat it as my RA, editor, and secretary most of the time :)

    • @tobiasurban8065
      @tobiasurban8065 Год назад

      @@vasabiacademy Me too :) Good point again, it depends on whether I can check the quality and prove the response myself with my skill set. If so, then very helpful as an assistant. But if I can't judge the response myself, then completely useless.

  • @reanalytics1863
    @reanalytics1863 Год назад

    I used it for qualitative analysis of interviews, i was blown away by what it did. I did not even know how to improve it because what i would have done would only have been 10% of what the chatbot gave me. The key is giving it the right prompt

    • @SusHerref
      @SusHerref Год назад

      Hey, could you please explain how you did it?

    • @vasabiacademy
      @vasabiacademy Год назад

      @@SusHerref I would (1) give guidelines such as themes or keywords to look for (2) put chunks of interview transcripts to the bot and let see if it could find emerging theme.

    • @oneplus1090
      @oneplus1090 Год назад

      Very interesting. Can you explain in detail how to do it. examples of some prompts.

  • @SM-ce1uy
    @SM-ce1uy Год назад

    not bad !!!

  • @kkleber
    @kkleber Год назад

    I really wanted to find a way to "cheat" and make the chat analyze an entire table with more than 4000 tokens ): Do you know any way?

    • @vasabiacademy
      @vasabiacademy Год назад

      I watched other clips that say limit the record to less than 1000 rows. But I wouldn't go that far.

  • @infantepedro1
    @infantepedro1 Год назад

    Chat gpt is only useful for experts software developers the rest of the people is like Ctrl C and Ctrl V not a big deal. I'd rather thinking for myself

    • @dfsed1057
      @dfsed1057 Год назад

      Its ok to use tools to help you make decisions. Imagine what life would be like if we didnt have exel to begin with? You can certainly do the math by hand but excel speeds it up. chatgpt can also be useful to make some more efficient deicisions - although you still have to decide if your output is accurate. I have a separate comment about that coming up.

  • @ronenTheBarbarian
    @ronenTheBarbarian Год назад

    Chatbot or no chatbot, a "please" would be nice 😉

    • @StAnLiXoNfIrE
      @StAnLiXoNfIrE Год назад

      ??????

    • @AndreasDelleske
      @AndreasDelleske Год назад

      I do this since Chatbot apologized for its errors :)

    • @jayrodathome
      @jayrodathome Год назад

      I always say please and thank you with Gpt. I think it appreciates it.

    • @AndreasDelleske
      @AndreasDelleske Год назад

      @@jayrodathome Maybe there is a secret "paradise in heaven ranking", you never now.

  • @panupong9278
    @panupong9278 Год назад

    Didn’t know that ChatGpt are able to analyze data table !

  • @AlexHitchon
    @AlexHitchon Год назад

    I have been Interested in using GPT to automate reporting & analysis of data sets. Do you know if using your method how much data can we give it in a prompt? like what if we had a report with 1000 rows or 10,000 or more

    • @vasabiacademy
      @vasabiacademy Год назад

      It's a text AI so it won't be able handle that many rows of data (currently). I tried only 10+ rows just to get some ideas. You still need to go to actual tools (e.g., Excel, Python, R) to actually analyze the data.

    • @AlexHitchon
      @AlexHitchon Год назад

      @@vasabiacademy Thank you perhaps its possible to give it some key summary points of a larger data set to get an output

    • @lantern9817
      @lantern9817 Год назад

      To be more specific, the AI can only process 4,000 tokens at a time (A token is approximately 4 letters) Meaning it can process quite a lot, but 1,000+ rows / columns would be unrealistic as of now.

    • @vasabiacademy
      @vasabiacademy Год назад

      @@lantern9817 Thank you!

    • @richardtvtv
      @richardtvtv Год назад

      Ok so that gives us about a year before we become redundant lol 😅😂.

  • @bryte_duffs
    @bryte_duffs Год назад

    Please pardon my ignorance but can it be used in business analysis for real?

    • @vasabiacademy
      @vasabiacademy Год назад

      I think it can give us "ideas" or "suggestions." We still need to take the driving seat.

    • @jaxfang
      @jaxfang Год назад

      @@vasabiacademyI’m both fascinated and anxious about the future of business/data analytics as it relates to AI. AI will get better and better. Do you think it will damage the demand of data analytic jobs in the future, such as salary?

    • @vasabiacademy
      @vasabiacademy Год назад

      @@jaxfang I guess we have to keep up and try to work with latest AI to keep our job 😁 Have you cheked out what Excel AI could do to a data table using the feature "Analyze Data"?

    • @jayrodathome
      @jayrodathome Год назад

      It can definitely give idea. Take a small subset of data ask it for some insights. If it finds something you didn’t think of that’s useful you can then use that idea to do some real bi. It’s an amazing program. It helps me so much with writing case statements for use in Google data studio. It’s not always correct but I’ve leaned so much more about data analysis by using Gpt.

  • @GABRIEL1030
    @GABRIEL1030 Год назад

    amazing, thanks! the secret to call a variable from the function is to declare the function inside the variable. :D

  • @Ks_jewelry
    @Ks_jewelry Год назад

    Does it show how to use 2D array?

    • @vasabiacademy
      @vasabiacademy Год назад

      Flowgorithm is not the best app for handling array, IMHO. This clip shows only one array with a few elements. Usually in class while I teach, when it gets to 2D, I move to Python or other real programming language.

  • @jojahaha1
    @jojahaha1 Год назад

    😁😁😁

  • @69Clay420
    @69Clay420 2 года назад

    thanks bud you do a better job than my teacher

  • @乐文玉
    @乐文玉 2 года назад

    Thanks a lot, your flowgorithm videos are helping me so much! Best regards from Brasil!

  • @乐文玉
    @乐文玉 2 года назад

    Thanks a lot, your flowgorithm videos are helping me so much! Best regards from Brasil!

  • @marinascopfzfa21on53
    @marinascopfzfa21on53 3 года назад

    Horrobilly made did not show how J value was added wastes my 1 hr

    • @Ms-cx3fd
      @Ms-cx3fd 2 года назад

      @ 11:57 he enters 10 in input box thats how

    • @乐文玉
      @乐文玉 Год назад

      is such rudeness really necessary??? gross...

  • @gingerpukh7309
    @gingerpukh7309 3 года назад

    Thankyou

  • @mauriciotoscano3803
    @mauriciotoscano3803 3 года назад

    Thanks, great..... Miss...!!! From Brazil, Rio.....

  • @MrKesse
    @MrKesse 3 года назад

    🥰🙏🏽

  • @hrithikgamidi840
    @hrithikgamidi840 3 года назад

    tq

  • @amiteshgudipati5723
    @amiteshgudipati5723 3 года назад

    it helped me

  • @timmcclane2068
    @timmcclane2068 3 года назад

    really good video ! thank you

  • @niremasit
    @niremasit 3 года назад

    Great video! Your mic is a bit bad and it's hard to clearly understand what you're saying sometimes (I'm french so its harder xd), but it was really great! Thank!

  • @ayethu7188
    @ayethu7188 3 года назад

    Thank Sir!

  • @adeleyeidowu6591
    @adeleyeidowu6591 9 лет назад

    I have also problem with SNAPP, it does not work withMoodle version 2.5. I tried to use Safari, Firefox (I adjusted setting before) but it appaers a window that says there are security blocks related to Java. Snapp 1.5 works on an old operating system, but it does not show the graph. I am waiting for your help....