Photo by Campaign Creators on Unsplash
Introduction
You’re working as a data analyst for Red Mic LLC, a company that specializes in manufacturing professional grade microphones for musicians and newscasters.
Recently, a rival company (Green Audio Inc) announced that they were launching a set of initiatives to take their organization into the twenty-first century.
After a heated shareholders meeting, the board of directors has tasked the CEO with making sure Red Mic LLC isn’t left behind.
Stakeholders
These are the individuals your team will be helping during the case study.
Cecil, the VP of Human Resources
Hello, I'm Cecil the Vice President of Human Resources. If you have any questions about benefits or workplace culture, please let me know. I look forward to working with you.
I came to Red Mic three years ago and have spent most of my time since working on employee on-boarding and retention. I'm excited to see what data science can bring to the table.
William, the VP of Finance
Charmed.
I'll admit, I'm a bit skeptical of this so-called "data science". I like my data kept in Excel spreadsheets where I can keep an eye on it.
Devon, the CEO
It's good to finally have you on the team. I can't wait to see what you can do for Red Mic
I graduated from Stanford five years ago, launched a VC-backed startup that was later acquired by Red Mic, and was named the CEO by the new board of directors.
Johnny, the data science intern
Welcome to Red Mic! I'm so glad you're here, now I'm officially not the newest person on the team! What's your favorite Python library?
I really like data science.
Stakeholder Focus Areas
The shareholders are particularly interested in the following areas:
- Making sure Red Mic LLC has a diverse workforce.
- Ensuring that employees with similar positions and experience are receiving equitable pay, regardless of race, gender, or marital status.
- Striving to reduce employee turnover by actively measuring employee satisfaction and engagement, as well as engaging employees in special projects.
- Analyzing what work-life balance issues might exist in the workforce that could be negatively impacting employee performance and longevity.
You're about to go into a strategy meeting with the CEO, Vice President of Human Resources, and Vice President of Finance. They want to make sure you have the data required to answer the questions they're most interested in.
Dataset
Spend some time with your team evaluating the data. Be sure to look at data types, ranges, and meanings of each feature from the data dictionary.
You can use the following Google Colab notebook to assist you:
