I'm a teacher learning data analysis/data scientist and one thing I found working with ChatGPT that reminds me of teaching is that with a class of students, you can't just give instructions to a class activity and then sit back and wait for them to finish. You have to make sure everyone understood but observing their work/progress. And that's a lot like ChatGPT, you can't just ask it to do something and then blindly assume what it gives you is correct. You still need to check what it produces to make sure the two of you are on the same page.

Really great run down and video. Interesting to see different ways you used this tool, thanks Luke!

Love this format! Great video my friend 😊

Very thorough video as always! Also the thing about why it gives different values compared to what you see in the pdf itself, from what i read about how generative ai and tools like chatgpt work is they try to *guess* what the true response *should* be, that’s why in this context they’re not very good at working with numbers. For example if you give it a simple multiplication of two numbers it gives something that *looks* right even though it isn’t most of the time.

I thougt about this just yesterday!! And today you post a video. You're like a guru to me. I love your videos and try to insert this in my life as a student.

I think you are the first to explain in detail what these plug-in stuffs are about with Chatgpt. I've been using Chatgpt for a time now and it's been so great. Thanks for more clarity

My take away is that, when the analysis that you want to perform is complex, it takes way more time to come up with the right prompt and test the reliability of the results, than to write simple python code that visualizes everything reliably. Sometimes its easier to code than doing trial and error with prompts :) . But chatGPT seems to be doing great at generating quick results from a lot of unstructured sources when you need quick insights.

Thank you Luke. A great master class on how to derive insights. You really are an inspiration to all the data analysts "in the making" of the World.

I am by any metric new to data science and ChatGPT has been invaluable, particularly in my learning of SQL, Python, and Google Cloud and coding.

You're the man Luke! Great video!

Some very interesting analysis and conclusions, appreciate the video, thanks.

Luke, amazing insights, thanks for the video!

Does connecting the excel to chatgpt does that make your data less secure? Or does it expose the data / share it in anyway?

Plugins look pretty awesome to try! Privacy however has been of utmost concern with financial and healthcare companies even if ChatGPT and plugins produce the best analytics results. You simply cannot do any internal data analysis until legal and engineering have signed off or until you build an in-house pipeline that does not communicate externally, and all of that requires resources. Code generation seems like the best use case as that is largely input agnostic and does not reveal any confidential data.

You make my life easier, thanks brother ❤️

Hi! How do you connect the data resourse with chatGPT?

You are teaching me a lot thanku so much sir even I am using chatgpt for data analysis

As a data scientist/ semiconductor researcher, I am very excited about this sort of “automation”. GPT4 is like a calculator on steroids, I can get my work done faster and better. And no it’s not always right but that’s where my knowledge as an SME comes into play and eventually AI will get better so it doesn’t matter too much. Secondly this stuff lets me spend way more time focusing on creative thought problems and less on brute forced analysis. And that freedom of time is invaluable because that’s where the leaps in tech come from, people thinking up cool stuff and then making it. AI helps give me more time than I’ve ever had before and I can use that time to advance my field.

I totally relate to the moment when you got some graphs out and think "Hm.. I don't like this!" 🤣Love this video and the analyses! 💖 The Noteable plugin seems pretty solid! We're definitely facing a big time as data professionals RN

You have some mad editing skills

I really like how you choose your application as data analysts, thanks for data set although it's not conclusive somehow it give me a picture of what's its gonna be a year from now. I'm really worried about how Ai will affect this job in the future and it gives me somehow a better perspective.

Love the topic & Content! Keep sharing the good work (pls no ads! take sponsors instead), you can cross 1M by end of this year

Great video Luke!

What about data security of connecting your database to this thing? Is it safe to connect work or even HIPPA data to this?

Hello Luke, what is your opinion on using AI in Data science jobs from business perspective and most analysis has to be done based on historical data of customers or any companies data then there is a chance that data we are feeding to AI can be risky. While using chatgpt, what are do's and don'ts especially people working in companies.

As long as AI tools are not implemented in companies, these will not require employees to have that skill. It all boils down to privacy issues, as you mentioned. That will take some time. If I were to guess, that's a frame of 1-2 years, depending on the law, which is being established right now (in Europe at least). edit: that applies to big companies, smaller ones might get into that earlier.

