Will AI Replace Data Analysts? 

Thanks for watching! You can try Quadratic for FREE 👉🏼 QuadraticHQ.com Finally spreadsheets with superpowers. It’s in beta so be patient. Enjoy!

I Actually asked ChatGPT about this and this is what it said: " While it's true that artificial intelligence (AI) and machine learning (ML) have the potential to automate certain tasks performed by data analysts, it's unlikely that they will completely replace the need for human analysts. Data analysis requires not just the ability to crunch numbers, but also to interpret and draw insights from data. Human analysts bring a level of context, intuition, and creativity to the process that machines can't replicate. They can also handle the more complex and ambiguous tasks that machines aren't yet capable of. Moreover, while AI and ML can automate some parts of the data analysis process, they still require human input and oversight to ensure that the results are accurate and relevant. In fact, data analysts can leverage these tools to enhance their work and make better decisions. Overall, it's more likely that AI and ML will augment rather than replace the role of data analysts, allowing them to focus on more complex and high-value tasks." Just to be sure, I had a couple of follow up questions: Me: "Are you sure about that? I'm currently studying to be a data analyst and you would make me cry if I ended up devoting a lot of time only to learn later that finding an entry-level job has become almost impossible because of AI." ChatGPT: "I understand your concern, but it's important to keep in mind that the widespread adoption of AI and automation technologies in the workforce is a gradual process that will take time to fully develop. While it's true that AI and ML have the potential to automate certain aspects of data analysis, they cannot replace the unique human abilities of critical thinking, creativity, and context that are essential for making sense of complex data sets. In fact, the increasing use of AI and automation in data analysis is likely to create new opportunities for data analysts, as they will be needed to oversee and manage these technologies, interpret the results they produce, and apply them to real-world problems. It's also worth noting that AI and automation technologies are not foolproof and can produce inaccurate results if they are not properly designed and implemented. This is why the role of human oversight and validation will remain critical for ensuring the accuracy and reliability of data analysis. So while the field of data analysis may evolve as a result of AI and automation, it's unlikely that these technologies will make the role of data analysts obsolete. With the right skills and training, there should still be ample opportunities for data analysts in the years to come." Me: "Maybe you just don't want to hurt my feelings." ChatGPT: "As an AI language model, I don't have feelings, but I understand your concern. I can assure you that the role of data analysts is still highly valued and in demand across many industries. While AI and automation may change the nature of the job, they are unlikely to replace it entirely. In fact, the rise of AI and automation technologies is creating new opportunities for data analysts who can leverage these tools to perform more complex analysis and gain new insights from data. Data analysts who are able to adapt to new technologies and continue to develop their skills will be well-positioned to thrive in the evolving field of data analysis. Ultimately, it's important to approach your career with a growth mindset and remain open to learning new skills and adapting to change. With hard work and dedication, you can build a successful career as a data analyst, even in the face of technological advancements." Me: "Okay. If I ever get a job as a data analyst, we'll go out and I'll buy you a beer." ChatGPT: "As an AI language model, I don't drink beer, but I appreciate the sentiment! I'm always here to help you with any questions you may have, so feel free to reach out anytime. Good luck with your studies and future career as a data analyst!" 🤣😂😅

Repetitive tasks can already be automated using scripts and AI can do critical thinking. The biggest challenge is dealing with dirty and inaccurate data, which requires actually contacting stakeholders to figure out what’s going on. That’ll probably be quite tough to automate.

I don't think Analyst jobs will be mostly replaced by machines. Instead, AI can boost the analytics function and the analyst can focus more on analyzing the data and better communicate with others instead of spending tons of time processing data.

As someone who has started the certifications, it is very scary as it seems those repetitive tasks that are being replaced are the entry positions, meaning the door is often closed. Wondering if I made the right choice.

I'm in Tech Sales, I feel more comfortable that sales won't be replaced because no one likes to buy from a robot. I started Data Analysis but now feel unsure

