Maven Family Leave Challenge

The Parental Leave Policies project aims to shed light on the varying access to paid and unpaid parental leave policies across different industries and employers. The project involves compiling a dataset containing information on the paid and unpaid weeks off offered by 1,601 companies as part of their maternity and paternity leave policies.

The project flow involves several steps, including business requirement document and data gathering, data cleaning and transformation, DAX formulas, user interface design, and insights presentation. In the data cleaning and transformation stage, the team identified errors in data type, as the paid and unpaid maternity and paternity leave columns were stored as text instead of numerical values. To facilitate accurate analysis, the team replaced the value "N/A" with zero.

The DAX formulas were used to calculate the total number of days of maternity and paternity leave offered by each company, the ratio of paid and unpaid maternity and paternity leave days, and the average number of maternity and paternity leave days offered per industry.

The user interface was designed to present the insights gathered from the dataset visually. The dashboard showcases the top companies offering maximum paid and unpaid maternity and paternity leaves and provides a snapshot of the industries with the most representation in the dataset.

The project's insights revealed that the majority of companies listed in the data provide 52 days of paid maternity leave. Non-profit organizations also provide paid maternity leave, and the technology and insurance industries have the most representation in the dataset. Only a few companies provide paid paternity leave, with Grant Thornton offering the highest number of weeks of paid paternity leave among the listed companies. The project also identified companies providing unpaid maternity and paternity leave, with McDonald's offering the highest number of weeks of unpaid paternity leave.