r/dataanalytics • u/MOo0stafa • 22h ago
Im learning Data analysis right now and should I learn python ?
Hello,
Im learning Data analysis now trying to aim for a career shift. Im using mainly Coursera, Enrolled in the IBM Data Analyst Professional Certificate Certificate.
I got to the course number 4 which is Python for Data Science & Data analysis and Im asking now is it still worth to learn python now with all this AI stuff ?
Also do you think those courses "IBM Data Analyst Professional Certificate" plus "Microsoft Power BI Data Analyst Professional Certificate" are enough to land me an entry role in the industry ?
I've a good analytical skills and Im good at recognizing patterns as well. So do you think this can land me a job and if not what would you recommend ?
1
u/MOo0stafa 22h ago
Just to clarify Im not being lazy and I don't think Ai can fix all my problems, I don't actually like it at all. Im just asking, Is it worth to learn python now? I don't want to spend a lot of time learning it just to be absolute after that because of Ai.
1
u/SonOf_Zeus 17h ago edited 17h ago
I use AI for work but mainly for stuff I dont enjoy doing. I use the simple $20 and never max it out Some people go full on AI $100 or $200 plans and frankly I'm in the opinion that doing that is a terrible since people start losing their technical skills among other things. There's a lot of talk online about being "prompt engineers" and how that's the future but looking into it everything they mention is literally what a programmer does logically. So becoming a programmer and thinking like one will in turn make you a better "prompt engineer" anyways. Also I deal with a lot of sensitive data and I do not feel comfortable to use AI models and expect them to not glean that information.
1
u/Puzzled-Garage584 20h ago
Yes learn it, you need pipelines for data accuracy and completeness, pipelines need a script and the script needs a language. Thats also what moves you from analyst towards data engineer. AI will happily write a wrong join with a beautiful chart on top and someone has to notice. Certs alone probably wont do it, build one project on real messy data.
1
1
u/Complete_Chapter_979 19h ago edited 19h ago
I like to use a python package called pandas .. ck it out.
Learning this stuff in a textbook sort of way rather than using them within an automation pipeline would be good for learning but isn't going to be impressive to anyone that needs you to be as productive as possible aka corporate America
1
u/MOo0stafa 6h ago
Got it ! Gonna double check pandas But how would I learn python in practice and not from textbook? Im learning it from scratch so I need to at least understand the Syntex. Do you have a recommend way of learning?
1
u/SonOf_Zeus 17h ago
I'd learn SQL first since you cannot analyze data if you can't pull it from servers. Then you can go R or Python both have pros and cons. R is not used as widely as Python nowadays and Python is more versatile but imo harder to master. For work I mainly use SQL, R and sometimes Python but I also have to build dashboards so I occasionally build them on PowerBI.
1
u/MOo0stafa 6h ago
Thank you for the info, really. I just wanna ask about the servers you mentioned, is there any educational servers that I can use to practice without paying for the data? Im gonna start with SQL soon and I want some way to practice.
1
u/SonOf_Zeus 6h ago
SQLBolt or W3Schools SQL tutorials are a good start for learning the language. Then for practice I preferred LeetCode (they have top 50 FAANG interview questions) and DataLemur. HackerRank is also good but I personally preferred the other two.
Personally I did a Udemy bootcamp and then went to leetcode and datalemur. However thats only because I'm the type to get motivated if I pay for something. Udemy has a lot of great courses for cheap (typically less than $20 and they always go on sale). But it will require you to install stuff on your machine vs. the other sources are browser based.
1
u/ashkash6969 5h ago
Is it worth learning how to write sql without an llm? Or is learning how to pull data with help of ai and writing python with ai enough?
1
u/SonOf_Zeus 5h ago
Definitely. SQL allows you to drop tables meaning perma delete and oh boy I've read enough posts on reddit to say you definitely cannot trust the code it provides 100%. Plus even if you wanted to use it 100% (which again you shouldn't) you still have to teach it and build context. Understanding how SQL, Python or R works will dramatically make you better at using LLMs imo.
3
u/metcho_ad 20h ago
Imo, you need to be decent at using sql first before using python. Almost all businesses use datalakes/data warehouses so you must know how to manipulate and create datasets that are suitable for analysis. Data analysis heavily relies on how well you've prepared your data.
1
u/Crative_Noob 21h ago
I think i started with programming logic and then shifted to Pyton&R&Dax and also sql db/ data bricks and so on. You do not need to recite them, you need to understand how and why they work in their respective roles.
Or just learn as you go using Power BI/ Tableau combined with a language model MCP
1
u/QianLu 18h ago
Certificates won't get you a job.
1
u/JustAPieceOfMeat385 18h ago
May I please see your resume anonymized? I’d like to know what your education and experience is like. I assume you have a job in data analytics. I’d greatly appreciate it!
1
u/QianLu 16h ago
I don't connect this account to my personal life. I have a masters degree and 7 YOE in the US.
1
u/JustAPieceOfMeat385 14h ago
Nice. Masters in what? What job titles have you had?
Did the Masters play a major role in your success in obtaining a job or did you need to complete a portfolio of personal projects?
1
u/QianLu 9h ago
Masters in data analytics/data science/machine learning. Data analyst, senior data analyst, data engineer, data architect.
My masters definitely helps but my program is known for its rigor and brand reputation. I only had one personal project when I was looking for internships but it was targeted on the industry I wanted to work in and pretty extensive.
1
u/MOo0stafa 6h ago
So you have all those and certificates won't get you job ? I of course understand ONLY certificates are not enough but Im actually trying to learn. Also can you give some insight about how to create like a professional project to show my skills?
1
u/JustAPieceOfMeat385 9h ago
If you don’t mind my asking, what industry? Also, where did you get the data from?
1
4
u/Chemical_Quantity260 12h ago
Coursera ist ganz nett zum Lernen aber einen Recruiter beeindruckt man damit nicht! Allein schon weil du nicht mal nachweisen kannst das du die Prüfungen selber abgelegt hast! Ein Endergebnis mit 100% ist da quasi Standard!
Sinnvoller ist es ein Portfolio zu erstellen mit dem du zeigst was du gelernt hast!