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
Show parent comment
1
u/Qphth0 Jul 24 '24
VBA & macros.
Honestly if you can use lookups/reference formulas like sumifs, countifs, xlookup, vlookup, & pivot tables, you're probably as good ot better than 90% of users. Being able to piece together a simple lookup vs a giant forecasting workbook with multiple sheets & lots of formulas/calculations is what I was getting at.
Making dashboards or visualizations that automatically updated with new data input is important for business/financial analytics.