332
u/alexnew655 Feb 14 '25
Management: “yeah the modeling is cool. Can we just see a volume bar chart in Excel?”
109
u/3BettingYourMom Feb 15 '25
Seriously though. I know several cool tools in python but I write everything in sql and inject the data into a dashboard or export to excel. Quicker turn around times compared to trying to use python. Every once in a while I’ll use python within a power bi dashboard but it’s very basic stuff.
38
u/NoWayItsDavid Feb 15 '25
Pssst don't tell all the data science secrets here. I do it the same way.
8
u/Otherwise-Price-5487 Feb 16 '25
I saw a great TikTok from a senior data scientist the other day that essentially said:
"When preparing an analysis for a client, you should utilize every advanced statistical technique that you can to get accurate results. PCA. Correlation Matrices. AB Testing. Bayesian Regression with lagged variable... whatever you need to arrive at the truth. The final product that you deliver to the client though should be incredibly easy to understand"
[He then proceeded to show an example of a project where, based on a simple timeseries graph you would think that XYZ is true. And then shows another simple graph that contradicts XYZ and makes you realize that actually ABC is true]
"This was the results of months worth of work between a team of advanced data analysts. The difference between a Jr. and a Sr. Data Scientist is the capacity to explain incredibly complex, nuanced results to a child"
1
9
u/Dispicableboo Feb 15 '25
Dm me some other “basic stuff” you use to make your work more efficient l, I’m starting out and would appreciate the insight
2
u/OverratedMusic Feb 16 '25
Nowadays with GitHub copilot, doing analysis on a set of data feels kind of like just talking to your data
1
u/3BettingYourMom Feb 16 '25
We can’t feed proprietary sensitive data to co pilot. Plus co pilot is ass cheeks. I still have to write most of my own code.
76
u/Working-Chair-2092 Feb 14 '25
How do you like Python for Data Analysis? I’m getting my Master’s, and i have the digital copy for one of my classes. I haven’t had the chance to take deep dive into yet.
19
Feb 14 '25
What masters program are you in? I’m looking at some and curious
31
u/Working-Chair-2092 Feb 14 '25
I’m getting my MS in Business Analytics through University of Iowa. I live here, and I liked the program. There are people from all over the country enrolled too.
5
u/FaceglazerSSBU Feb 15 '25
Hey, I’m in MS of Business Analytics here in Oklahoma at a local college. Just started this semester. How long have you been in yours for?
6
u/Working-Chair-2092 Feb 15 '25
Hey. That’s awesome. I’m the exact same. I started with Data Programming in Python. I’m liking it so far. How about you?
4
u/FaceglazerSSBU Feb 15 '25
Oh sick, I’m both excited and nervous for Data Programming next semester. Lol. I’m in two classes right now, Analysis of Business Management and Marketing Analytics. Both are heavy Excel based, which is good for me!
4
u/Working-Chair-2092 Feb 15 '25
Nice. Hopefully I can pick up the pace and take on more classes. I don’t have any programming experience and I haven’t been overwhelmed by this class.
3
u/FaceglazerSSBU Feb 15 '25
Yeah, I took quite the risk taking 2 this semester considering I work 46+ hours per week, plus always on call. But so far it’s been manageable. You got this though, keep pushing, I believe in you!
2
3
u/Hmmook Feb 16 '25
One piece of advice if you’re working on a Masters is to expand as much as you can on the “non-data” subjects (operations/project management/accounting/finance/etc). The job market is not the best, and that’s being optimistic.
I stayed with the company I was at when I started my MBA and my MS in DA and was able to move and get promoted but I’m not sure how things would have panned out if I had to look for a new spot. Just my $.02
1
6
u/cli797 Feb 15 '25
I got versions 2 and 3 for python for data analysis. Both will get you good at pandas from. A to z. I also bought a book, effective pandas 2 by Matt Harrison was mind blowing
2
u/Odessa_Goodwin Feb 16 '25
Matt Harrison is fantasitc. Just the right amount of "opinionated" data analysis and commentary. I have effective pandas and effective polars and even though I currently work with R, the things I learned about data analysis from him has made me a better R programmer.
1
44
u/RickSt3r Feb 14 '25
An introduction to statisti learning has a python version as well. But that's one of my favorite resources. I also recommend watching the series it's free on YouTube.
29
2
22
u/hardy_and_free Feb 16 '25 edited Feb 16 '25
I highly recommend "A Mind For Numbers" by Barbara Oakley. It's more about how to study and become more mathematically minded than giving you formulas, etc. It honestly was an eye-opener for me as someone who didn't "have a mind for numbers" and didn't really know how to study.
Also highly recommend Brandon Foltz and StatQuest for learning stats on YouTube. My masters' degree professors used them as resources. Both break it down to be extremely understandable, but Brandon gives you these wonderful pep talks that speak to the adult learner.
6
6
u/life_is_enjoy Feb 15 '25
Is that a mongoose on the python book?
7
1
18
u/SprinklesFresh5693 Feb 15 '25
The real thing is reading them, and practising, not just buying them though.
2
2
1
1
1
u/eljefeky Feb 16 '25
I don’t know if you’ve started James et. al, but depending on your math background that one may be quite challenging. IIRC it is written for a graduate-level mathematical background.
1
u/henrybios Apr 14 '25
Might you be thinking of the ESL by Hastie, Tibshirani? I haven’t read ISLR cover to cover but don’t remember seeing any grad level maths.
1
u/eljefeky Apr 14 '25
You seem to be non-American, so graduate-level mathematics definitions likely vary. Either way, it would have been above the mathematical knowledge of OP IIRC.
1
u/susmen15 Feb 16 '25
Hi I want to start learning data science too, I don't have much of a background regarding the matter, but would love to learn. So where can I start
1
u/Mobile-Collection-90 Mar 02 '25
Why? DAs will be entitely replaced in the VERY close future. I have 10 years' experience in the field but don't take my word for it. Leading experts like Joe Reis agree. Heres a recent post in that :post .
1
u/thvnatoss Mar 08 '25
ISLR is the staple book. I use it in my graduate program and I refer back to it often for personal projects— that things is my lifeline
1
u/Historical_Ad6980 Mar 14 '25
IMO
Data Analytic = Excel + SQL + Python + Statistic + R (about visualization)
1
u/wagwanbruv Nov 22 '25
lol the meta part here is kinda perfect for data work: even a “simple” summarization task breaks if the input isn’t clearly defined, same way an analysis pipeline falls apart when requirements are fuzzy. Next time you can treat it like a mini data project and ask folks to paste the raw text, define the goal (tl;dr, themes, sentiment, whatever), and maybe even share format constraints so you’re not trying to summarize… basically air.
1
u/Trick-Interaction396 Feb 15 '25
You don’t need a that. Use this instead.
x = sales_person_lie
print(x)
-12
u/Double_Education_975 Feb 14 '25
How do you learn this from a book?
67
-5
u/sy2xphus Feb 15 '25
They look cool and definitely have information regarding best practices and etc. but it’s always better just to build something and learn in a process I think
6
u/chiribumbi Feb 15 '25
For your information these books comes with practical exercises, which you can follow using github. Furthermore, two of them are code-based books, not just conceptual books. You literally can replicate all the analysis done.
8
u/hellopandant Feb 15 '25
... and they can do that using the books as tools. It isn't a binary choice.
2
u/tkroy69 Feb 16 '25
For beginners the idea of what to build is itself hard to come up with, these books give you insights of the real world so you get ideas and when you build you have solutions in them as well. Reading these books is actually equivalent to learn by building something.
1
8
u/cli797 Feb 15 '25
My only recommendation. Stick w one program first, then expand. It could be overwhelming and confusing jumping between R and Python. You'll soon realize you'll need a little of SQL, basic statistics and others depending on the path you forge.
https://www.statlearning.com/
You can download free 2nd edition of statistical learning for either r or python.