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

Hey guys! Currently in WM ops at Morgan Stanley for the past 1 year dealing with alternative lending, I’m super underpaid with 3 years of experience which is very frustrating. (73k). Have been at Morgan for 1 year and looking to come over to JPM for an ideal pay bump, but would like to get into IB type roll. Any insight on what I should expect or how to go about applying? Maybe even getting referred? I have a deep knowledge of investments and always felt inclined to go down this route.

like

Hi everyone how is orcale to work? Is there a hiring firing culture.

like

For CSP/CSR, does the person getting referred get anything other than the public offer?

like

Would anyone in this bowl be interested in participating in live sessions? Perhaps tips and tricks, networking, interview tips, salary negotiation, etc. as topics…

likesmarthelpful

Are my chances at stern significantly hindered applying 1/15 vs 10/15?

like

I’ve been working for a company for 25yrs, looking for advancement. I’m considered an SME, managing people, Vendors and working on large system conversions. Have provided long term goals. When requesting feedback I’m told I’m on the right path, no suggestions on what to improve. I asked about timelines for advancement and not being given anything concrete. Recently interviewed with another company as a Vendor Mgmt partner. Individual contributor, high visible position with potential. Thoughts?

like

Is a 601 waiver required for having done unauthorized work in the US? Client is married to US citizen, and applying for GC overseas. Never overstayed, but did work illegally here in the past.

like

PMs, do you think consulting interviews are very easy?

Is it a norm to send a thank you note through your recruiter? I had an iffy interview, and wondering if I bother sending a thank you note. It was very clear that they were trying to do a stress interview so I feel weird saying the usual nice things.

like

Can anyone help me with the interview questions for marketing analyst at Agoda Bangkok. ?

like

Hello,
I have applied for the position of a consultant at Accenture and am currently ongoing the interview process.
I have successfully cleared the Skill 1 and Skill 2 interview rounds and was now expecting that the next would be the HR round.
I have been mailed that there is there is a third round before the HR round that is going to conducted the next week.
Skill 1: Pure Technical
Skill 2: Semi Technical + Managerial

What you I be expecting in this third round?

One doubt last week technical and hr round completed for me in tcs. Today when I logged in to ibegin tcs portal status shown as screening: Resume shortlisted. Whether tcs will plan to conduct interview again for me

How do people get interview call from Accenture Strategy & Consulting? I am an MBA from tier 2, 5 YoE post MBA in Financial Risk. Currently working with a Big 4.

like

I have one query, i received survey mail from ey gds regarding joining date and location preference, so it mean iam selected or any other round happens? Because i give self recorded video interview on 7th feb and i recive survey mail on 7th March which i filled on same day and in joining date there are two options 25 March and 25 April ,wheres i select 25 april but there is no communication after survey mail so what should i do?

like
like

I'm applying to a compliance role at Google, I have 10 yes banking and consulting experience, I was hoping to gain insight on Google's recruitment process for non tech. Google Atlanta if that makes a difference

like

Hi Fishes, I have an interview coming up for Associate Client Partner at Quantiphi, is it a good company to consider? I am10 yoe, market research background. Also, I already have an offer in hand from Allstate

like

Hi Fishes...I am a Full Stack Java Developer with cloud knowledge.Currently working in IBM.But interested to work in a FAANG organization.can anyone suggest me what skill should I need to develop to crack these companies interview and how can I get interview call from these companies?

like

As going through the interviews process as an experienced hire, do recruiters just email you with the offer or call you first and then email you details later on?

like

More Posts

Are ad agencies typically signatories of Local 700 Agreements?

like

Guys I have a offer for Penetration Testing Engineer L4 position, London location what should be the salary ?

Years of experience- 2 years

How much will be in hand ?

Post Photo
like

Does anyone have free or cheap resources to prep for cscp exam?

like

Just curious. Excluding business recovery / restructuring teams that are more counter-cyclical. What TS group do you think is the least cyclical? Valuation / modeling? Accounting advisory? Then lastly how “cyclical” do you view them?

