Too late for a M to learn SQL and gain utility from it on projects? Don't do much modeling any more. How/why is it better than Excel? (Programming virgin)

like
Posting as :
works at
You are currently posting as works at

Excel can't handle larger data sets. SQL is also more adept at managing multiple related tables/spreadsheets

like

Never too late to learn. Sql and excel are very different tools. Sql is a language to query Databases. Its good for large data sets and more complicated analysis.

like

SQL is mainly for pulling cuts of data from a data warehouse and doing some basic aggregation or cleaning. You don't really use SQL for the same things you use Excel for

like

C1, if you routinely work with big datasets you use SQL for almost all the same things you do in Excel. It's more than just a query language. Has fairly robust calculation, data manipulation, and aggregation/reporting capabilities.

like

It's always good to keep your feet on the ground with technical skills. If you ever find yourself out of a job, knowing how to code and how to work with data will make you quite marketable.

like

A good goal if you just want to get the hang of SQL is to read in 2 tables and join them by reproducing a vlookup (and then see how much easier it is to do the match on multiple fields). Do a left, right, inner, and outer join and understand the difference.

like

Select top 1 * from employees where skill like '%sql%' order by hiredate; the answer lies in computational capacity. The access & excel limits of ~1M records is not enough for most data analytics requirements. Also most IT dept have a sql data hub these days that can crunch data 10000 times faster then a laptop. Therefore dumping 5M records into a sql table is preferred to 5 access databases or text files or other such data transfers.

like

OP depends on the data, but it probably would not be a one step solution as in excel. you can however build everything you need. If you have less then 50k records, excel would likely be much easier in this regard. If you have over 2Gb of data It would be worthwhile to have it in sql. You can also run ETL in any number of programming languages on top of it including vba. My preference is python as it has prebuilt every function you can possibly imagine... but it's also not the work we should be doing at the consultant level. This should be outsourced to IT support. In any case, I vote for learning sql. It's not going to take long and it's not going anywhere.

like

SQL is really easy to learn too

But tbh if it's not something you want to do day in day out I wouldn't invest too much time into it at your level. Basic understanding is great especially to understand the limitations and effort it takes for your minions to complete asks, but beyond that it's like anything else a good skill level is only achieved with training and experience imo. For the basics Google learn sql the hard way. Great crash course

Slightly tangential...Almost killed an M before because he pretty much wanted the entire enterprise warehouse dumped into an excel sheet and didn't get that frequent changes to the outcome dataset required the team to pull late nights for no valid reason besides his ignorance

I'm a M and learned SQL as an Analyst. It's extremely helpful especially now bc I can help my analysts troubleshoot. It doesn't take that long to learn enough to be effective.

I once had to do an overnight Tableau extract because my M wanted to review the data offline. Then when the data changed she went all ballistic on me for lacking attention to detail.

Thanks all. D4 - that's interesting. Obv there are variations but how long would it take to get the hang of it? And what's an example problem that could be solved with SQL when applied to a database?

Yeah I agree SC1, hence the q. I used to be pretty good with excel and VBA back in the day but all these young bucks are biting at my feet

Useful content. Thanks. So SQL can do volume sorting and cleansing of data. Does it have the same arithmetic agility as Excel? E.g. Can I construct a revenue model for a passenger flight or can I calculate the MWh yield from a solar array? (I can do those in Excel using sumproducts, matrix multi, compounding/discounting variables. Does SQL have similar functions?)

OP, standard SQL works on records, lines, and aggregation. You can do all those things, but the can get cumbersome or convoluted with multiple steps/interim tables required, especially when you're not 100% sure what you're doing when you start.

Related Posts

Why are the Vault practice area rankings so inconsistent with Chambers?

like

Any tips? Dealing with resourcing issues for one of our largest clients. We have enough hours, just waiting for more experienced team members to be hired to complete it. We’ve reprioritized work so many times to get what we can done with the team we have, but still have important items waiting to be completed with more Sr. Folks. We’ve also borrowed from other teams, but it doesn’t cover up the fact we could be getting the work done faster with the right team. Advice for dealing with the client?

like

Anyone know what comp and wlb are like at FAANG companies? Is the wlb worse than other industries?

like

Finally got our list of new hires/interns - all 10 are male. I’m so frustrated because all of our partners and MD’s that are involved in recruiting are also male so of course I’m thinking there’s some

like

Without naming your country (or home state if you’re from ‘Murica), what is your country/home state famous for? I‘ll go first: Beer, Fries, Waffles

like

