What are some interesting ways to analyze people data? Preparing for a people data analyst interview and would appreciate some ideas I haven’t thought of yet.

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

Pivot table would be beyond most HR. Draw a line graph and theyll be blown away

like

Am interesting way to predict turnover is to monitor badge swipe activity as an indicator of who is taking breaks more often or longer than usual. Monitor visits to indeed it LinkedIn etc. Plenty of fun and creepy stuff you can do.

like

Without knowing the nature of the interview, the way I’d approach this is to put some kind of framework around it and then think about different analyses/metrics that could fit into each “bucket” to assess performance. What immediately comes to mind for me at the highest level is the “macro” structure (i.e. spans and layers) and then the “micro” performance, which you could think about in terms of availability (absenteeism, etc.), utilisation (break time, travel time, etc.), and productivity (some measure of output per utilised hour, which will differ depending on the type of role). Then sitting under all of this will be the cost metrics like cost/FTE for various functions, etc. Would also need to think about where satisfaction/turnover type metrics would fit in.

Not at all saying that this is the right framework and I’d want to spend more than 2 mins thinking about it (I haven’t done this type of work before) but I can’t but think that’d be a good approach to an interview like this? (Again, without knowing much else)

like

Pivot table

like

Feel like there's something missing in the question, what exactly are you analyzing or is that what you're asking? HR, you're probably looking at retention/turnover, cost to hire, employee satisfaction, employee adaption (change).

like

To piggy off the badge swipe comment, in a hoteling environment where employees work remote a lot, a measure of engagement is how often are people coming into the office. The more they’re there higher engagement.

like

People as in HR role?

Yup, HR

Draw a Venn. That'll will make their brains explode.

K1 Yeah, just looking for ideas on interesting ways to assess those kinds of metrics. Like retention based on years of experience or compensation compared to cost to hire, etc.

Related Posts

Hi all, I got a case study for a final interview and my brain is fried. Can anyone please provide a pair of fresh eyes on it? I can email/text/call.

Post Photo
like

What questions to expect in ubs UI dev interview for 4 years exp candidate. Can someone share their experience

Hi everyone! I’d love to hear your thoughts on EEO surveys during the job application process. Is it more beneficial to self-disclose or refrain from disclosing race, gender, disability, etc?

Which method is more likely to get your application noticed? Any guidance would be helpful on my job hunt. Thank you.

like

Hello Fishes I have completed 2 rounds of interview with KPMG They insist on joining in either gurgaon , Pune or Bangalore I m from Mumbai does KPMG global services have an office in Mumbai so I can insist on joining in Mumbai as base Location

How much should I ask for 6 YOE ?

like

Is the recruiter bs-ing? interviewed for a position and the in-house recruiter updated with the position was offered already but the interview went so well CONT...

Whoever said employers don’t care about grades and transcripts after your first job was a liar. Every lateral position that I’ve applied to as a 3rd year has requested transcripts. Why do we lie and tell grads that employers don’t check transcripts when they do. My coworker, a 5th yr, had to submit his transcripts also to lateral job. Side note - it speaks volume when multiple associates are trying to lateral at the same time

like

Don’t have a definitive timeline for an interview yet but want to get legwork in. Sent in an application for BCG and looking to case with someone or even a few different people. Drop a comment if you’re interested!

like

Hey guys
Is
Salesforce hiring for platform solution engineer for mulesoft in canada, I see lot of opening but not getting any call.any reason
My skill set and resume is definitely a close match

likefunny

8 final round interviews over the course of a year and no offers. I think I’m never going to be able to escape 😭.

Cant move internally can’t move externally. My firm feels like a prison.

like

I applied for a senior SWE position for Elastic over 11 days ago and they haven't replied to it.

Does this mean I already wasn't considered or is it too soon to say?

like
like

Can someone please tell me the type of work you do in PwC CMAAS ? Be specific. Considering applying to this role.

like

I recently interviewed at Facebook for IAM analyst position. The interview went very well and I was able to answer all questions and have hands on experience in everything I explained. I was rejected and I am really unsure about the cause. Please help me with a reality check, what could have gone wrong? Thank you

like

Can anyone please help me with Boston Consulting Group for my local region office? Would be very thankful! 🙏 . Short intro about myself: Had multiple MBB final rounds in last 3 years, now way better prepared. Have background in analytics at different industries

like

HI GUYS

I was learning react from past 1 year and covered all advanced concepts and few projects too and got interviewed at a firm and was selected.

Now they are asking to learn angular and work will be on angular
I'm finding angular very difficult.
I thought utilizing mu react skills soon at work

But now I'm in a fix
Is it worth learning angular?

like

Looking to have a brief conversation at with someone at OW Dubai to gain transparency w.r.t. the recruitment stages post initial interview, breakdown of pay & overall culture. Appreciate all the other advice on the forum.

like

In the middle of a week of staycation right now and realized I just wanna be a stay at home couch potato. Work sucks. Applying for a new job sucks. Doing nothing with no work stress is great

like

Does anyone has an idea what fidelity round includes for case study for PM role ?

like

Hi !

I will be giving an interview with PWC IAC for the position Tax Manager. Could someone tell me what questions can they ask for SALT manager role ?

like

