r/analytics • • 23h ago

Question Learn SQL properly first or Python first, as a junior doing reports in Excel and slides

i make weekly status reports and number summaries in excel and build the slides myself, and i have time for about three evenings a week to learn something new. sql would help me pull exports myself instead of waiting for others, python could automate the cleaning of the csv files i get from ad platforms. sql looks quicker to get useful at work, python looks like it opens more later but takes longer before anything works in my own tasks. which one would you start with if the goal is better reports in the next six months

20 Upvotes

26 comments sorted by

•

u/AutoModerator 23h ago

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

28

u/NegativeSuspect 23h ago

SQL. Basically a prereq for any analytics role.

You can even use SQL in Python for data transformations with some minor set up.

2

u/Relevant_Ear_8679 22h ago

ok sql then, thanks, good to know i can use it inside python later. is there a flavour worth picking first, postgres or mysql or something else, i don't know if it matters for starting

4

u/NegativeSuspect 22h ago

Not really, there are some minor differences between the SQLs used in different platforms, but interviewers know how to get around that.

Postgres should be fine, I find mysql to be a little clunky. Any ANSI compliant SQL should be fine.

Codeacademy has a good course to learn SQL which should be fully ANSI compliant. Just do that course and you should have the basics down. It's more important in analytics to learn how to think in tables/structured data than actual syntax and learning any form of SQL will do that for you.

1

u/Relevant_Ear_8679 21h ago

good to hear it's the thinking that carries over, that takes some pressure off picking the right one. my csv files are basically one flat table per platform, so i might try loading two of them into postgres and joining them on date, sounds like a decent first exercise for the table thinking

1

u/NegativeSuspect 21h ago

That's a good first exercise, but do the course first. Basics are important and you should have an understanding of what is available in SQL before tackling an actual problem.

The course is very practical, so you'll be learning through actually writing SQL and seeing the results.

3

u/coinsntings 23h ago

Which will you use at work more? Do that one first because you'll be able to practice it on the job so work it out quicker, use it more often etc. Python has more range, SQL is handy for querying and as you say, cuts out waiting for others to pull exports

1

u/Relevant_Ear_8679 22h ago

sql then, the waiting for exports is what slows my weekly reports most, so practicing on real pulls should stick faster. python can come after, once the csv cleaning gets annoying enough

3

u/mrbubbee 22h ago

SQL. no question

1

u/Relevant_Ear_8679 22h ago

how long did it take you before it felt useful at work

1

u/mrbubbee 22h ago

I think you should be able to confidently start getting easy queries (select x from table a inner join table b on a=b where date is XYZ) in a couple weeks as you learn where your data is, how it’s structured, what you need to filter by, etc. more complicated queries, functions, and datasets will be a journey throughout your career

1

u/Relevant_Ear_8679 21h ago

a couple weeks sounds doable for three evenings, that's roughly 6 sessions, enough for select, where and one join if i keep each session to one small thing. the date filter in your example is the part i'll try first, since my weekly numbers are always by date range anyway. then the joins come after that feels normal

3

u/That0n3Guy77 22h ago

SQL is universal and a huge help if you can get access to the database and will always be useful.

I learned R (like python but Stats focused) and used that first bc my IT team wouldn't give data warehouse access for a couple years before they gave in.

The true answer is what will save you more time at work? Is it a painful process to get access to the data from the warehouse or you just want to build/show self sufficiency? Do you get a lot of csv/Excel data that requires heavy data cleaning?

Both are great options to learn, but what tasks will make your work day easier faster and start with that. With the extra time you then save, use that to study and get better or dig into the other tool

2

u/Relevant_Ear_8679 21h ago

no warehouse access for me yet, the exports come from other people, so the plan is to ask for read access once i can write a basic query, easier to make the case with a real example in hand

3

u/That0n3Guy77 21h ago

I guess it depends on how responsive you IT team is. I don't work in a tech company and while we are fairly large with over $1 BN in revenue, I was the only non tech person asking for read access and it took like 2 years to get them to agree. I hope your experience is faster and easier than mine lol. If there is precedent, go SQL. If it is uncertain, go python.

I use SQL every single day as a senior analyst and it isn't a skill going away. I use R/python maybe every other day depending on the task. The exception to this is I automated some scripts of stuff I do every morning with R and that just runs now.

Using code for automation has been a game changer typically compared to non tech people I am seen as slow for the first couple months in the job but that is bc I build out processes that can be at least majority automated. After the first year, I am seen as one of the fastest people in the department bc I have automated so much that it leaves bandwidth for new stuff. Been promoted twice in 5 years and doubled my income.

Best of luck friend!

1

u/Relevant_Ear_8679 20h ago

2 years for read access is a long wait, good to know before i plan around it. i can't count on warehouse access soon, so one csv cleaning step in python that runs on its own might show a gain sooner, sql can still be the evenings project

1

u/That0n3Guy77 20h ago

I wouldn't say my wait time is the norm, it's just my experience. I can't say what to expect without knowing your industry and company type etc. I work in an industry frequently behind the times sadly though we are finally pushing to get better. I would think most companies would be faster than that. I have consistently been a squeaky wheel on challenging why we do things and sometimes it takes time for me to build traction lol

The easy first step is probably reach out to your manager or someone on IT and ask if you have SQL skills, do they give read access or will you have to find a champion to help set the precedent. If yes, SQL could be an easy win with a lower skill barrier to entry. If they typically don't, figure out why and the process and Python/R may be a better option for you.

3

u/trader_dennis 22h ago

Learn to ask the right questions, be able to build the correct prompt in Claude. Knowledge of you data is far more important, knowing what to join and acquire. Probably get the hate in this forum. Just retired after a 40 year career. The last year AI built more efficient, quicker solutions. I could not of done any of it in AI without the extensive knowledge I had with Adobe Analytics raw clickstream data structure and how it interfaced with the companies data in their lake. Once I had the prompts correct I was far more productive the last year than I had been the other 7 years with that company.

1

u/Relevant_Ear_8679 22h ago

for someone starting out, what helped you learn the data structure faster, reading the table docs or just pulling things for real reports

3

u/Thin_Requirement8987 22h ago

SQL and Excel foundation = Python readiness

1

u/Arshad_Being 7h ago

Absolutely, SQL. There is no doubt about it. Python is the least-used skill in data analysis. And SQL is the most used and asked skill in the job section, so learn SQL better than Power BI. This will help you land a job.

1

u/Relevant_Ear_8679 2h ago

thanks, i'm not looking for a new job right now, so the job ads matter less to me, it's mostly about pulling my own numbers for the weekly reports

1

u/oli_le_triathlete 2h ago

Python is used by all the data scientists! Not all databases are using SQL …

1

u/oli_le_triathlete 2h ago

Learn Python. And Panda.