I'm only staring my pathway in Data Analytics, but as someone who studied Translation I can say that yes, many things may become automated, but there is always a need for a human who could revise the work, check errors and replace/add certain things. It's true that this might change in a few decades as well, but for now translators have nothing to worry about, despite the wide availability of all sort of translation machines

The job landscape is always shifting. Studying for a certain career is also about transferable skills and networking!

A few years ago, a notion was common that Tesla's self driving trucks are around the horizon and they will replace truckers by automating their jobs and one should learn to code as programming will be the most future proof work. But now with these 'evolving' language models, I assume that office desk jobs that requires human intellect for data processing, be it programming, server administration, or anything involving digital information, will be the most vulnerable than the manual labour jobs like trucking. I fear we still haven't yet fully realized what major implications AI can have in the coming few years, especially with the phenomena of emergent abilities and AGI.

AI tools are hitting hard on content writers though it doesn’t mean writers jobs are gone. Similarly, AI can help automate things in data analyst but the whole profession can’t be scrapped. It’s definitely a different and more modern ways to do data analytics with AI. All the data analysts must do this transition as quick as possible and learn, adopt new tech to make it works for you.

Those people who are worried in the comment section no need to worry at all .. whether this is data analytics or software eng or web devs ...nothing is gonna happen . I believe most of the coders used stackoverflow which was the best tool for productivity while working and they have shifted to chatgpt which is just stackoverflow on steroids. So continue with your work this is just a hype created.

No sarcasm, just want to discuss: for the example in the video, why there will even be a “Jessica” role if the business stakeholder can simply pull out the data and analyze it themselves to find problems and improve product? I often think the reason why data analyst exist as a role is because the process of getting data ready to be analysed is too much for business stakeholders. Therefore companies hire data analyst. But if AI makes analysing big amounts of data as easy as using Excel to analyse 100 rows, then why can’t stakeholders do it by themselves? I’m just a student learning analytics but I always wonder why we all say picking insights from data is the job for data analyst, not the business stakeholders who are actually directly responsible for the end result? Please correct me if you think I’m wrong. Lots of anxiety after the launching of code interpreter

I've talked to number of software engineers, developers, system/network/cloud admins and data analysts. It seems that not a single one of them is worried about their job due to rise of AI. The only places where I'm stumbling upon people saying that AI will replace all Tech people are RU-vid and Reddit.

OMG! I studied petroleum engineering bsc. I was planning to switch my career to data analyst. Now it has potential to be replaced by AI. Petroleum industry also has potential to be fully replaced by renewable energy. What is wrong with me

In the 19 years, I have been working with data, I have always seen new tools that can automate repetitive tasks. I agree, upskilling, is important and is a way of life for a data analyst. Never stop learning. I believe AI will encourage us to explore more and be better at our professions.

I think lotof jobs overall in data and tech could be replaced by AI but governments and tech will let the people adapt slowly to a new job situation

Every single job can be replaced by AI. But one thing that can’t be replaced is human decision-making. Whilst AI can make probably even better decisions, businesses will most likely take more comfort in a human advising a strategy rather than AI. So strategists & decision makers will be where data shifts to I think!

This news lately 😂 ... We will see some automation in daily tasks across the industry, but it will vary for different roles. For example, in backend software engineering, it's important to start experimenting with machine learning technologies and "AI" to implement CI/CD, recommendations, deployment etc., on top of projects, similar to how you would add AWS infrastructure on top of a project. I have been using CUDA for quite some time now, even before tools like ChatGPT were popular. My point is, if we want to stay ahead of the curve, we need to learn these technologies and even build our own tools (nothing fancy about that). After all, some technologies are already a few years old. Data analysts have always used existing tools, so for them, it's common sense to use existing AI tools to improve productivity. It will not replace them, but rather enhance their roles.

