I have personnel data from headcount, leavers, time in grade, performance and rankings, maternity temporary leaves maybe university of the hires, promotions etc. And I am building a Diversity Dashboard splitting all that data by gender in Tableau. What I want to do is to step further and apply predictive analytics. But I need ideas about how to do it, Im learning python so that wouldn’t be a problem if I need to learn doing something with python how can I start ? Confident with alteryx and SQL

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

Get someone who knows what they're doing on the team. Experiment for personal growth, but don't deliver anything beyond the dashboard unless you get it vetted by a statistician and legal. You're working on data that's very touchy from both a legal and PR standpoint. Mistakes here can seriously damage both the firm and the client.

If you are going to experiment, start with any short intro ML or statistics course. Doesn't really matter which if you're at the point where you're not sure where to start.

like

How big is the data set ? rows ? variables ? Can you start with some basic regression in excel ?

Tables are in SQL , for example we have monthly headcount since 2010, so near to 300,000 . But needs cleaning and have inconsistencies, currently working with July 2018 to today. Variables are level, gender line of business , group, maybe age, university, tier/ranking, commentaries about performance , productivity, hire and promotion dates

Not saying I would model that in Excel [you could as a starting point] but that’s a small data set. I would get into into a tool where you could see, work with the data

like

Thanks That’s something that I constantly remember working with hr data, I’m going to dig into it

Seriously, figure out what you’re doing before you start communicating “findings”. I can’t tell you how many times I’ve seen these sort of findings being discussed, with no foundation whatsoever, other than a simple observation that has no statistical backing.

People seem to be aware of the phrase “correlation is not causation”, but then dismiss the idea as soon as they have an observation that fits their hypothesis or world view, more generally.

For example, let’s say you observe that, on average, gender A has a higher salary than gender B. Some might get all excited at this point and start screaming “gender inequality”. However, this observation means nothing. It could be the case, hypothetically, that a disproportionate number of individuals of gender A live in higher cost of living cities or are aligned to higher- value (financially) practices in a firm (like strategy vs operations). These are what you might call confounding variables. Proper statistical analysis will flush these out.

Now to attempt to answer your question, try regression, which will help you to understand which independent variables drive variation in whatever output variables you what to explore (and to what degree). Taking my example above, the output variable would be salary. The inputs, or independent variables, might be location, organizational group, years of experience, etc. If you have the “right” data, you will be able to figure this out. But, it could be the case that you don’t have the right data, which you’ll discover in a low R squared value for your regression model.

What exactly are you trying to predict here? What are your hypotheses? Figuring out how to code a regression model is easy, what will take more time is understanding the ethics and implications of what you’re doing. Look into confirmation bias, unbalanced datasets, and overall ethics. HR data is not something to play with if you don’t know what you’re doing. I’d be really annoyed to find out some random person in the firm is predicting my tenure at the firm or future salary growth based off a few scarce data points. I can already tell maternity leave data is going to disproportionately affect your prediction results given that many women are let go when taking it.

Related Posts

Hello everyone!
I’m currently a PMO project manager, but would like to PM Cloud-based software projects. Any suggestions on credits or certifications to help build my Cloud knowledge?

Thank you in advance!

likehelpful

Hello everyone, I am a fresher and I recently joined a management consulting firm(3 months) with 12+LPA and I realised MC is not for me.
I tried giving it a shot for the first 2 months but then I am just dragging there after. Anyhow yk how it's in MBA, campus placement leli without a thought plus lack of experience in everything. It's tough out there.
I am desperate to switch to creative/marketing/branding/advertising. If anyone could help/guide/refer me in the right direction that'd be great.

like

Has anyone taken STD/parental leave at both Js?

like

Has anyone ever made the transition from sales to marketing? I’ve done Business development for over 3 years now and I’m super excited to make the transition as sales is not my passion. Just curious if any classes I can take or other steps I can take to be ready for a marketing role. Thank you!

like

Need some advice bc my work and personal life intertwine. Too much sometimes. Father is my boss. Wife is adamant that when folks come over they take off their shoes. Tried to ask my family...cont

like

I am about to hand in my notice at a job I am pretty secure in, to go to a job for a relatively new company (with a significant salary increase). Any tips for:

