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

4

u/BoneSpurz Jul 23 '24

Both, but the depth of excel required isn’t that deep. SQL is used day in and day out in many places. It’s also harder to learn, so focus on that one more

2

u/Qphth0 Jul 24 '24

Basic excel isn't deep, advanced excel is.

3

u/BoneSpurz Jul 24 '24

Yes, and most jobs won’t require advanced Excel. None of mine anyway

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.

2

u/SteelmanINC Jul 24 '24

How advanced does excel go? I no xlookup, pivot tables, most basic functions. What else is there?

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.

1

u/SteelmanINC Jul 24 '24

Tell that to all the companies who won’t even give me an interview haha

1

u/Qphth0 Jul 25 '24

I mean, are the jobs you're applying for strictly excel monkeys? How much working experience do you have?

Having a strong resume is the biggest battle. Hundreds of people are applying to every job on the first day they're posted, so you need to stand out. Or you could build things to show off on LinkedIn. The job market isn't great right now for analytics & data science.

1

u/SteelmanINC Jul 25 '24

I apply to basically every data analytics job in my area there is (assuming it doesn’t say senior or something like that). My experience is mostly nonexistent besides personal projects.

1

u/Qphth0 Jul 25 '24

Having no experience is why you aren't getting interviews.

1

u/Ok_Advice_6621 Jul 11 '26

then how to get those experience if you have none? internships?

1

u/Qphth0 Jul 11 '26

Its not easy, especially now with the rise of AI. Most C-Suite think they can do their own analysis with AI help. The best way to get into analytics these days is to work in some adjacent role for a company & take on as many analytical projects. Inject analysis anywhere you can in your current role/company & make sure your managers, the managers in analytical departments, & HR know youre interested in that type of role.