I think AI will replace the entry level roles in data analytics, which is why its so daunting because as entry level analysts (like myself) our first few years will most likely involve repetitive and more simpler tasks that can be done by machines. And the more this happens (i.e the more companies seek out for experienced professionals) the harder it will be to get into the field. Not only that, the barrier of entry will be much higher as well since you have to compete with both other entry level analysts AND ai. People with less than 2- 3 years of experience dont really have the luxury of talking with shareholders and giving insights directly to managers nor are they given that kind of work to do. So, in a way, the entry level analysts are the Jack's of the role, easily replaceable

ChatGPT cannot replace data analysts. Almost on a daily basis, I encounter different types of 'dirty' data that need cleaning, and creative manipulations to make it ready for analysis. If this was the case, data analysis software packages would have already replaced us. Real data analysis requires critical thinking and deep creativity that ChatGPT or any other AI cannot possess.

unfortunately you are incorrect. jobs requiring critical thinking will ALSO be automated by AI. all jobs will disappear shortly after AGI emerges.

AI can do critical thinking and problem solving. Literally everything Jassica does AI would be able to do as well. So you're wrong. Both would be automated by AI. I don't understand the denial of humans thinking they are special and that thinking which is the main thing in AI isn't going to be achieved by AI in 5 years. In that much time most jobs in all industries will be automated by AI. People need to accept that. The whole point of AI is that AI is about replicating human thinking and if that is the case it should be capable of doing anything a human can do mentally.

Jack and Jessica - siblings 🤣 Great video!

Great video! Are there really data analysts that have a limited scope like Jack? I am a Business Analyst which includes a significant amount of data analytics. I have been automating more and more of that kind of reporting using Power BI already which frees me up to do more serious analytical tasks as well as the myriad other things a BA does.

After watching this video, I'm highly in doubt whether or not should I go for this field as my career path or not. I wanted to apply for masters program in Data Analytics but now I'm doubtful. What new fields are there for career path or should I take the admission 😔

I must say this. why do I find your explanation more understandable? Some of the videos I have seen are in English which was like seeing a Korean drama without subtitles. They are speaking simple English but not understandable. Maybe the presentation is part of it. Anyway, what you pointed out is logical. Loved your video.

waiting for this video ever since i asked this question in your last video . big thanks for this video but already there are many ideas suggested by AI which are step ahead of jessica by the time she learn some new skills isn't that correct? it would be relevant if you could make a video on how to use those AI tools

Well… here is what CHATGPT said when I asked it the same question. No, AI will not replace the need for data analysts, but it will change their roles and responsibilities. While AI can automate some tasks, such as data cleaning and analysis, it cannot replace the critical thinking and decision-making abilities of a human data analyst. Data analysts are responsible for interpreting data, finding patterns, and deriving insights that can help businesses make informed decisions. They also work with stakeholders to define business goals, identify metrics, and design experiments to test hypotheses. AI can assist data analysts in these tasks by providing faster and more accurate data analysis, enabling them to focus on higher-level tasks that require human judgement and expertise. Data analysts can use AI tools to automate routine tasks, such as data cleaning and visualization, and spend more time on tasks that require creativity and problem-solving. In summary, while AI will change the role of data analysts, it will not replace them. Instead, it will complement their skills and enable them to become more effective in their roles.

A common pattern I'm seeing across industries is that work that can be automated, will be automated. How and when to automate seems to be the next logical skillset, and that might lead to expertise in a domain being what you're paid for - the "hours" of work that can be automated will no longer be a part of one's paycheck. All this said, I have no idea where the world is going. It's equal parts exciting and unsettling.

Actually we humans are over thinkers about everything. Just learn what you are learning with passion. Do your best. Don't need to panic and race with others. Its ok you are doing great. Even try to take helps from these AI tools. It will help you in learning and make your job easier. You need to learn how to use AI for your ease at work. don't compare your self with AI. What GOD made is much more expensive than what human made. PS: Also In term of Data Security, Not everyone is comfortable to share confidential data with AI tools. Because in Data field, What important is "Data Security" for big companies.

What about Julius AI?

ai indeed will replace the data analyst and we as a team working on it

