Hey fiends, HELP needed here. I have an interview for an industry strategy role and they planned an "Excel Case Interview". Any insight on how to deliver actionable info from a dataset in 45 minutes?

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

Use null hypotheses - easier to demonstrate against. Descriptive statistics (use the analysis toolpak). Also - who doesn't love a good pivottable and pivotchart to visualize those hypotheses? Use IFERROR to eliminate div/0 errors.

like

Spend a lot of time developing actionable hypotheses that can be tested by the dataset presented. Working against hypotheses will keep you focused.

like

Even better if you can turn the dataset into a workable model to run sensitivity analyses that would update dynamic graphs.
Also maybe do some prework on issues the company or their industry is facing. Pulling in external perspective would be flashy.

like

..... 45 mins ;)

like

Incidentally - conditional formatting... an underrated function that can really make bland data visually appealing

like

Be hypothesis driven and use data to support it

like

45 minutes.

like

Thank you guys I really appreciate it!

Second conditional formatting

Related Posts

Hey everyone!
I’ve recently accepted a new position recruiting Pharmacists from all over the globe to come to Canada and work for our business units.
I’m looking to speak to literally anyone and everyone who is willing to chat and share information.
Your pain points, complaints, day to day life, experience with exams, certification etc.
Especially anyone who has immigrated to Canada to become a Pharmacy Tech, Pharmacy Assistant, Pharmacist etc.

like

Wanting to switch from my corporate job to a remote job as medical virtual assistant. Any recommendations where to apply?

like

So I’m about to start my interview process for Capital One next week for a Senior Financial Analyst position. My recruiter going give me a prep call on Friday but I wanted any advice that recruiters don’t tell you during the interview process. Also I wanted to ask if Capital One a decent place to work at. I will be working at the one in McLean Virginia if that helps.

like

What firms are hiring with a DC office?

like

Can anyone suggest what's the interview process for Amazon in Tamil Nadu, Karnataka or Andhra Pradesh for a Data Engineer role.

What technologies should I be familiar with in order to crack the interview. Is data structures and algorithms a must learn to crack a data engineer role?

I want to prepare for data engineer interviews, I'm currently well experienced in Python, SQL, Informatica and familiar with ADF and I have 1+ years of experience in the same role.

Has anyone interviewed or worked for Roc Nation? Sales partnerships

like

Did anyone gave interview for Research Consultant in Scotiabank?

like

LTI-Larsen & Toubro Infotech is Hiring Cloud Profiles!!

**Interested can DM Email with Job ID**

Np with 30 days will be Preferred!!

Post Photo
like

Best tips for studying/prepping for case interviews? I am overwhelmed.

like

There's lots of individual questions about comp, so maybe it's best if we have a "master list" to pin. Reply and copy/paste in consistent format.

Title:

YOE:

Education:

Location:

Industry:

Company headcount:

Level: (Highest HR position, IC, manager)

Management only: Span of control (direct and indirect)

Pay (incl incentive):

likesmart

Hello buddies I am looking for a C/C++ referral in Infosys for @indore location. Can anyone please refer me for the same or any C++ based role in Infosys .. Thank you all in advance.

Looking for a Remote role - I am an experienced Senior Payroll Specialist with sequel experience. Interested in Remote HRIS and Implementation as well

like

Anyone else notice a trend with the mass amounts of layoffs in tech? Why are all their resumes so jumpy? Not like 2-5 years jumpy, like few months at a time jumpy? But still can land a position with similar tech giants? IMO, lots of these people get hired by their rich friends, stay a few months before someone realized they aren’t qualified and were just a recommendation from a current employee. Then repeat that process over and over until your company is down 50%

I’m currently interning in information and cyber security for a large bank. I would love to contribute to peruse the field of cyber security. However the full time offer for this large bank is around 80k. Should I pursue other opportunities or should I take up this offer? How would the hiring freeze effect the field of cyber?

like

Hey Amex Fishes!
I wanted to know if Amex has tendency to Ghost the candidates? I haven't heard about the results of my previous round in days and obviously no news about next round as well! Please help. TIA.

like

How much KPMG offer for a Consultant position? KPMG EY Delloite PwC

like

Should I stay or should I go? Hoping to get some insight from those that went before me. I am a 6th year call working at a top20 firm in private M&A. Two kids and am in the position (continued below)

Hi all, I got laid off from my current company (product based) a month ago. Since then I've been looking for new opportunities. I got an offer from a good product based company with a good package and also my current company offering me rehire with promotion and a good package. I have a good rapport with my current manager, and he played a major role in offering this rehire opportunity. I'm confused about making the right decision here. Kindly share your views. Both offers are pretty much same.

likehelpfulfunny

