Challenge details:

For this challenge, I am working as a Data Visualization Specialist at an online business journal. My role is to create charts, visuals, and infographics as supporting content for articles. My company is writing a piece on parental leave policies across the business world.

Approach:

I have divided my approach of this task in 4 different steps.

1. Data Understanding and cleaning.
2. Exploratory analysis of the data and insights.
3. Charts and theme finalization.
4. Building the dashboard on BI tool.

Dashboarding / Visualizing:

Theme Inspiration: Statistique Canada

The whole template was created using Figma. I decided to use the Lavender color and its different shades as it signifies the visual I am trying to create and make an impact at the first glance. I have tried to not be generic in terms of Pink and Blue for Ma and Pa.

Chart #1: Waffle Chart shopping the records for the number of leaves provided my companies showing the availability and the sampled data for the consequent charts. paternity leaves were about 82% and 92% in the NA category and hence needed to be shown.

Chart #2: Average leaves (in weeks) for Maternity and Paternity for both Paid and Unpaid sections using the box matrix.

Chart #3: Doughnut/Percentage chart showing the similarities and differences between companies' approach.

Chart #4: Line + Area chart depicting the number of leaves provided by companies and the most preferred weeks.

Chart #5: Calendar chart to show the range of months the companies opt to give leaves for Paid maternity.

Chart #6: Acknowledgement of the only 20 companies who provide Paid Maternity leaves for 1 year.

Chart #7: Stacked Bar Chart showing the total number of leaves provided by top 10 companies and industries across the dataset.

Insights:

• Data from 1600 Companies and 51 Industries.
• 97% Companies provide Paid Maternity Leaves
• 82% and 96% of the companies do not provide any data on the Paid Paternity and Unpaid paternity leaves respectively.
• Average Unpaid paternity leaves (7.7 weeks) are more than Average Paid Paternity Leaves (7.3 weeks).
• 292 Companies provide both Paid Maternity and Paternity leaves.
• 20 Companies provide equal Maternity and Paternity leaves.
• 6 Companies neither provided Paid nor unpaid maternity leaves.
• 2 Companies neither provided Paid nor unpaid paternity leaves.
• 20 Companies provide a Paid Maternity leave of 52 weeks (1 year).
• Only 2% of the total companies provide Paid Maternity leaves for more than 6 months.
• Medidata Solutions provide the most leaves (80 weeks).
• Natural Resources industries provide the most leaves (average 62 weeks).

About Dataset:

This dataset contains a csv table with 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).