Very nice content, precise and to the point. If you can add a little more for critical thinking and analytical part of data analysis with a few more examples that would be very kind. Thanks

Thanks for putting this together and sharing too. Good insight great value 😊

I am trying to switch toward an analyst role, I am hoping I can get ahead with the AI tools.

Most mid-level "executives" drool over pivot tables even though they rarely understand them. They also like having a person to give orders to so they will resist AI and automation as long as possible. At some point the data analysis and reporting will become standardized and automation will follow. The mid-level executives and their lackeys will be replaced by an AI Analytics department (no people, just AI agents). Companies that resist this trend will soon find they aren't as competitive as their progressive competitors .. lightning and thunder, fire and brimstone ... it won't be pretty.

As a data engineer these things are already being automated without ChatGPT or other AI models. I strongly disagree with you on everything though. You can’t automate say, a Python or sql script without the controller knowing Python or sql. If you just place a random person without them having knowledge of what the do and replace people with “prompt engineers” companies are going to have a REALLY bad time

Please do you think it will replace front end Development and machine learning?

Indeed. Ai can’t tell an email is wrong by 1 digit or letter because the database itself in has it stored That way, because that’s what people put in

Hey hi How Excel are important for data analytics And give a which topic are more important

FWIW, Jack's job by and large has already been automated with modern reporting solutions like PBI and Tableau. You don't need AI or ML for data process automation. Jessica's role however isn't going anywhere anytime soon.

There would still be a need for people who can use AI to do those tasks using AI. AI cannot do contexualization.

In 2 years Jack and Jassica, both, will lose their job. AI can perform critical analysis faster and better than us, that's what they are made of, how do you think AI is trained?

"A.I. and/or automation won't be able to do my job" = delusional, just give it time

You have provided an insight, I learned a lot today, Thank you!

I think the key point is the responsibility. If a manager uses ChatGPT to produce data analysis, he is the responsible of this product. If he is not an expert in data analysis, he does not know if there is something amiss. It is better to hire a data analyst to check if the outcome of ChatGPT is right and take the responsibility.

Hi..... Is it possible to secure a remote job as a Data analyst?

Data Analitic+AI(ML+DL)=Data Science, mean Data Analitic updated version of critical thinking,complexed problem solving is Data Scientist, Data Analyst Advanced version is Data Science won't die

I don't see the issue. It's still someone who needs to type the command in and look through the data to see if it's correct and make it repricantable. Even if the work can be done through AI, a human needs to monetize it. The work will change, take less time, yes. = less work, but it will still be a demand for it. Before the Internet and data, we had bookkeepers who, for ex, worked with just typing out the numbers in a company on paper. Most of that is computer generated these days, but we still need to monetize it. When AI is becoming robots, however... although, I think that people still are needed for a complete end result.

Thanks for doing this, I am just starting my journey as a D. A.

What about data engineering they also replace by AI?

Can you please suggest which are the best coding languages and please suggest some books or channels to get hands dirty on statistics

FiveTran didn't eliminate those $150-200K data engineering jobs.

The thing is that ai won't replace any IT roles but it will reduce the no of people in that role as something which requires 100 dev today may only require 20 dev with the help of ai to achieve the same productivity. This mean less jobs and hence the fear

