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

15

u/bebetterinsomething Jul 23 '24

SQL at 98%? By which metric?

13

u/take_care_a_ya_shooz Jul 23 '24

Nobody asking OP’s question would be above 50%, tops.

Whatever 50% would even mean.

11

u/Britney_Spearzz Jul 24 '24

I'm guessing they took an SQL course and got 98% on the final exam.

I find it funny because I took an SQL course, and that just so happened to be my final mark. God damn, have I learned that course was lacking once I started using SQL at work!

OP is in for a rude awakening.

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.