1. Getting over the nerves that are as a result of taking a risk (I am late 30's)
2. The guilt of leaving a role where I have an amazing working relationship with all my colleagues and my boss

Any tips would be appreciated as I am a mess of nerves!!

like

Have a job opportunity with a company that I’m not particularly interested in culture wise, but the work seems like a great step in my career. What are some deciding factors you would consider cont.

like

Diversity is something that BBs have been pushing in recent years, but how well has it actually been executed? How diverse is your group and do you feel like diversity recruits are treated the same?

like

How did you begin to implement equity and inclusion into your organization?

like

I'm looking to transition from Project
Management in the International
Development/Non-profit space to
project/product management in the
private sector, mostly the tech
space. Has anyone else made this
transition and is willing to give some
tips/advice?

like

Has anyone successfully moved out of claims into underwriting? I have been doing worker’s compensation claims for about 9 years now as an adjuster. I would really like to get into underwriting but have not had any success so far. What are some other roles I can transition to?

likehelpful

I am a Medical Technologist with a degree in BS Medical Technology. I want to change my career to Business Analyst or Project Manager. I do not want to get another degree. Will coursera courses suffice? Any other tips?

like

Hi everyone! Question for my CRAs in clinical research. How did you progress your career after this role? Did anyone go somewhere other than the Clinical Trial Lead position?

like

AAPL & TSLA . . . backdoor ways for big money to exit to weaker hands? Discuss.

likehelpful

Does anyone have experience moving from federal to commercial? I’ve been in federal for a little over a year and am itching for higher paced, less bureaucratic client work.

Trying to get a 45 y/o sibling in to consulting (was an entrepreneur prior in the restaurant industry). No college degree but willing to bust his but to learn. Books/online courses recommended pls

like

How does the career graph of business analyst (for business analysis and not analytics) look like?

I have 8 yoe as a manual qa and have been offered the position of business analyst within the company. Want to know the scope before telling a yes.

Thanks in advance for your help

I recieved an offer from barclays as a process advisor. ( BA2) Can someone tell me is the work hectic for that role in barclays?
And what are the growth chances in this role within the company?

How do you deal with colorism that promotes diversity and inclusion in the workplace?

like

More Posts

I have few questions regarding Optum :-
1. How much an average employees can expect from RRP, 20 percent of base as variable looks very high.
2. Work life balance
3. Notice period
4. Work timings
Can someone please help me on this.
Thanks in Advance

like

I took adderall while I was studying for the bar and it really helped. I don’t have a prescription but am wondering if this likely means I have undiagnosed ADHD but don’t know how to bring this up to my doctor. I definitely have trouble focusing in general and have always been pretty dozey/aloof but have somehow gotten by and am now a third year associate who is doing okay without it. Do you think getting Aderall could help even though I’m doing fine? Maybe I’ll go from good associate to great

like

What are some feasible exits to the investment industry? PE seems to be too hard. Currently at Strategy& Deals Strategy and will leave at the 3YOE mark

like

Average base salary for someone who just passed the CFP?

like
like

Why is it better to work in a product based company than a service based company like Capgemini, TCS etc?

like

I had a miscarriage on Tuesday, my first. I didn’t even know I was pregnant. The Dr. was just as baffled by the timing, but here I am. My head is trying to be practical, but my hormones are raging. I feel like a stranger in my own body. How do women do this and work at the same time? I’m a freelancer, I’m so busy at work, I don’t feel comfortable talking to my coworkers about this. I’m trying to just get through the week but am really struggling.

like

Now I have been English from birth but this word "anecdote" that Amazon folk throw around gets me every time!
What does it mean in respect to business performance as it is used????

helpfullike

What is the verdict on Canva resumes? Yay 👍or Nay 👎

What recruiting exit opportunities have people seen / achieved? I managed to pívot out of agency into a early careers campaign manager, then to HR project management, but lo and behold I’m back in corporate full cycle recruiting again 😛

Post Photo
funnylike

Is it good to leave the company in 2 months?

like

Is anybody into the Les Mills classes? Are they effective or is a gym session better?

likehelpful

How to initiate pf transfer from pre org to Bosch

like

Trying to get into habit of reading. Have never read any books and would love some recommendations
General interest include investment, trchnology, short stories with moral, entrepreneurship,business

funny

Do you have M1, M2 and M3 banda for @EY India?

like

Suggestions for where to watch the Celtics tonight? Preferably somewhere with good drinks — feels like a weird weekend in the city so looking for a decent crowd but not wild (which I don’t expect would be the case being MDW in any event)

likesmart

Finished my Amazon loop. Such an interesting experience. I prepared around 20 stories but still found myself having to pull some more that I hadn’t prepared just for some of the questions they asked. Wish me luck.

like

Hey guys, question regarding new years resolutions. Anyone know some good books about how to lead better and step up to become a great CD?

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

like

Additional Posts in Data & Analytics Consultants

Hi All,
I have a question about replicating an Alteryx model in python. Basically the Alteryx model used to clean, combine, prep, run some business rules and spit out a formatted file ready for running further analysis/viz. Can this same process be automated using a python script? I’m new to python and would like to know what packages to learn to do this.
Thanks!

like

What’s the coolest data solution you have delivered? The industry is getting a little predictable and some inspiration is always welcome.

like

Any highly recommended videos or resources that give a comprehensive approach to sales forecasting?

like

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

Analytics 💵 transparency thread!


Format:
Title level (standardized title/job level)
Economic area (Bay Area, Midwest, etc)
Salary + bonus + liquid equity
Anything else you think would help

likesmarthelpful

Interviewing for a data scientist role. They gave me a week for a case study where I’m asked to clean data and then derive data insights (python), and then make a PowerPoint to present my process and results. Any case study samples out there I can reference to? Much thanks!

like

My first 2 years was developing algorithms. Since last year I started business development, project management with outperforming achievement. What could be the next step if I don’t want to code?

like

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like

What’s the best company for machine learning projects?

like

Data engineering or data science as your starting career for job security and ease of moving around to different jobs?

like

Lunch discussion at the office, curious to hear your thoughts: Does one need to learn data science first to be a good data engineer / architect? Why / why not?

like

Wanting to get out of fed space. I am a data scientist with 5YOE. What are good companies to look for in DC area that’d hire someone with gov consulting experience?

like

Anybody looking for data strategy or technical PM for analytics projects?

likehelpful

Can anyone please provide the best recommended training link to study for the AWS Cloud Solutions Architect Associate Certification? I want to study for it end-to-end and complete it within a few weeks!

like

I interviewed for a product analytics DS role at Fb/Meta last week and haven't heard back since. Not sure if I event want to take up the role but nevertheless wondering if I am already rejected? Been about a week.

like

Any recommendations for resources to learn intermediate / advanced Tableau? All the firm-provided resources I could find seemed very basic

like

Looking to move from consulting to chill DS/analytics role. Don’t care too much about TC ($150k is fine), but WLB is paramount for me. Anyone have any thoughts as to where I can get this?

like

What are some benefits of doing a Masters in a more applied subject like data science compared to a more theory one like purely statistics? Considering a quant heavy masters vs functional (M Ed)

like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

Has anyone here taken the Nike SQL assessment via HireVue? Wondering what to expect.

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