About: As part of Women's History Month in the United States, a company is writing a piece on parental leave policies across the business world and they need you to create an impactful visual using the data you collected.As part of Maven Analytics monthly challenge, the purpose of the challenge is to play the role of a Data Visualization Specialist at an online business journal. The duties asign are to create charts, visuals, and infographics as supporting content for articles. Especically for Women's History Month in the United States, where the asign company is writing a piece on parental leave policies across the business world and they need to create an impactful visual using the data collected.This dataset contains 1 table in CSV format: The Parental Leave Data table contains information on 1,601 records, one for each company. Each record contains the company's name & industry, as well as crowdsourced information on the paid & unpaid weeks off they offer as part of both their maternity & paternity leave policies (when available).
Approach: For starters, data cleanning had to be made. Some companies had not disclousure their Parental Leave, having a mix of N/A and number values in the same column. For that, duplicates column to work with were created, and replacing the N/A values with [blanks] so that it would be considered for average measures.As for DAX measures, the most used were the average, maximum and minimum per type of parental leave and then the ranking so the Search in page 3 can function. The structure of the dahsboard is in 3 pages, the first one being an overall summary of the information given. The second one, going deeper into Maternal vs Paternal Leave. As the visual is for an online business journal, the third one was left for the end user to navigate through all the companies in the dataset. For the presentation theme, the dashboard is displayed with a mix graphs with an infographic, magazine and flyer style.
Analysis: There is a lot still to be done regarding to Parental Leave. Out of 51 industries, only 10 give parental leave higher than the average for both maternity and paternity leave. Furthermore, there is a difference of 23 days between the total average leave taken by each gender.
There is a clear difference between Maternity and Paternity Leave in both paid and unpaid type. When it comes to the same duration of parental leave, women are offered this benefit by at least twice the number of companies as men. In terms of paid leave, women receive this benefit from almost 32 times more companies than men, while in the case of unpaid leave, the number is 42 times higher for women.
Only 6 of the Top 10 Industries with highest Paid Paternal Leave provide Unpaid Paternal Leave. While none of the Top 10 Sub-Industries with highest Paid Paternal Leave provide Unpaid Paternal Leave.
Onlly 96 (6%) companies out of 1,601 offer above-average Maternal and Paternal Leave benefits. While 782 (49%) offering below-average Maternal and Paternal Leave benefits and 711 (44%) offering above-average Maternal Leave but below-average Paternal Leave benefits. Not surprisingly only 12 (1%) companies offering below-average Maternal Leave but above-average Paternal Leave benefits.