Maven Family Leave Challenge

The Challenge:

you'll be working as a Data Visualization Specialist at an online business journal. Your role is to create charts, visuals, and infographics as supporting content for articles.

As part of Women's History Month in the United States, your 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.

The 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).

The Approach:

1. Understanding the Data: Deep diving into the dataset to understand the data properly with the help of the data dictionary provided along with the dataset.

2. Data clean-up: I have cleaned the data in Power Query Editor using the following steps-

Firstly I replaced the N/A values in the Industry column with "Others". Then as some of the companies haven't disclosed their parental leave policies, I replaced all the N/A values in the Maternity & Paternity Leave columns with "0" and changed the data type to decimal numbers so that average measures could be created using these columns and lastly, I split the Industry column into Industry and Sub-Industry columns so that analysis could be done on a more granular level.

3. Creating Measures and Calculated Columns: I have created measures and calculated columns to show important insights on the data set, mostly AVERAGE, AVERAGEX, SWITCH and DIVIDE DAX functions are used in this project.

4. Designing Dashboard: As the company is writing a journal on parental leave policies I have tried to use simple graphs and attractive infographics to make the dashboard much more interesting and easily understandable for the general public.