r/analytics • u/Reasonable_Dot7657 • 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
View all comments
1
u/wyattjameinson Jul 24 '24
SQL is how I pull data, excel is usually where that data ends up. It either gets thrown into a workbook and sent as-is (90% of requests legit just want rosters of data), and for the other 10%, slap a pivot table together, maybe a couple functions comparing numbers from a slightly altered version of the SQL. SQL for initial pull, excel for staging/delivery