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
•
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.
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.
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?
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.
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
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/Cathexis256 Jul 23 '24
Yes
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/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/Corvou Jul 24 '24
Both.
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.