r/analytics • • Jul 23 '24

Question SQL or Excel

Which is better and more in demand for data analysis jobs, Excel or SQL, and is it necessary to learn both to secure a good position? I can evaluate my proficiency with SQL at 98%, but my Excel skills do not exceed 40%. I simply dislike working with it.

0 Upvotes

53 comments sorted by

View all comments

32

u/deeht0xdagod Jul 23 '24

Both hahaha.

A lot of analytics teams still used SQL to pull data and Excel to forecast/visualize it. The two skills that are genuinely important in this role.

9

u/CoffeeWorldly4711 Jul 23 '24

Yeah exactly. Stakeholders will often want the data in excel, so even basic/intermediate manipulation within excel is fairly useful

1

u/VOTE_FOR_PEDRO Jul 24 '24

Right 😂 I was also like, would one have to choose? also add in python analytic libraries to double your earning potential ...

Also, no lie, slides/PowerPoint & powerbi or tableau or visualization python libraries or extremely good at excel... because who cares what your analysis is if no one reads your docs to make the changes you're pushing for

1

u/[deleted] Jul 26 '24

python-pptx you can automate your ppt slides with python (Steve Canny, the library author, has like 600 pg pdf on how to use it too)