Challenge 3- HR Data
So here it is all the 3rd instalment of the EDNA challenge.
Remember its open to everyone so don’t be afraid to get stuck in.
To learn more about the challenge and how it works be sure to check out the forum below!
If you’re not sure of anything just reach out to me.
Remember: The weekly winner will receive a complimentary membership to the platform that they can share with anyone and the opportunity for your work to be showcased across our channels.
Also be sure to check out the previous challenges.
News is fast spreading about who the go to analyst is in the company. (PS it’s YOU)
The HR manager (James) has approached you for some help.
He is reviewing all internal consultations that have taken place around policy changes.
They currently have a HR system in place where they create and manage the respective consultations.
The current process is that once management decide that there is going to be a change to any policy, they then create a consultation within this HR system assigning a window to hold interviews with employees.
The company policy is that every employee will be interviewed twice regarding the change. The outcome of each interview is recorded.
Unfortunately the current system doesn’t have a reporting suite.
James has managed to get the data out of the system with some help from IT but isn’t sure where to go next.
He has said he is looking to report back to his seniors around the outcomes of these interviews and what the reception has been towards a consultation. James is also keen to establish the change of outcomes between the two interviews and any other metrics that you feel are key to this report.
The ball is now in your court and you need to find a way presenting this data back to James.
SUBMISSION DUE DATE - Sunday, 12th July 2020 (PST)
Please can you all submit your PBIX files to firstname.lastname@example.org
Objective: Produce a report which gives James insight into the consultation process.
The data set can be downloaded below.
Challenge 3 Data.xlsx (65.5 KB)
Best of luck!
Any issues or questions please reach out.