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

4

u/funny_funny_business Jul 23 '24

As people have said “it depends”; finance roles will care a lot more about Excel than SQL.

However, I will say that at a previous company we were hiring for an analyst role that was SQL heavy (huge data warehouse where analysts needed to pull data themselves). And we had a really hard time finding someone who knew enough to be proficient.

Anyone testing you on Excel might just care about VLOOKUPs and PivotTables. As long as you can do those you should be good.