*_"If it ain't broke don't broke, don't fix it"_* That's the mentality of the companies I worked for so it's not surprising that the survey showed few companies requiring AI related knowledge.

Oh I've been tempted

It makes sense that the data analyst would like using chat GPT as a tool, but people in the field would be apprehensive about it's effects on the field. Quite simply it's a tool that increases the productivity of individuals, so the individuals using the tool will find their job easier, but at the same time it increases competition within the field because as each person becomes more productive the field becomes more competitive and there will be fewer jobs or maybe even more demands on the individuals. If you were the only person who used chat GPT and your managers did not know about it, yeah chat GPT would be a great tool. Just like if you were in a bar fight and you were the only person that had a gun, you would be at a distinct advantage. But if you're in a bar fight and suddenly everybody has guns well then it turns from a bar fight into a massacre

Here is my take as an accountant. Ai tools will hit the tech department first and then slowly bleed into other departments with add ons to their current software tools. For example, no accountant I know will use this but include it as a free addon to their current erp and it will be used. It will take time but as these tools will eventually find their way into everything. Will it take your job, probably no. Will it change the way you do your job probably yes.

Elite clothing choice at 1:18. Also loved the new green screen Luke in my Chat GPT window. How can I get that feature?

Can you make a video about doing a analyst project with AI help and without. I am really curious what the difference will be with your skill set

I hit that like button because I enjoy watching this data nerds videos ❤

There's a reason I went hard at the ML / AI development and NLP route. And this is exactly why.

Thanks for your video Luke. I use chat GPT a lot, but only until certain level. Because the AI responds you with extreme confidence and sometimes the responses are wrong, because it skips part of the logic or the data. It is great for a preliminar view or to accelerate insights, but in a serious job it has to be double checked. Another thing, that you even mention in your video, is the high concern about data privacy. If I may ask you something. There are a lot of companies asking for deep knowledge in ETL processes and Data Warehousing. I have seen many offers asking for snowflake, AWS, BigQuery, Spark, knowledges of Data Lakes, etc. I completed many of the courses that you've recommended for the basic tools (SQL, Tableau, Excel, the Data Analytics from Google) and they were all very good. That's why I'd like to aks you if you have any recommendation for me to get to the next level of the ETL process. Thank and all the best.

This is an excellent video. Cudos!

one thing that is needed badly but missing is the ability to switch between models within same chat session!

Awesome video, Luke! With this whole obscurity around the future of jobs, do you think studying towards becoming a data engineer will be better than being a data analyst

How do you make a video about Data Analysis? Random KZfaq Data Analysts: I just talk about it. Luke: I use my Data Analyst skills to make the video.

Thanks for posting Luke. Hopefully we are not screwed

Hello luke as a non-technical background how we learn data science step by step process???

cool video thank you

🎯 Key Takeaways for quick navigation: 00:00 👩‍💼 Chat GPT has been helping the speaker save time in data analysis by providing quick data insights and visualizations without coding. 02:04 📚 Chat GPT, running on OpenAI's GPT-4 model, is a powerful AI chatbot for data analysis, but advanced features require the pro version with access to plugins. 05:01 🔍 Chat GPT's limitations include being trained only up to September 2021, but plugins like the Bing plugin help access recent information for analysis. 07:33 👍 Around 77% of data professionals have a favorable opinion towards using AI tools in their job workflows. 10:18 💼 Less than 2% of job postings for data science roles request AI-related skills in their job descriptions, raising questions about the gap between individual interest and company implementation. Made with HARPA AIha

Such an awesome video, I am just getting into data analytics as a career and am worried if Im wasting my time as these AI tools may well do the task 10x better in a millisecond of the time but it seems that's not about to happen soon. In your video between seconds 7 and 13 you linked a spreadsheet to chatpgpt. It went by in a flash, how do you actually step by step link them?

This is cool as an analyst I think itll be a requirement to know how to use these tools

Can you make a video on how to get international remote job as a data analyst/scientist

Hi Luke 👋 great content! I am a data scientist who wants to start a youtube channel too. I am just wondering that are you editing and organizing your videos or somebody else is doing it for you?

With this fast in ai development . all repetitive work using computers can be automated within 3 years

great content!

Can you tell us how to use these plugins to make these analyses and visualizations directly in ChatGPT through plain text prompts? This would be the push I needed to move from the free to paid ChatGPT Plus account.

