Parental Leave Analysis

Description :

This project is based on “Maven Family Leave Challenge” in which I'll be 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.

As part of Women's History Month in the United States, our company is writing a piece on parental leave policies across the business world, and they need me to create an impactful visual using the collected data.

Dataset includes survey of worldwide employees on 1600 Companies of 51 Industries on Parental Leaves policies.

Key Objective of Dashboard:

Use Power BI Desktop to:

1. Connect and transform the raw data.
2. Create DAX measures and Calculated Columns.
3. Design an interactive report to analyze and visualize the data.

Observation:

1. Survey done on 1600 Companies in 51 Industries.
2. Average Paid Maternity leave 10.9 Weeks.
3. Average Paid Paternity leave 7.3 Weeks.
4. Average Unpaid Maternity leave 6.6 Weeks.
5. Average Unpaid Paternity leave 7.7 Weeks.
6. 98.25% of Companies give Maternity leaves.
7. 16.94% of Companies give Paternity leaves.
8. Philanthropy gives maximum paid Maternity & Paternity leaves. (Ignore N/A industries).
9. 73% of Companies give Paid Maternity leaves in 0-3 Months bucket.
10. 13% of Companies give Paid Paternity leaves in 0-3 Months bucket.
11. Maximum Paid Maternity leave duration is 52 Weeks, and which given by 1.25% of companies.

Data Source: Data Playground Maven's Analytics.

Concept Covered:

1. Multiple KPI Cards.
2. Field Parameters used for updating stacked bar graphs with multiple parameters,
3. Bar Charts, Funnel Chart, Slicers and text boxes.
4. Custom Theme.
5. Icons sets.