SOS
What are some strategies or tactics you have developed which are very successful in small markets (I'm talking SUPER small)? I feel like I've thrown all my darts and some markets still can't find talent.

Some things I've tried, here in Canada:

- non-profit/employment centers
- indeed headunting
- getting field/hiring managers to post around town
- getting on local FB groups
- local schools if there are any
- physical posters
- newspaper/old media (not great)

Ideas needed 😭

likehelpful

LTI Hiring # JAVA #Python#Informatica#DOTNET#QA Automation testing

Let me know if you are interested.

Post Photo
like

More Posts

I’ve been using an app & ovulation strips to track my cycle. TTC for the last 6 months.

NEXT STEP: my husband to do the semen analysis & I’ll go to a fertility specialist.

Does anyone recommend anything else in the beginning chapters of family planning?

It’s definitely stressful & we were supposed to go on our honey moon that got canceled this year, so it’s disappointing to not be able to travel this year as many have told us that’s when they were relaxed & successful. Thanks for any tips!

like

Anyone know of any building owners looking to work with a start up and sell or lease their building to?

Hello Sharks, Just came across intresting post.
Do you agree..? Any thoughts..?

Post Photo
like

Looks like a promotion could be coming. Wondering what I might expect UX Design Director / in-house finance /Boston / 35

Making an offer. The sellers said they had 30+ people walk through the open house today, and are asking for best and final. They’ll make a decision on Monday. The list price is 775k. We were originally thinking of offering 700 to start since comps are around 735k. However, this is nicer than the comps renovation-wise. What would you all suggest we offer? We’d rather lose the house than overpay, so this concerns us.

like

I can't tell if I'm depressed, lazy, or my phone is too addicting

like

Which location come under DTA 0 Bangalore for IBM work location?

like

Does anyone have positive experiences with getting an ex back? I just went through a breakup which he initiated, and I know I deserve better but one part of me is still convinced he was my soulmate

like

Hello Folks!

I am a business analyst at a travel company and would like to transition into product management at one of the big five, can someone help me how i can apply or if you could refer me.

like

Hi fellow companions, need likes to DM

likesmart

Going back to work next month. Have a full time nanny but feel like even that isnt enough. I work all sorts of timezones. Europe has my morning, Asia has my evening. Nanny 9-5? 7-3? 10-6? No clue what will work best and don’t want to be inconsistent with her. Any advice on the return?

likehelpful

Any recommendations for a good mover for cross country move? It’s about a 1000 sq ft one bedroom so not a ton of stuff but can’t use PODs due to building requirements

like

Any good lululemon alternatives for “dressy” athleisure for men (shirts/pants)?

like

Anyone know if all the layoffs have been completed/announced yet? Honestly, I love my job and there's nowhere else I'd rather work. Want to know if I can exhale yet.

Hi,

Is there any shift allowance for UK shift??

My chair is so uncomfortable I’m ready for a new one 🙄 this one sucks!!

Any recommendations pls!

Post Photo

Hi all,

I recently got offer from Airtel x labs , bangalore.
Can anyone let me know how will b wlb, hikes, working style at airtel.

Thanks in advance!!

like

Thanks for the support and encouragement fam, wouldn’t be at this point if not for the support I have received here

Post Photo
likeuplifting

Any other big 4s have happy hour starting at 3 PM on a Thursday? #justcurious

like

Additional Posts in Consulting

When it's been a day so you order steak. 🥩🍷

like

If you're going to attempt to be a smarta**, at least try to be both smart and an a**. Don't be just the latter.

like

Just wanted to say that this is the second Saturday in a row where I took an afternoon nap, after a VERY long time, and I'm here to recommend that to everyone. 5 ⭐

likeupliftingfunnysmart

How do you deal with being capped at 40? I have a feeling that despite what leadership says, it has to hurt you at YE

like

Free deposit of 50% of Elite nights from last night for Marriott Members. Sounds like Marriott really wants us to start going back and staying in their hotels.

like

We're going to recommend option 1 on our list of 4. Anyone every recommend option 3?

I hate what Delta has done to the "shuttle" product by brining it to the main terminal at LGA. Screaming obnoxious children everywhere 👺

likeupliftinghelpful

Anyone who has taken firm sponsorship for MBA studies and had to pay it back post graduation due to a career change (i.e. decision not to come back to the firm post graduation)? If so, how did you manage to pay it back?

like

Any recent H1 transfers or certified LCA’s for EY? I would like to know about the current timelines and success rate for LCA and H1B transfers in premium processing.

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

Can't wait for greenlight to apply for my CSR and get a Tumi bag

like

Anyone ever been promoted from C to SC in one year?

like

Hey 🐟 sometimes there's a lot of negativity or pessimism on fishbowl and I wanted to create a new bowl where people can share all of their happy moments to remind others to look on the bright side ❤️

like

Management consulting = management Con ! Do you sometimes feel like you're pulling off a con 🤔

like

If your entire team went on strike and stopped showing up/doing work to get higher pay, better "conditions", etc. what would happen to you? Get fired? The firm acquiesces and fulfills your demands?

like

Dear fb: please don't email me. #unsubscribe

like

How does severance typically work when you get fired? Is it a lump sum?

like

That guy who puts his carry on sideways in the overhead bin... hate that guy

like

Heated hotel bathroom floor = one feature I wish every hotel would adopt. What's yours?

like

Hi
Is there anyone here looking to hire a Strategy consultant? I've got previous experience across public and private sector and I'm now looking for a new challenge with one of the top consulting firms in the UK.
Any help would be much appreciated.

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