Exceptional analysis Luke. 👏🏻👏🏻 I am from a non tech background and worked in the customer service industry for 4 years and finally entering the world of data science. I am doing a course where they help you to upskill yourself even if you're not from a tech background. I am very positive about AI and data science going hand in hand. I did a real world analysis of the students in my batch (we have a mixed batch, consists of people already working in the data field and people who are freshers in data), I found that the freshers are more inclined towards using AI tools to perform day to day tasks and even learning new concepts. The people who are already into data, have heard about AI tools but the new people entering into data are actually using AI tools to get their work done. Even for me, I use chatgpt to debug any python code for me and to find alternate ways to solve a problem as it reduces dependency on others for easy problems. I have noticed a bias in the freshers, that is, they believe if they aren't good with AI tools, they will have a hard time finding a job in data industry. Would love to know your thoughts on this. 😃

I was wondering if someone could help me plan out a “Roadmap to first Data Analytics Job”. I’ve seen so many different videos, each of them recommending different paths. Does someone have a preferred “path” to take for someone starting with little to no data experience?

🎯 Key Takeaways for quick navigation: 00:00 📊 *Using ChatGPT for Data Analysis* - Demonstrates using ChatGPT for data analysis tasks, significantly reducing time compared to manual methods. - Utilizes ChatGPT to connect to a spreadsheet, analyze job postings, and generate visualizations like bar graphs and salary calculations. 01:23 🤖 *Understanding AI's Impact on Data Jobs* - Explores the impact of AI on both individuals and businesses within the realm of data jobs. - Outlines a two-step approach involving data research and analysis using ChatGPT to investigate sentiments and effects of AI on data science roles. 02:31 💼 *Exploring ChatGPT Capabilities* - Provides insights into ChatGPT, an AI model by OpenAI, highlighting its effectiveness in data analysis. - Discusses the benefits of the pro version, including access to plugins for enhanced functionality. 04:05 🔍 *Searching for Information on AI Impact* - Discusses limitations of ChatGPT in accessing real-time data and the use of plugins like Bing for internet searches. - Utilizes ChatGPT to analyze PDF documents and surveys, extracting insights about AI's impact on data-related tasks. 05:55 📊 *Analyzing Developer Sentiment Towards AI* - Examines survey results from developers regarding their sentiment towards AI in the workplace. - Utilizes ChatGPT to summarize and analyze survey findings, revealing positive sentiments among data professionals towards AI technology. 08:01 💼 *Assessing Business Perspectives on AI* - Explores how businesses perceive AI's impact on economic output and workforce dynamics. - Discusses potential challenges such as privacy concerns while emphasizing the benefits of AI adoption for companies. 09:10 📊 *Analyzing Job Postings for AI Skills* - Utilizes ChatGPT and plugins for data analysis, focusing on job postings to understand the demand for AI skills. - Faces challenges such as dataset size limitations and sampling issues but generates insights into the prevalence of AI-related skills in job descriptions. 11:45 🔍 *Exploring AI Tools in Job Descriptions* - Investigates the inclusion of AI-related tools in job descriptions, revealing low percentages of job postings requiring AI skills. - Analyzes salary differentials among job titles, highlighting discrepancies in compensation for roles requiring AI expertise. 13:09 💡 *Concluding Remarks on AI Implementation* - Summarizes findings indicating a disparity between individual interest in AI and its adoption in job postings. - Calls for further exploration into the reasons behind this disconnect and suggests future research directions. Made with HARPA AI

How accurate do you think ChatGPT's analyses are? Do you compare your results with theirs to estimate a percentage of error?

Hi Luke, as per you analysis and with the rise in AI tools like these and plugins such as the code interpreter, do you still think it is worth becoming a data analyst? 🤓🤔

Do you have any concerns about sharing confidential data with chatgpt, since you are using it for work?

How graphs appeared on chatgpt?

can i become data analyst by using phone or even learn by mobile

The Notable API plug in to Chat GPT 4 + gives more .Furthermore, Chat GPT clearly states that it is experimental and is a work in progress, constantly learning. Nit picking right now is foolhardy . It will only get exponentially better . Hype now but it’s here and won’t go away. Privacy around data sources might be a stumbling block but you just know businesses will overcome these because of cost and speed benefits.

