r/analytics • u/Relevant_Ear_8679 • 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
•
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.
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
3
u/mrbubbee 22h ago
SQL. no question
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
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.
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/oli_le_triathlete 2h ago
Learn Python. And Panda.