Maven Challenge 2023 - Parental Leave Policy

Power Query:

I decided to give myself a challenge here and tried to assign out of 1600 companies, which belonged to Fortune 500 list. I found the latest ranking of Fortune 500 companies on Kaggle dataset and decided to do Text.Contain - in the first run I have managed to assign dozens of companies, but after a random, manual check I have noticed that "The Coca Cola Company" could not be found in Kaggle List "Coca Cola", hence I used List. Accumulate to look for keywoards - trying to ignore any "the" etc.

In the first attempt with only Text.Contains I received 166 companies, with additional condition ( below) I have received 274. That satisfied me enough for further analysis.

Formula: = Table.AddColumn(#"Added Index", "IsFortune500?", each if List.Contains(InFortune500,[Company]) or List.Accumulate(InFortune500,false,(state,current)=> if Text.Contains([Company],current) = true then true else state) = true then "Fortune 500" else "Others")

I have also normalized fact table and excluded main industries from detailed views which has improved readability of scatterplot - less points, which contained more companies !

Analysis: I decided to play with cumulative frequency - I tought it presents a good insight into magnitude of companies trend for policies for paid and unpaid parental leaves. Fortune 500 was a nice touch, as I wanted to work on companies mostly, not generic industries. Furthermore, some industries were in my opinion outliers, when they encompassed only one or two companies - hence, my scatterplot focuses on the ones with N >= 30

I also included some interesting and catchy conclusions for Mathers and Fathers.

For line charts I have made a modulo %% 2 measure, which reduced points on the line - week axis is continous, but without odd week no. bins. The lines look smoother, without losing information, as main bullet points are visible and cumulative freaquency is easy to follow, but we do not need to focus on details that much.

Design: To be honest I did most of graphics in Power Point and Power BI - I have designed an elephant with a baby icon myself as SVG in Inkscape programm. Other icons were downloaded from Flaticons - I decided to use purple as I noticed on Internet, Women's programms logos use lots of purple and pink combinations - for Paternity I used a counter color with slight of brown-orange to distinguish lines on plots etc.

Main Goal: I decided to not follow my go-to path to build another BusinessDashboard, as the description suggested we were told to focus on infographics. I decided that bright, glowly and light conclusions were something I would personally like to see on some online article/blog post - I think the page is not cluttered and yet is conveying bullet points in a friendly manner.