What do you think about the Code Interpreter in ChatGPT (Able to generate charts, maps, data viz, clean datasets)? There're tweets and news explaining that "anyone can be a data analyst now" or "anyone can be hired a data analyst for only $20/month". I've been studying for 3 months and increasingly afraid that in the future data analysts are not needed, am I too late to become a data analyst?

I am feeling detracted for using chatgpt for work because I might be using private data. How do you guys deal with this?

Garmin Fenix 7X?

I love the idea of a green screen special this moment 3:47 made me laugh 😅

1:04 1 minute, that's now but next year it could be 1 second

Pretty cool!

11:21 Like a parent saying no xbox till after you clean your room xD

How do you make it analyse Links ? :D

Will ChatGPT ever have internet access and be kept up to date?

What plugin are you using to get ChatGPT to look at data?

I am a data analyst and I found out that before chat gpt I was Klark Kent. Now I am Superman 🤞💪. It is a great boost to my job.

Code interpreter is available now. And I've seen some amazing results. Can you do a video to cover that? Tks.

I’ve been searching and searching… what plug-in allows you to reference data from a google sheet?

Hey Luke, do you use big query?

Very interesting, I think that the economy situation we are living in has to do with the companies response towards AI. Maybe this will dramatically chague in the near future.

ChatGpt can replace Data analytics job ???

It's too soon for this analysis ... companies are 99% managed by people who don't know what they don't know about AI potential - of course the geeky roles are more excited than the people who decide wether AI is desirable / impactful for the corporate world, FOR NOW. If you watched the video and reading this - don't interpret Luke's video as a "don't care too much about AI... maybe even disregard it" - I would probably recommend the opposite regardless of every (kinda expected giving the timing of it) insight that resulted from this. In other words - I'm not a programmer, but I been in market intelligence and strategic planning in a top #1 company of an X big LATAM country; and I'll be using this channel A LOT to learn about becoming an average data scientist with AI kickers everywhere I can. Thanks for existing Luke!!!

Which plug-in is he using for searching the best up to date information on the internet?

I think A.I. should should be used just as another tool for data science and analytics. It should just make things easier.

So the biggest question of all, will it make data analysts less and less in demand in the future?

Hi Luke! Your chat GPT is plus?

What is the installed plugin?

do you think AI will replace data analysts? and when i say replace, I mean if a big percentage of data analysts will be replaced and lose their jobs

Is the sentiment still optimistic after code interpreter release

How did he use a link to connect chat gpt a google spreadsheet I am using GPT4 and it will not do that?

Companies are offering less wage for job with AI tools requirements because they think it will be less difficult.

AI creators are big tech companies like Microsoft and Google. But AI users will be small and medium tech industries. So many companies will avoid using AI tools for data privacy issues. As people who have all the data of the world will be more profitable then the one who is going to use it and by unknowingly sharing the critical information with the big tech company, could be a costly business decision or hamper the growth of a company.

Code interpreter: hold my programming

The question to Bard at 4:38, if you use ‘generative AI’ instead of AI, then it works. After all, data scientists are already working with AI.

hi can u help me in my project ?

the hallucinations are such a bummer. hard to have confidence when it routinely makes stuff up. qc nightmare. i know it will get better, but for business use cases it's still pretty sketch at the moment. very much swim at your own risk.

Nice green screen work 👌

“How I use chat GPT as a Data Analyst” or “How I got fired for feeding company’s data to public domain”.

Small computer? It looks pretty hefty to me!

I work for a relatively big company. 6000 employees 4 biljoen revenue. My company is very conservative adapting new technologies. I’m sure the company I work for isn’t unique in that sense. Will they adapt in the future….probably they will. But that will only move the field for data analytics further in the organization. There are so many use cases that it will take a very long time implement all of those. So should you be worried…nah….should you ignore it?…also definitely not.

Companies not interested or HR drones not interested?

how do i connect the data wtf

Still waiting for that Chat GPT to be able to apply sunblock

I think thats all good. Just means analysts can be way more efficient using ai, while businesses dont even know theyre using it

The thing still needs a lot of tlc and handholding. If you don’t know the subject matter, it’s close to impossible to get anything useful out of it beyond the most basic. This is as bad as it’s gonna get though.

Conclusion on hiring did not age well. ML and Gen AI skills hiring is defining the tech economy in 2024 and probably through 2027, at least, though of course there will be biggish layoffs, as well. Incredible workflows though, thank you!