![vasabi academy](/img/default-banner.jpg)
- Видео 29
- Просмотров 170 060
vasabi academy
Добавлен 22 окт 2013
I create this video tutorial channel for colleagues and friends as a space to nurture continuing professional development beyond session for teachers and public.
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
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
Digital Business Management - MSME 2020
Просмотров 3844 года назад
Digital Business Management - MSME 2020
How to create Small Multiple Graphs in Excel
Просмотров 3405 лет назад
How to create Small Multiple Graphs 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
A report on the interviews we had ,now we need to have second selection
Thank you so much!! I spent hours to get this done by myself 😭
so glad that it helps!
Thanks man ive been struggling with my class you’re super helpful 🙌🙌
Great video. But i am not fully there yet. how do you easily copy this graph and use it for another table?
Copy a graph to another table means you are changing the graph source data. This video might help ruclips.net/video/On_aGran4iw/видео.html
Great video. But i am not fully there yet. how do you easily copy this graph and use it for another table?
Thank you 🙏
it says my data set is too long
Usually I don't give data longer than 1,000 words. if you have ChatGPT plus you can load data file to the chat :)
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?
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?
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!
And so...what happened when you checked this against the software? Was it accurate?
Sometimes, it's really depend on the prompts you gave.
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!
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.
How are we sure that results are trustable..??
We cannot trust, we need to double check every result.
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.
True, we ought to recheck the AI result in case it hallucinated
And what about only analyzing data? does it make mistakes at that point?
@@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.
Good initiative. Keep on doing this as this may help programmers
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.
Totally agree, it's a language model. I treat it as my RA, editor, and secretary most of the time :)
@@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.
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
Hey, could you please explain how you did it?
@@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.
Very interesting. Can you explain in detail how to do it. examples of some prompts.
not bad !!!
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?
I watched other clips that say limit the record to less than 1000 rows. But I wouldn't go that far.
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
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.
Chatbot or no chatbot, a "please" would be nice 😉
??????
I do this since Chatbot apologized for its errors :)
I always say please and thank you with Gpt. I think it appreciates it.
@@jayrodathome Maybe there is a secret "paradise in heaven ranking", you never now.
Didn’t know that ChatGpt are able to analyze data table !
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
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.
@@vasabiacademy Thank you perhaps its possible to give it some key summary points of a larger data set to get an output
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.
@@lantern9817 Thank you!
Ok so that gives us about a year before we become redundant lol 😅😂.
Please pardon my ignorance but can it be used in business analysis for real?
I think it can give us "ideas" or "suggestions." We still need to take the driving seat.
@@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?
@@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"?
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.
amazing, thanks! the secret to call a variable from the function is to declare the function inside the variable. :D
Does it show how to use 2D array?
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.
😁😁😁
thanks bud you do a better job than my teacher
Thanks a lot, your flowgorithm videos are helping me so much! Best regards from Brasil!
Thanks a lot, your flowgorithm videos are helping me so much! Best regards from Brasil!
Horrobilly made did not show how J value was added wastes my 1 hr
@ 11:57 he enters 10 in input box thats how
is such rudeness really necessary??? gross...
Thankyou
Thanks, great..... Miss...!!! From Brazil, Rio.....
Please come to Brazil 🥵😩
🥰🙏🏽
tq
it helped me
really good video ! thank you
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!
tu viens de quelle école?
Thank Sir!
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....