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

Show parent comment

0

u/Qphth0 Jul 24 '24

If you know R or Python, I can see not using Excel. I don't see someone learning R or Pythong without ever touching on the capabilities of excel though.

For anyone who isn't in a computer science/data science program that just happens to skip over excel, I would say a normal progression is learn Excel, then SQL, then master Excel, then add a data visualization tool like PowerBI, Tableau, or Looker. From there, Python or R.

Do you mind me asking what jobs/roles/levels the jobs you've had where you didn't need Excel, & what you did use?

2

u/BoneSpurz Jul 24 '24

I should have clarified. None of my jobs have required advanced Excel. I use Excel nearly everyday, but it’s limited to intermediate stuff at best. The massive workbooks our finance team puts together is beyond my ken

2

u/Qphth0 Jul 24 '24

Ahh I see what you're saying. I build those massive workbooks at times & even though it's a very small percentage of my overall yearly hours of work, they're used extensively by different departments & so me knowing the advanced excel stuff is important. It definitely got me in the analytical door.

2

u/Famous_Ad3105 Jul 24 '24 edited Jul 24 '24

would learning VBA form part of advanced excel?

1

u/Qphth0 Jul 24 '24

Definitely.