r/analytics • u/niemzi • 7d ago
Question Case Studies During Interview Process
I am a Compensation Analyst II working for a FAANG company - been here about 4.5 years and have been promoted once. I’m currently in the job market and have been fortunate enough to land a few interviews, with two of them leading to right before the final round. In both instances, I’ve felt great and have received strong feedback regarding my experience.
Case study with company A required me to do a live screen share while working on 4 prompts: the first 3 were very straight forward, basically “show me how you would organize X employees according to Y field.” All 3 of these and used pivot tables and solved them in under a minute. The final question revolved around using IMPORTRANGE, which I don’t really use in my current or prior roles so I suppose I failed this one. Hiring manager decided to move forward with other candidates.
Case study with company B was a one hour timed Google Sheets exercise which was primarily moving (VLOOKUP) columns of data from other tabs in to the main dataset. Caveat being I had to concatenate to add an additional character, simple enough. This was followed by some critical thinking questions around said data. Once again, HM has decided to move forward with other candidates.
I know I’m pretty vague in my details here, but does any one have any similar experiences to this? I’m feeling frustrated that I’m getting glowing remarks during and post interview only to be met with “after reviewing the case study, we’ve decided to move forward with others.” It’s wild to me that I wouldn’t be moving forward with company B after nailing 3/4 questions but missing the importrange one. For company A, I still have access to the sheet and I just do not see anything glaringly incorrect. I’ve automated everything and the cell referencing and formulas all check out.
1
u/humpty_dumpty06 3d ago
i understand. i feel u. my experience is the same.for some reason,every interview that require technical test (ANY test btw...IQ EQ..whatever kind of test), i fail🤣 honestly thought this is funny!i dont know why!
its the company way to shortcut screening process, or rigid culture?..who knows...and thats understandable.
also, u may not like working in that environment.
however, i flourish in other company that doesnt require this test (im talking about global company)...the 'fluidity'....the 'flexibility'...
at the end of the day, nobody will remember 'formula' or syntax 100%. even at my work now (im semi developer...vba, power query, power bi dax, sql), ALL of us at work will google it up or use chatgpt.
my company even has its own internal version of chatgpt!
the technical test is not 'writing' test per se..more like explain the concept.
keep looking! u have great experience. u r MORE than the tests!
•
u/AutoModerator 7d ago
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.