Just had the last interview of the second stage which consists of four 45mins interviews with different people. I got the feeling that the last interviewer wasn't focusing on what I was answering to him. No small talk in the beginning and he was slightly laughing where there's nothing to laugh about while I was doing my introduction. He also asked me the same questions (at least that's how I interpreted) and I had to repeat the same answer. Continue in the comments:

like

More Posts

Hi fishes !! I’m going to join at Bangalore location, by when can I apply relocation to Gurgaon in ey , is this easy process or difficult??

like

JL Associates, do you think we are getting another raise?

likefunny

Happy with appraisals?

like

Standard Chartered Anyone can tell what's the average at Standard chartered gbs Chennai or Bangalore location? Glassdoor is not being very useful!

like

How can someone find a job localizing marketing content (taking poorly translated material and fixing it up for US consumers)? I've heard that it's a real job but can't find much information about it

like

I'm curious about making the transition from creative agency to mgmt consultancy. Thoughts?

like

Hi all , can i get referral for software engineer- Angular and the req : 007ZP2

Hello everyone.
I have only 1 offer with me with
15 days remaining of my notice
period.
Ideally I would have joined the
company, but the company is
EPAM.

I have been seeing many posts
here about layoffs.
Can anyone please help me
with a referral?
YOE: 6 years
Tech Stack: Python backend

Note:
Few friends here have helped me with a referral. Though not for all the interview is scheduled, I am very thankful to them.

like

Hi! I’m doing some research on employee benefits (medical insurance, 401k, HSA/FSA, commuter benefits) and was hoping to connect with People specialists or HR professionals in the comp & benefits space. I’m trying to better understand any pain points or challenges you might face with utilization/enrollment. Anyone interested in connecting? Thank you!

like

I have a query, my Current Salary is 3.15 Lacs with 3 years experience in Customer service , I applied for new position in Airbnb and salary negotiation is next step, how to know what are the market standards for this job and as per discussion with other employee with same experience , he is getting 5 Lacs in that company but asking for 5.5 lacs is like 70% , I was hired by my last company during pandemic and was offered no raise from my previous salary
Is it recommended to ask for 70% raise?

like

Anyone looking to hire a jr AD? looking for a new opportunity

like

Is it just me or does anyone else know or have an inclination that their employer committed fraud after receiving PPP loans during COVID pandemic?

like

What is the best way to tell a company I am dropping out of their interview process? I’ve been interviewing with a company for a while and absolutely love them! But I have just received an offer from my first choice company, but want to do my best to maintain a relationship with the other company. Could I get advice on what to best say?

like

Anyone free to chat and willing to refer me to a few positions at CVS Health? Thanks

like

Anyone at KPMG willing to refer to Tech Consulting team? 8 YOE, looking for SM referral in Dubai. Happy to connect on LinkedIn and share cv etc. Thanks in advance

When is the Tyson’s Corner Wegmans supposed to open?

like

My Brother got an offer from PWC for 22 LPA as Scrummaster having 5.5 YOE.
Is he getting low balled?

Thanks for any response 🙌.

like

Additional Posts in Consulting

Anybody here at Carvana Co.? Is it looking like another round of layoffs?

like

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

like

Switched firms with a promotion to the title of Associate. At my old firm, the entry level role was also called Associate. Any advice on how to distinguish between positions on a resume?

like

There is an echo when I speak on calls due to my home office being relatively empty. I added a carpet but hasn’t made as big an impact as I would like. Any tips

like

PwC: for those laid off, how much does Cobra cost for us? Or can someone point me in the right direction? Only have 2 days to transfer 401k, wealth builder, and insurance/etc so scrambling now

like

It’s the weekend!! What’re y’all doing

Post Photo
likefunny

feeling dumb. But can someone explain me what do they mean when they say we need to map the process out or mapping? R they literally referring to creating a process flow diagram?

like

Anyone wonder what clouds feel like

like

Booz Allen Singapore office is closing. Riyadh has downsized. Abu Dhabi laid off all cyber employees. Are Dubai and Lebanon next?
How does this fare for the firm’s commercial and Intl ambitions?

likefunny

Ideally, at what level would a person with a SW Engineering degree, 3 years industry experience, 2 years MBA and 2 years Consulting experience be?

like

Met 2 of our new hires last night at a training. They've been here 3 days and are already concerned about being laid off. Felt bad for their anxiety but think it's ill-placed to some extent

like

About to board a flight, see a guy with a sweatshirt that says, “I’m a consultant. To save time, let’s just assume I’m never wrong” 😂

funnylike

Do recruiters care about LinkedIn endorsements?

likesmart

Why do people hate checking in their bag? I can reach the gate about 15 minutes before departure since I don’t have to fight for space and I can carry any amount of liquids in it. Feels like a win

like

Any of the female consultants out there been asked what their "rate" was when having a solo drink at the hotel bar? I mean, I can't help it that I'm popular...

like

How do you deliver feedback to someone on your team who is nice, hard-working, does all the right things, but is a low performer simply because they aren’t particularly smart?

likehelpful

Anyone else trying to finally kick that nagging cough/cold before the break? Would hate to have any option short of “all the booze” while I’m on vacation.

likefunny

Not drinking alcohol in consulting puts 1 at a significant disadvantage. Especially with partners.

like

Tfw you should be asleep but instead are reading about other consultants jerking it on fishbowl. Weird topics tonight..

like

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