like

What women’s walking shoes do you recommend? I live in Chicago and take the train to work so usually change into shoes once I get to the office.

like

My new Seamaster 😍

Post Photo
like

My first foray into luxury watches! Hoping for a few more in the future 😊

Post Photo
like

Negotiation in new offer: I’m moving from fully remote to fully in office (with chance of hybrid later) offer for associate director in quality in pharma for 170k base, 18% bonus and 75k equity. I’ve asked for a sign on bonus as I’m not eligible for annual next year and will be missing my current jobs bonus. I should hear tomorrow (asking for 28k). Thoughts about the offer? Should I ask for more equity or is that standard? They’re public (currently ~$20)should I get the hybrid option in writing?

like

What are we? Some kinda suicide squad?

like

Do cover letters matter at all anymore?

like

It’s such an unsettling feeling to want to hear from someone and not want to at the same time. I’m shocked I haven’t thrown my phone against a wall. My mind wants a Rage Room but my body is exhausted and just wants sleep.

like

Why are Product Design portfolios so boring? Has anyone seen a good one lately?

funny

Hi Guys, Need to unlock DM's. Appreciate your help in liking the post!

like

Hello Fishes , what would be in hand salary for below compensation

Post Photo
like

How much does a Capital One data scientist gets pay? Location Dallas

like

Do I need to list internships or graduate assistant jobs in my resume? I am six years into full time work but have been at the same company the whole time (different titles but the same role).

like

Hi everyone,

I am joining
Walmart in August. Anyone else joining in August? Please DM.

like

Anyone like Rhaenyra a lot more than Daenerys?

like

I'm so tired of hearing about wellness. If you want me to be well, just pay me more and I'll figure it out

like

Additional Posts in Consulting

Top consulting firms in the Aerospace / Aviation,l or Defense / Intelligence spaces? Looking for business or tech strategy jobs here

like

Curious people’s opinions of working at Uber Corporate (Chicago). In their Emerging Products space. The work sounds interesting but not sure of culture or management. Any input from anyone who’s come from there or knows anyone currently at Uber would be great.

like
like

I’m a creative / tech innovator applying to McKinsey and the other big four. However, I’m now concerned my limited on-the-fly math skills will automatically count me out. Seems like the interview process weighs on that. Im wondering if I need to hire a math tutor to help me get up to speed. Or, wondering if those of us who are more creative can get away with less than ideal math skills. What’s the reality?

like

Anyone have good book recommendations that I can learn from and are entertaining? Trying to survive a 10 hour flight this weekend 🆘🆘🆘

like

When you hear that staff 1s we're just laid off... 😳

like

Can somebody please refer me to PWC middle east advisory please?

like

Got an offer for 140 base VP position at a bank. Is that low? 4.5 YOE

like

What are the best books on sales as it relates to consulting?

like

Anyone ever work at both EYP and Deloitte Consulting? How does the work life balance differ between both?

like

It’s insane how fit Jeff Bezos is. Usually people at his level look so out of shape cause they don’t have the time to work out, but Jeff looks like he spends 2 hours at the gym everyday.

like

what does the bonus range look like for a new band 4 at bank of america?

like

What’s the salary for a Sr Dir, Advisory CIO at Gartner? What’s the culture like? Yay or nay?

Masters baby what a time

like

A reminder to all: we are going through very difficult times. Please help someone who has gotten laid off if you can!

like

Anyone take SHRM? How many hours did you study?

like

Hate it when recruiters tease an exciting opportunity but refuse to say over LinkedIn what the company or role is... “Must set up a call for confidentiality reasons.”

likehelpfulfunny

Planning to do a PRM or FRM qual. How useful is it to move from Big 4 Risk and reg consulting to industry? Finding it hard to get anything other than non-PM roles

like

What firms (consulting and industry) have good medical benefits? (Using BCG's as my baseline for good)

like

Hey all, new hire here! Going to receive a $250 wfh credit; any recs on what I should get to build out my home office?

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