McKinsey & Company Any McKinsey & Company consultants willing to refer me to a finalta role in London? Happy to chat and state my case!

like

Hi, What's the scope for Java developer in Tata Elxsi?

Hi All, My joining date is older in offer letter. I did not get updated letter with new date. Just some screenshot from recruiter in some drop down. When will we get virtual onboarding link. How do they know whether we joined or not.

like

Anyone go through background screening with HireRight? I submitted my background check on Monday, and they literally couldn’t verify 2 of my employers , the first employer being my current one! Wtf is going on? I had to get my w2’s and patchchecks to validate, but I am hoping that my background check doesn’t take longer than a week…curious if anyone has gone through HireRight before

like

Has anyone traveled outside the US to get visa stamping? What’s the average admin processing times after the interview?

Looks like appointments are available in Mexico City but don’t want to go there and get stuck for an extended period of time.

like

How is GlobalLogic as a company? I see too many +ve reviews on glassdoor while all -ve reviews on mouthshut. Please help!

YOE - 10, role: project manager

like

Does SAP gave any gift hampers as it is completed 50 years

like

Planning on doing real estate law after a year in construction litigation. Will real estate firms value my experience? Should I stay in construction litigation for longer?

like

Anyone willing to refer me to Bain for the Netherlands region. I have 3 years of experience in deals/transaction services. Happy to share more details.

like

Looking for a new opportunity. Am very technical but have experience talking with customers. Any help/networking opportunity would be highly appreciated.

like
likeuplifting

Other than law school rank, what do recruiters/hiring partners care about most on a resume? Specifically for 2nd/3rd year lateral associates.

likehelpful

What can I do with a communication degree and a minor in human Resources

Additional Posts in Consulting

I feel like I am getting more judgmental and a bit less compassionate as I get older. Can anyone relate, and any tips to help stop this way of thinking?

likehelpful

Looking for a good headhunting agency in Chicago specializing in MBA placement. My friend is an international student from a mid-tier school. This political climate is not helping internationals :(

like

How difficult is obtaining an AWS cloud practitioner cert if you’re not particularly technical?

like

Has anyone seen the article on Cognizant employees serving as moderators on Facebook? Absolutely brutal...

like

Is there anyone from McKinsey public sector available to tell me a bit about the work-life balance etc?

like

I want to get my PhD, but all of the programs I want require a full time commitment for the first year. What are my options? Is a sabbatical an option? Or would I have to straight up resign? Utilization notwithstanding (I’m a GPS consultant)…is it possible to go part time? I completed my master’s full time while a full time Deloitte consultant. I know school can be done, but for PhDs they usually want you to also work as a TA. Additionally, I am not interested in online programs.

like

Fellow runners - I’ve been running 3-4x per week at about a 20-25 mile/week for the past year or so.

My questions: (1) does it make sense to take a week off and let myself rest or do other workouts (i.e. cycling) and (2) I’ve been running with the same shoes since August last year - make sense to get new ones?

like

For those with IBS, do you prefer WFH, Hybrid or in office?

like

Any 🐠 fam have an ergonomic chair at home and have a recommendation? Currently looking at Steelcase “Think” and Knoll “Regeneration”? But also, can’t justify the cost. 😱

like

And with that mouse click, the 6 figure student loans are paid off. F you Fedloan, and all of your BS over the past 3 years. Freedom!

likeupliftinghelpfulfunnysmart

The manager who works for me gets married on Saturday. I've known him 1 month, but really appreciate all he's done. He's flying tomorrow so can't get him a bottle of booze. Need gift suggestion asap!

like

APAC Kearney employee here. Have an opportunity to shift to Bain, but have been in the firm for only a few months. Any thoughts? Should I shift? Or stay back longer?
Shifting will push me back 6 months.
Any advice is appreciated. Thanks!

like
like

Most embarrassing example of "you're still presenting" you've ever seen?

like

Anyone daytrading? If you can determine a good low and good high, you seem to be able to make decent gains. Halliburton’s been doing well for me this week, but would love other recommendations!

like

Those who took the AWS CCP exam - do you get questions like “how much does a storage type cost per GB per month” in the exam? Trying to figure out whether this level of detail is required to be memorized for the exam

like

Feeling really burnt out, on H1B. Can't just take a break from work, also no utilization in this environment is detrimental. What can I do?

like

Can anyone recommend a lawyer to write up a prenup?

like

Sometimes I read the stuff you all say on this app and think you have a WAY different job than I do

likefunny

I can't stop thinking about work.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal