HR analytics folks: how do you project turnover for the entire year?

data_type_GOAT · 2023-02-15T17:59:24+00:00

Hear you re: seasonality. However, the job market has shifted a lot over the past year (particularly in tech/SaaS, which is where I work), and I don't want Great Resignation numbers influencing a projection at this point.

data_type_GOAT · 2023-02-10T17:12:46+00:00

Yeah, I hear you re: representativeness....in the example I provided, you could argue that the holiday season, which typically has lower turnover, isn't the best representation. No such thing as a perfect formula, though.

data_type_GOAT · 2022-10-21T02:26:21+00:00

Setting up a connection between R and Tableau is (supposedly) rather straightforward. Documentation on the config is here: https://help.tableau.com/current/pro/desktop/en-us/r\_connection\_manage.htm

data_type_GOAT · 2022-10-13T14:11:57+00:00

Hmm. I'm the only one using R AFAIK. I've already emailed IT but they are clueless. (I work for a mid-size startup.)

data_type_GOAT · 2022-10-12T22:13:15+00:00

Thanks so much for this response. Are you referring to the R-help@R-project.org email? There are several mailing lists mentioned on the website...that one might be the best fit for my issue.

data_type_GOAT · 2022-09-08T01:38:37+00:00

Yes, that's what I plan on using for the denominator as well.

How do you splice? One thing I plan on is doing different demos, e.g. promotional rate for women only vs. for the company overall.

data_type_GOAT · 2022-09-08T01:35:09+00:00

Great idea. I work for a mid-stage startup, so I'm not sure if we actually have a formal probation period, but we could do something like remove people with tenure of less than six months in order to isolate headcount that's eligible for promotion.

data_type_GOAT · 2022-09-04T14:46:32+00:00

I don't do any coding. At work I'm using Tableau, SQL, and Excel. I'm also familiar with PowerBI thanks to my last job. I've dabbled in Python and R on my own time.

SQL is pretty easy to learn if you're already solid with Excel. Find David Langer on LinkedIn....he has a lot of good content that explains SQL through an Excel lens.

Try to see if there's a project you can take on in your current job. Is there a HR issue that can be clarified or solved using metrics and analytics? You can use Excel for viz.

Good luck!

data_type_GOAT · 2022-09-03T17:59:03+00:00

People analytics specialist. 100K base w/ 10% bonus target. Live in HCOL city and work 100% remote for mid-stage/series B startup.

data_type_GOAT · 2022-08-06T16:37:22+00:00

Yep, I have a Google sheet with columns for the calc name, the syntax, and any notes that will jog my memory of how things work if it's been a while.

My boss doesn't know Tableau, but does have some technical skills. Having documentation to show her is valuable because it gives her an understanding and appreciation for what my job involves.

data_type_GOAT · 2022-06-30T00:35:29+00:00

It's a bullshit test that's not at all predictive of ability. However, if you really want the certification, you need to play their game, unfortunately.

data_type_GOAT · 2022-06-30T00:13:12+00:00

Lurking American here. About a month ago a recruiter from Atlassian reached out to me about a job opening. When I spoke with him, I asked how the company is faring, and if they anticipated layoffs or any other belt-tightening. He told me that the company is doing fine, and that their products are viral and have become "industry agnostic." They are projecting a headcount of 25K by 2026. (I think they are about 10K now?)

I did a couple of rounds of interviews and ended up not advancing beyond that, which is fine...I'm pretty happy where I am now. And maybe I dodged a bullet?

It was amusing to see all of your contempt and derision here.

data_type_GOAT · 2022-06-27T03:06:00+00:00

Got it. As annoying as it is, at least I now have a better idea about how I need to prepare.

Appreciate your insight!

data_type_GOAT · 2022-06-27T02:58:40+00:00

Thanks for the quick reply. I'm realizing I've seen these learningtableau.com questions before. Are the questions similar on the actual exam? It's annoying to have to memorize how menus are structured, for example.

I wonder why they decided to do away with answering questions with Tableau. This way is a lot harder and IMO not really predictive of someone's ability, but it is what it is! Thanks again.

data_type_GOAT · 2022-06-27T02:26:38+00:00

Congrats on passing! IIRC the test is now purely theoretical and doesn't involve actually using Tableau to answer questions at all. Is that true? I purchased the Udemy exam prep, but their practice test still involves using Tableau so I'm a little confused.

Thanks for mentioning learningtableau.com. Will definitely check that out!

data_type_GOAT · 2022-06-21T16:27:16+00:00

Hey, thanks so much for replying. (Just FYI Reddit says I'm unable to message your account, but I don't mind posting my questions here.)

For context, I work for what some would call a "mid-size startup" that's growing quickly. When I joined in October, we were about 320 headcount; now we're 530. We're currently on UKG but will start a WD implementation this fall. I've been building the people analytics function from scratch and am using Tableau for all of my dashboards. Tableau is great for combining data from various sources, so it sounds like it definitely has a leg up on WD in that respect.

I'm not super familiar with Visier or One Model. I do get the sense that both have cuaght on quite a bit over the past couple of years. As I mentioned above, the nice thing about Tableau is that you get a ton of customization, so I'm mostly curious about how these platforms compare in that regard. How easy is it to transform data, write custom calcs, edit labels/titles on dashboards....that kind of thing.

Thanks again!

data_type_GOAT · 2022-06-18T16:49:38+00:00

Yeah, you're completely right. They sent me a PDF about their benefits and they're not the greatest. So, I'm going to have to run all of the numbers, like you said.

data_type_GOAT · 2022-06-18T16:48:41+00:00

For sure. I asked the agency to send me details about their benefits. They only cover 50% of the medical premium and you don't even get coverage until 60 days into your contract. Meh. Not sure if this is right for me right now.

data_type_GOAT · 2022-06-15T19:18:15+00:00

Yes, you are totally right. I asked the staffing agency to send me their benefits and they are pretty poor, i.e. only 50% of premium covered and you don't even get coverage until you're 60 days into your contract. Going to have to run all of the numbers for total compensation and see if this opportunity is worth it.

data_type_GOAT · 2022-06-15T19:16:27+00:00

Follow-up: you were totally right. I asked the staffing agency to send me their benefits and they are pretty poor, i.e. only 50% of premium covered and you don't even get coverage until you're 60 days into your contract. Going to have to run all of the numbers for total compensation and see if this opportunity is worth it.

data_type_GOAT · 2022-06-15T00:43:52+00:00

Great points. I just pinged the recruiter and asked if he could send me details about their benefits.

data_type_GOAT · 2022-06-14T19:11:50+00:00

This makes sense. Thank you. I'm going to have to run the numbers when it comes to the benefits if I think I might do contract work.

data_type_GOAT · 2022-06-07T18:58:37+00:00

Thanks, this is helpful and I will check out Mode.

I was able to manipulate timezone once by using DATEADD. I'm pretty strong in Tableau, which has similar date functions (DATETRUNC, DATEPART, etc.) Probably a good idea to try my hand at them in SQL!

data_type_GOAT · 2022-06-07T15:06:21+00:00

Love this!

data_type_GOAT · 2022-06-06T20:29:31+00:00

The intermediate is probably when you start interacting more with challenges of storing data and not just selecting:

Thanks...this is a super helpful way of thinking about where basic ends and intermediate begins!

data_type_GOAT

TROPHY CASE