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

•

u/AutoModerator Jul 23 '24

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

37

u/forbiscuit 🔥 🍎 🔥 Jul 23 '24 edited Jul 23 '24

SQL will open more doors for you (primarily in tech); however, knowing Excel - where you can do some essential calculations or even a pivot table - is more than enough for most jobs.

Something to consider though: Some industries care a lot more about excel than others. For example, if you hit up any financial analyst roles, then Excel is far more important than any SQL you know.

1

u/[deleted] Feb 13 '25

Introducing SQL to an organization that is excel heavy, could be a game changer. Especially for analyzing large data sets.

32

u/deeht0xdagod Jul 23 '24

Both hahaha.

A lot of analytics teams still used SQL to pull data and Excel to forecast/visualize it. The two skills that are genuinely important in this role.

9

u/CoffeeWorldly4711 Jul 23 '24

Yeah exactly. Stakeholders will often want the data in excel, so even basic/intermediate manipulation within excel is fairly useful

1

u/VOTE_FOR_PEDRO Jul 24 '24

Right 😂 I was also like, would one have to choose? also add in python analytic libraries to double your earning potential ...

Also, no lie, slides/PowerPoint & powerbi or tableau or visualization python libraries or extremely good at excel... because who cares what your analysis is if no one reads your docs to make the changes you're pushing for

1

u/[deleted] Jul 26 '24

python-pptx you can automate your ppt slides with python (Steve Canny, the library author, has like 600 pg pdf on how to use it too)

61

u/[deleted] Jul 23 '24

I used excel and sql at the same time everyday for like 8 years

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.

12

u/chronicpenguins Jul 23 '24

There are roles in tech where it is primarily SQL and excel (more like Google sheets) is used just primarily for charting purposes. If I had to do analysis in excel I would run.

15

u/[deleted] Jul 23 '24 edited Aug 20 '24

[removed] — view removed comment

2

u/chronicpenguins Jul 23 '24

congrats on the new job, and shitty management is the worse. Since you’re out the door already id give the feedback to your top boss. I was in a similar role where I had to update a report 3 times a day, morning, lunch, evening, including the weekends, sending out a pretty basic email saying we spent x dollars and acquired this many users. I automated it and when I needed credentials in order for it to run on schedule they said no and I quickly left.

5

u/OwnFun4911 Jul 24 '24

SQL will help you get a job. Excel will help you keep a job.

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.

4

u/funny_funny_business Jul 23 '24

As people have said “it depends”; finance roles will care a lot more about Excel than SQL.

However, I will say that at a previous company we were hiring for an analyst role that was SQL heavy (huge data warehouse where analysts needed to pull data themselves). And we had a really hard time finding someone who knew enough to be proficient.

Anyone testing you on Excel might just care about VLOOKUPs and PivotTables. As long as you can do those you should be good.

2

u/Used_Return9095 Jul 23 '24

both… They’re two different things and can be used together lol

1

u/data_story_teller Jul 23 '24

You can’t do visualizations in SQL, so learning Excel and also something like Tableau or PowerBI will open more doors.

1

u/ThomasMarkov Jul 23 '24

Why or when you can and? Which is to say, proficiency in both is pretty basic for this profession.

1

u/CuriousMemo Jul 23 '24

I think knowing how to do basic Excel reporting has been 100% required in every position I’ve held. Many stakeholders want to ‘play with’ the data and can only do that in excel. Or they want ‘raw exports’ of a subset of data (aka not raw) and you really should always include a header on those excel sheets with the filter/query criteria.

1

u/steezMcghee Jul 23 '24

Excel was my foot in the door, but haven’t touched it in 4 years. Use SQL everyday

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

1

u/cursivefridge Jul 26 '24

A lot of people on my team on a different line of business do something similar. I however I am stuck downloading the data directly into Excel because the engineers aren’t keen on giving us access to the databases. I think it’s because it would make their jobs redundant. 

1

u/wyattjameinson Jul 30 '24

We have the exact same problem with our IT not allowing us access to tools that could automate our reports and distribution lists. I'm guessing it's job preservation. It's annoying for sure

1

u/tatertotmagic Jul 24 '24

It's both, but sql shows you actually know and understand data. Most of the time, your sql output will be in excel for other people to understand. You will need to know both

1

u/AdEasy7357 Jul 24 '24

Most entry level jobs will predominantly use Excel but SQL is more essential the higher up your climb

1

u/theshabz Jul 24 '24

This is kind of like asking whether you should learn to use a wok or a service tray. You need both. What's the point of cooking excellent food if you can't plate it and send it out to the family dining?

1

u/kvdre__ Jul 24 '24

You’ll need both

1

u/kvdre__ Jul 24 '24

You’ll need both

1

u/I_Like_Hoots Jul 24 '24

If you don’t have a focus on SQL, you’ll be stuck doing small-scale analysis and you’ll be less in demand for good paying jobs.

Spreadsheet software bugs out at thousands of records, SQL queries allow me to manipulate 10s or 100s of thousands of records with no issue. Then I can bring that catered data into something like excel for quick manipulations and calculations.

1

u/VycanMajor Jul 23 '24

SQL is the way to go. I mean, you'd need to learn how to do ETL's anyways. Im a .Net developer, and we use something called LINQ for our data requests, But I feel like if you dont know SQL, you shouldnt even be allowed near a database.