{ "media_type": "text", "post_content": "How to prep (and what to expect) for an interview on Excel, SQL and R? I have a final round coming up which includes 30 minutes assessing my “technical skills” which the recruiter implied would be the skills listed on my resume (these 3 were also listed in the job description). FWIW I listed my R skills as “basic” since all I’ve ever done is a short online course, and for SQL I’m fairly comfortable with your standard queries (JOIN, WHERE, ORDER BY, etc.). This is for a strategy role.", "post_id": "5fbc6ffb2c2367002b7e3b70", "reply_count": 9, "vote_count": 5, "bowl_id": "5ae4a4f739e7cb001391ec8b", "bowl_name": "Consulting Exit Opportunities", "feed_type": "bowl" }

How to prep (and what to expect) for an interview on Excel, SQL and R? I have a final round coming up which includes 30 minutes assessing my “technical skills” which the recruiter implied would be the skills listed on my resume (these 3 were also listed in the job description). FWIW I listed my R skills as “basic” since all I’ve ever done is a short online course, and for SQL I’m fairly comfortable with your standard queries (JOIN, WHERE, ORDER BY, etc.). This is for a strategy role.

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

Give me the lambda calculus on the following query: SELECT * FROM * WHERE * = *; 😂 In all seriousness, prepare to talk a little about how you would optimize queries and make things SPROC friendly.

Post Photo
likefunny

Then yeah, you should be fine. Just make sure you know how to approach getting the data you need in an analysis friendly format.

Wing it and hope for the best

like

🤭

Some things I might ask. Write fizz buzz in R. What are your favorite r packages? How do the apply functions work in R? What is the difference between the where and having clause? Define a left join, inner join, and full outer join. But for strategy I’d be more worried about killing whatever case interview you might have.

Thank you very much!

like

Related Posts

Is anybody else having a really difficult time hiring for employees to work in the office full-time? My boss is against working remotely or offering a hybrid option. I’ve never had such a hard time filling roles. This includes finding a new in-house recruiter.

like

Has anyone left FDD with only 6-8 months of experience ? If so, what type of roles did you exit too? I’ve been here for about 7 months and can’t fathom sticking it out any longer as for the first time in my career, my mental health has taken a significant toll. I came in with the expectation I’ll be working long hours, but I’m just defeated at this point.

like

What are the standard terms when it comes to applying for a position with a client? I rolled off a couple months ago and see a posting that is perfect.

Healthcare consultant (payers) with 10 years of experience, looking to make a move to a new consulting firm. Can anybody help with a referral? Thank you!

Who is taking the COVID-19 Shot? Do you think all teachers should?

likeupliftingsmarthelpfulfunny

Trying to do some financial career planning. Can we state firm, position and salary along with any special circumstances that raised salary (MBA)in the comments for comparison? i.e. Federal BTA, 72.5k

like

Just got a design test for a senior role asking me to design social posts, a creative concept for products they’re releasing in a few months (irl), and another conceptual idea for an awareness campaign. Too much for a design test? I’m truly torn. There’s already a few red flags but I can’t tell if this is reasonable or not

likefunny

What hard skills do hiring managers look for in account planning roles?

Welcome the S&C party! Say hello, and start spilling the T. Participate by listing your company, role & total comp plan. You can find a thread already started by someone in your company or start a (T)hread of your own. Have fun! Be informed!

like

Any experiential shops hiring in the Denver area? Or know of any places that also do events/pop ups/production? Fabrication would be a plus. Seeking PM account or producer roles. Thx!

We’re hiring for all levels of corporate (finance, M&A/PE, cap markets) for the NY office. You can live in any city you’d like as long as we have an office there with the understanding you’d be working on NY matters. NY V50 DPW/Milbank scale. We respect vacations and weekends and a 240 hr month is considered to be on the most extreme end of the hours spectrum. DM for more info.

like

What should be the compensation for a Principle Consultant role (YOE - 9.5) in Informatica Corp. in India? Please help with what should be the minimum Base Pay and Performance Bonus?

Call out to internal auditors, which industry focus, how is the pay in comparison to assurance in the same city, also, talk about exit opportunities?

like
likefunny

That feeling when your referral with less skills and experience gets a higher base than you 🤡

likefunnyuplifting

Anyone work at Visa here? Want to apply for a position with info sec team and would like a referral. Don't want to get stuck in ATS black hole.

Workday exit points that are similar in salary?!

like

If anyone wants a referral to Apple send me a DM!

likehelpfuluplifting

How long should I wait before applying to other firms? Started this past September as an analyst out of undergrad and haven't been staffed yet. At this point, I'm considering my exit opportunities.

like

How long does it take to get your referral bonus after your referral has joined the organization? What would happen if the person you referred is already in Deloitte’s database?

like

Additional Posts

Good happy hours in NYC?

like

Long flight ahead - not sure if I am more excited about the vacation or the sky miles!

like

Choosing to be homeless for the next 3 months. Pad rented out to airbnber. Hopefully my project will keep me on for that time. I’m single, no kids and homeless. And loving it. #homelessconsultant

like

Don't you guys get frustrated when we get emails from leadership saying how well our project/firm is doing, but all we get as reward is their useless thank you email

like

Team dinner? More like, Let's sit around for four hours and do nothing while the introvert shrivels up and dies.

like

When your senior goes back and forth on what he wants and not so clear on what he wants so you are just changing your script every 30 minutes. Make up your mind.

like

Aaaand thats why I kept negotiating my employment contract to have an exit clause in case SPG gets acquired...#priorities

like

Is it possible to commit to leading bible studies in Thursday nights every week?

like

Just had a performance review with my SM while drinking Jack and Cokes in the Delta lounge... As God intended it to be.

like

Lots of TSA pre mentions. ATTN/FYI PwCers - firm will reimburse for global entry. #themoreyouknow

like

When you get drunk at dinner and your manager paints your nails...FYI I'm a guy. #teambonding

like

How much does everyone give their doormen/women as a Christmas bonus?

like

Real talk: wtf is MBB and why does it walk on water?

like

currently taking applications for a travel buddy. role description: hang out with me when my company sends me to countries where I know no one. qualifications: preferably a male, attractive.

like

Canada thinks it's so cool but fails to realize it's financially owned by the US, politically by the Brits #whydoineedaworkpermit

like

Just got a gift from a co worker. Guess I'll make that my holiday bonus by a degree of separation. Thanks Accenture.

like

Don't know about the rest of you but my new year begins today. Plan on bleeding the bank account starting today 🤑

like

I come home and the only food in my house is ice cream and beer. I've been doing the conference-call-but-still-in-pjs since 5am (west coast life). Ice cream and beer for breakfast?

like

Fishbowl, y u no mark notification as 'read' when I slide right on the notification screen?

like

Upvote or share a story if you've had a random hookup on a travel week

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal