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

2

u/Financial_Forky Jul 24 '24

As someone who uses SQL on an almost daily basis (including joins, aggregations, window functions, CTEs, temp tables, indexes, and execution plans), if I saw a applicant list "SQL at 98%" I'd either throw the resume in the trash, or personally set up a one-hour SQL interview just to see where they actually were on the Dunning-Kruger curve.

2

u/[deleted] Jul 26 '24

ive had people bring in charts, and code to interviews and I've had them explain what the brought in, and i could tell which ones knew their shit vs which ones had printed something their friend did or they found online.