There Goes Mom & Pop: Cracking the Code of Family Leave

The objectives of this project were:

1. To examine parental leave policies of different companies and industries.

2. To determine how much leave parents-to-be could expect if they worked for different companies, or in different industries.

The Dataset

The data was downloaded from Maven Digital Playground as part of Maven's Family Leave Challenge. The dataset contained only two .csv files.

• parental_leave contains data on companies, industries, and how many weeks are offered for paid and unpaid parental leave.
• data_dictionary contains definitions for all the fields in this dataset.

Steps

Step 1: I loaded the data into Power BI and explored the data contained in the columns.

Step 2: I replaced N/A values with 0 and changed the type of the paid paternity leave, unpaid paternity leave, and unpaid maternity leave columns into decimal numbers.

Step 3: I started mapping out my data visualization, checking off what my stakeholders would need to know.

Insights

• The most common duration for paid maternity leave is 12 weeks, by 24.36% of companies.
• Of the 1.25% of companies that offer 52 weeks of paid maternity leave, 0 offer any paternity leave.
• The best parental leave policy belongs to Grant Thornton, an Accounting Services firm that offers 51 weeks of both paid & unpaid maternity leave, as well as 51 weeks of paid paternity leave.