Data analytics case study tomorrow for an interview - any tips/suggestions??

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

Why did you wait until now to ask

like

Know what a RDBMS is and everything related. Know VLookups, HLookups. Have a fundamental knowledge of statistics and related sampling methods; also know regression and cluster analysis but not super important. Basically be pretty good at math, have a base of programming knowledge and an interest to learn more

like

GF has offer and they've got an opportunity in their D&A group, thought I'd give it a shot. Best case scenario IMP

like

Am I the only one that find hilarious someone referencing Hlookups and Vlookups for a data analytics interview? I'm more in the predictive analytics side of the industry, and even so we never use excel in the data staging phase (it's all about SQL joins for us)...

like

Now my $0.02: when interviewing folks, I always ask them (after a 1 min intro about a random client/business issue) to walk me through all the steps of an engagement and how they would do things. Given my experience, I always push people to spend a lot of time explaining how they would get the data (even brainstorming about secondary data), what kinds of tools/techniques they're familiar with for data preparation, how they'd model the business issue (what kinds of variables they'd use, performance metrics...), and finally how they'd document the project (paying special attention if they know the basics of model risk management). Here and there during the interview I'd throw a few technical questions, like: explain in simple words what missing imputation techniques you like and why, tell me what's the difference between an inner join and a left join, explain what's backtesting, what's your favorite R/Python package/library and why, etc.

like

They used their past 3 engagements, summarized them into 3 paragraphs and asked questions I'd ask, data I'd need, what analyses I'd run. Did well, but not great. Really enjoyed meeting the team & hope I get the opportunity. Thanks for the input here

like

@D2, that's really helpful. Looking into those now (I'm a wizard at excel, but don't do much outside of it. And only use it within financial analyses)
@D1 because I found out Wednesday, sent an email asking how to prepare and was waiting for a response/other excuses lol

What firm do you have this interview with ? Another big4

Same company, office in western europe

IMO*

Related Posts

Does anyone from recruiting knows about candidate matching technology fast enough to keep up with the high volume resumes (million resumes a year)?Or bots that would proactively search for candidates?

like

Hi fishes,
Need your thoughts.
I am done with my client interview and it went well but they are asking me to come to gugaon location.
I am from Bangalore location.
I directly said to client that I can't since I have my family here.
When I inform this to my manager he is saying how come u say like this to client.according to kpmg policy u need to travel to anywhere to work.
This is not good right. What should be my reply to the client in such a case and how to handle manager on this?

like

As everybody tells u will get more offers during the last one month of notice.

My scenario is i have decent offer but i dont like to join there because of location issue and im looking for jobs in new tech where i have less exp.

Considering this even though if i have less knowlege and if i perform a decent interview process will i get offers at the last moment?Is the offers during the late notice is given based on as he can join early even his performance is average during interview. Pls share

like

Beginning to consider going in house (4th, corp) - I really haven’t thought about what I want, partly because I’m not sure what’s out there/attainable. Is it a bad idea to start by applying to a couple positions that interest me and seeing where that gets me? I’ll of course prep for the interviews but am afraid to burn potential bridges if I ultimately decline because I’m still figuring things out.

like

Has anybody recently hired a professional resume writer? Was it helpful and in what ways. It would be great if you can share. thanks.

like

In person corporate financial analyst interview questions? Suggestions on what to bring?

like
like

Been 2 weeks since the final interview...and nothing has happened yet, not even a reference check. Is it a bad sign? Bay Area

like

Anyone on here working at Credera? If so what's the second stage interview like?

like
like

I’m going through the interview process with B4 for senior audit position. My salary expecting are around 85k but EY and Deloitte recruiters told me that it was pretty high. Is that true? (Miami location)

like

Hi Guys, I am notice period with 30 days remaining, having 12+ exp in java, spring boot, microservices. Need the reference for applying to major banks like Credit Suisse, Master card, Barclays, Citi, Deutsche, BOA, JP Morgan etc..
Kindly help...

like

Western nc CTE interview questions? How do I prepare?

like

Hi everyone! Any BCGDV folks on here who can help me prep for a product manager interview? I had an intro call with the recruiter and he mentioned that I was supposed to do a presentation on Growth, monetization strategies. Can you please connect with me or comment below so I can reach out to you? I am super passionate about landing the job and any help would be greatly appreciated. Thanks a ton!

like

Does anyone have any tips on how to reach out to a recruiter? Is it weird to just email someone I found online with my resume?

like

Interviewing for a SE lead role for a SaaS FinTech company. Any ideas what a good OTE to shoot for would be? Looking like 130-140 seems about right with 3 YOE.

like

Will be recruiting with Deloitte and Google — tough decision because I like both, any thoughts on how to compare/choose between the two? Thanks!

like

Does anyone know how long it takes to hear after interview (entry level TDP) from Accenture Ottawa.
I gave my interview on Friday and its Tuesday now and I haven’t heard anything from the recruiter.

like

I’m interviewing for a community manager role with a creative agency tomorrow. Anyone have tips specifically for CM/Strategy roles?

like

Lowes India is hiring across multiple positions!
Also they have launched a cool referral programme ;)
In case you are looking for a job opportunity for Analysts/Software Engineers/ Data Engineer at all level and also some managerial role, please DM.
Happy to refer! In case of knowing the company before applying- can help on that too!

Happy weekend in advance!
Tredence Inc. Musigma Tata Consultancy Tiger Analytics Publicis Sapient Deloitte Accenture EY

like

More Posts

You talking to me?

Post Photo
like

As someone who has spent 7 years in the recruitment field specifically helping those who originated in audit or partnership tax compliance I’d be happy to answer anyone’s questions! Please only those that live and work in NYC.

like

On H1-B with approved I-140, currently looking out for State & Local Tax Senior/New Manager opportunity. Kindly share the leads, thank you.

like

I think I’m about to get my first experience of getting in trouble with a partner for work that I actually already sent for review and followed up on multiple times (and brought up during calls). Stay tuned… 😑

like

Daily dose of cuteness!🐶🐶🐶

Post Photo
like

You’re given 5 minutes where your dog can speak/understand English. What would you say to him/her?

like

"It's a good thing you're here officer, because a crime has been committed" 🤣😳

Post Photo
likefunny

Sharing our Louie…

Post Photo
likeuplifting

Anyone went through the Immigration and H1B transfer process recently? How much time does it usually take after acceptance that the Immigration team reaches out?

like

Hey fellow designers,

Is anyone else facing the brunt of working in a service based company and trying to move to a startup product company being dragged down by the 90 days notice period.

I have had a couple of interviews with good startup product companies where the main issue is my 90 days of notice period. Most startups simply run away at the mention of 90 days NP.

Even established product companies shy away at this. Has anyone recently switched despite this long a notice period?

like

Just curious- how many 🐠 on this bowl are on OPT/ h1b (H) and how many have GC/citizenship (C)?

post tax(Roth) or pre tax 401k? which is the better option for us on h1b?

Why does everyone say the work in FDD is so much better than audit? I’ve been in the group for a few months now, and it seems to be just as bad if not worse.

likefunny

User experience mgr salary? I support six product teams and eight reports. 20+ years experience

Got a personal email from HR asking to evaluate our executive team’s performance. Thinking this is a no win situation.

likefunny

What's a good way to find a mentor in this industry?

like

Looking to hire lawyers for my EB1A application. Talked to a few and really enjoyed my conversation with Xu Law Group. They seemed really knowledgeable and know what they are doing. Their reviews are glowingly positive but I don’t have any personal references.

Looking to see if anyone has worked with them or other positive experiences with another immigration law firm. #workvisa #h1b #eb1

like
like

What makes a bro?

likefunny

What is the best way to reach out after not getting the job to ask for feedback? Do interviewers really ahve time to provide feedback for the candidate they didn't go with?

like

Additional Posts in Consulting

Looking for suggestions on a good app that will notify me headlines related to O&G industry - in the past, I’ve just manually searched under energy but would like to follow closer in future. Help!

like

Recent Grad without any home office furniture. Need recommendations on desk, chair, 2nd monitor, anything to keep me productive at home.

like

Suggestions for home office chairs? Back is killing me; I can’t take the dining table chair anymore

like

Anybody at the Westin Michigan Ave this week? Drinks?

like

Hired as SA1. if my utilization is low for round table but I’ve gotten good Snapshots will I go up to SA2 or SA1B, which I don’t want of course.

like

How are Accenture Skills Interviews? Are they hard? Super technical?

like

How do you save taxes & etc . If you are making more than 175K(bonus included, no stocks).
Max out 401 K,
Can I put money in IRA?
Is there any other options to save taxes?

like

How does one "coast"? I've heard several people say they are coasting for a year because they aren't up for promo. Sit on the bench for a while? Not answer weekend emails?

like

Friend wants to do myrtle beach for his bachelor party. Is that place any good

like

Looking for book recommendations; any favorites? Interested in both fiction and educational/self-improvement (for example, investment / finance books, time management, etc). I feel my vocab is...

like

I have an alarm at home, but I feel like I'm not truly awake until I'm walking down the concourse and someone yells, "SHOE SHINE!" at full volume in my ear.

likefunny

It’s been 9 weeks since I had to go to bed on Sunday nights with 4AM alarms, one of my far and few happy moments in these uncertain times..

like

How was your first year experience in your consulting firm?

like

Utilization director told me today that the layoffs won't affect me. My heart goes out to everyone that had to hear otherwise. Here's to hoping y'all find something better and prosper.

like

Best consulting companies with exposure to the blockchain / digital assets space?

like

Monday Status Report: Flight upgraded to first ✅. Aforementioned flight delayed 1.5 hours ❌. Partner canceled 6pm meeting ✅. Hotel upgraded to a suite at the Ritz ✅✅. Not bad for a Monday, not bad....

like

Getting into Mt Biking. Anything I need to know? Gear that’s must have. Bought a Specialized Fuse Fattie/29. I have the option to stay with the fat 27in or change out for reg 29. Recommendations?

like

Does anyone from recruiting knows about candidate matching technology fast enough to keep up with the high volume resumes (million resumes a year)?Or bots that would proactively search for candidates?

like

Whoever took the shoes off on my plane please put them on 🤢

like

Flight from Chicago to New York returned back half the way due to the weather!!! Usually shit like happens on Thursdays. Mother Nature is angry this year.

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

Scan your QR code to download
Fishbowl app on your mobile

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