I ASKED THE SAME QUESTION TO CHATGPT AND THE ANSWER IS AS UNDER: The field of data analysis is being significantly impacted by advancements in artificial intelligence (AI) and automation. While AI has the potential to augment and enhance the work of data analysts, it is unlikely to completely replace their jobs in the foreseeable future. Here are a few reasons for this: Complex Analysis: Data analysis often involves complex problem-solving, pattern recognition, and decision-making, which currently requires human cognitive abilities. AI systems can assist data analysts by automating repetitive tasks, generating insights, and speeding up data processing, but they still rely on human expertise to interpret and apply those insights appropriately. Contextual Understanding: Data analysts possess domain knowledge and contextual understanding that goes beyond statistical analysis. They understand the business objectives, ask relevant questions, and consider broader implications. AI systems lack the contextual understanding and critical thinking abilities to fully replace human analysts in complex decision-making scenarios. Human Judgment: Data analysis involves making judgments, interpreting results, and presenting findings to stakeholders. Human analysts can apply their intuition, creativity, and subjective judgment to draw insights and communicate them effectively. AI systems, while powerful in processing large datasets, often lack the ability to explain their reasoning or incorporate subjective factors. Ethical Considerations: Data analysis often involves sensitive and confidential information. Human analysts are responsible for ensuring ethical data handling practices, maintaining privacy, and addressing potential biases. Trust, accountability, and ethical decision-making require human oversight. However, it is important to note that AI technologies are continually evolving, and their capabilities are advancing rapidly. While complete job replacement is unlikely, certain routine tasks within data analysis may be automated, freeing up analysts to focus on higher-value activities. Data analysts can embrace AI as a tool to enhance their work, acquire new skills in AI and machine learning, and adapt to the changing landscape of the field.

Legislation needs to be passed preventing AI from wiping out jobs.

I guess for someone concern about AI, the best option is Data Science, because all the maths and critical thinking the career involve.

Hi Sundas, I am a great admirer of you, I have been literally like watching your videos since I started my journey into Data science but after evaluation I found that Machine Learning is a Great path for me but I still have a confusion though I read many articles, But I still want to hear from you if I should go for it or not, PLease If possible upload a video sharing your opinion onto this, I would be grateful to hear it from you, "Thank you all the interactive videos" from your well-wisher.

How AI will 1.clean data 2. Judge which data is more important and what to drop 3. What about report creation 4. Who will judge that AI report is correct and how it's going to give presentation and deal with the client. 5. I AI tried a little complicated python query python codes are given error 😅 So, I my opinion AI will not get our jobs but it going to made our job easy faster and quicker Definitely below avg. ppl will lost there job because of AI

I’m learning sql and Python and I feel slow compared to the speed that Ai is advancing. It’s very stressful to try and enter the market at this time. However Your video was very reassuring that I should continue.

Hi, I have completed my bachelor's in mechanical engineering in 2021 and in 2022, i have completed data analytics course and i didn't get job as fresher in data analyst domain till. i have one question that, what i need to do to get a job.

Hmm, I’m a web developer so it’s not the same however, the process is similar. What you don’t understand is how scary and amazing these AI tools are. Nobody is safe, not even critical thinking and analytical skills will save you, because the AI is self improving and even solving championship mathematics questions. How long do you think humans can keep up? 5 years? There’s a good chance AI will surpass us. Smarter than the smartest human. At the same time, we can use such machines to our advantage to create our own business. There’s opportunities.

IBM décidé to replace jobs in IT support par AI

What do you think of data engineer in ai era ?

It cannot be automated machine learns from input data and human intelligence intervention makes a difference in terms critical thinking more problem solving oriented and getting upscaled various AI tools will make a differnce

how to get job in this field as a fresher?

You're the best, thank you. This is very helpful for me.

For someone just thinking to change carrer, basecally, are you saying a "business analyst" will not get replaced but a data analyst will?

Have you ever used MySQL? I always have issues with the installation process. Thought I’d ask

Great video Sundas - completely agree with you.

I am just shifting in IT and why this chatgpt has to already take away the jobs😢

Would salary decrease?

Can AI replace Data Analytics This is how AI replied. AI can significantly augment data analytics by automating repetitive tasks, identifying patterns, and making data-driven predictions. However, AI is not expected to replace data analytics entirely. Human expertise is still crucial for interpreting results, making critical decisions, and understanding the broader context of data analysis. The collaboration between AI and data analysts is likely to be the most effective approach, leveraging the strengths of both to unlock valuable insights.

1:09 Jack left the chat..

well, AI in this information age is speeding innovations and radical money and power shifts disrupting ‘life and wealth as usual’. it has impacted people lives and their projected stability more than any single leader or politician

Ricky is glad that Jessica doesn't lose the job😂😂😂

Thank you for posting this helpful video

Not possible... I am sure.. 2030 to 2050 data scientist Era

In your hypothetical scenario, automation should have replaced Jack years back. I am not sure how he still has a job.

I personally think that A. I can make things easy for data analyst and not replacing it... We created technology to make our work easy not to replace... Nothing can replace a human brain... Nothing

Your 10 years of experience are meaningless in the face of exponential increase of capabilities of Ai, as is your assumption that Critical Thinking and 'Creativity' are a safehaven for replacement by Ai. This is a kind of 'human exceptionalism' thinking, the idea that Human intelligence has properties that an Ai could never copy. Let me explain. This is the fallacy in reasoning that almost everyone who doesn't think this is actually happening is falling into. Jassica will be replaced just as fast as Jack. The idea that because she needs 'critical thinking' is making her impervious to replacement is a big, big, big mistake. Transformer LLM's are specialized at pattern finding, and they are much better at it than any human, and the pattern finding is the foundation for what you consider 'creativity' because it's that 'creativity' that allows Jassica to find patterns that weren't identified before, which is what makes her good at her job. Thus she will be replaced, because what you think is 'creativity' or 'critical thinking' is actually foundational feature of current generativeAi models, and it scales perfectly with Dataset and computational resources, so it's not a matter of IF but a matter of WHEN. Ai has gone from scoring 26% on Medical Licensing Exam in early 2022 to score 86% in February 2023.. That is nearly 4X increase in performance within 1 year. Human doctors only score a 94% at best, but Ai will score 100% a 100% of the time within a year. Stop denying reality. Stop thinking you're special because you're a sack of meat and water... Ai will replace you. Period. It's not a bad thing. We will have UBI and everyone will be free to pursue their passion, but first economies will collapse.

Why do we still want to learn coding if ChatGPT could do it for us?

Microsoft power bi VS Microsoft 365 copilot

I think data entry jobs will effect first then data analyst entry level jobs.

yes, next question

Remember, computer is dumb, but diligent. Sure he can do ALL the task that a human can do. But, they can't do it, unless a human tells (or should I said program it) to do the task

Time will say

The fact is ChatGPT is extremely truthful.

I think you mistyped your name. It should be Sundus.

Hi Sundas! Can you please tell me, how useful is knowing Java for working as a data analyst? If there is someone with an answer to my question, based on experience, please feel free to comment. I would be very grateful. Thanks!

If we fear AI, then it is because we stopped fighting, not because AI overwhelmed us. AI is the servant of mankind.

Yes

It's 12 months.

what about data science. is it going to be automated again?

thank you very much sundas

In 50 years? Maybe, in the meantime they demand will grow very quickly.

u are sbsolutely right

The problem is that 90% of the data analyst job, is what Jack is doing. So it means we will need 10 times less data analysts, and the juniors will be out of the market even before arrive. The companies will not hire almost any new data analyst with less than 3 years of experience for at least the next 5 to 10 years after this automation starts. This is going to be the same for almost any intelectual job, and specially the ones linked to the technology. Governments, educational institutions, those tech "gurus"... where throwing the most inteligent people to study software engineer, web design, data analysis, mathematics... the jobs of the future, they said... and now they will have no job. They just threw to the garbage the most intelligent people from a whole generation.

It could work if AI general intelligence was a thing (atleast to the general public) & provided it had the sense to think abstractly, dynamically as well as conceive original ideas and possess the cognition to even comprehend what a problem that needs solving looks like from a human perspective, then yeah, AI, has a chance. But for now, a data analyst armed with AI tools, that will be a much more efficient combination. But if data analysts were wiped out tomorrow, people un knowledgeable in the realm of statistics/mathematics typing prompts into an AI, will not cut it, I don’t care how smart or creative you are.

I am in the middle of a data certificate I'm thinking of quitting because I used chat for data projects and chat is much better.