Power BI Builds 3 - HR Data Insights

[sam.mckay]

I’m excited to get into this one. Going to get started shortly.

Remember if you want to maybe get your report showcased on Enterprise DNA TV, make sure to record your screen as you’re working on your solution.

Sam

[sam.mckay]

I had a lot of fun thinking through this challenge.

Here’s my submission

Publish to web

Power BI Report

I’ll do a bigger write up in the project category soon.

I actually created hardly any measures for this challenge. It was all about setting up my model and then building a nice visualization that I thought showcased what the manager was after in the scenario.

For some reason the table has been updating a bit slow on me recently when selections are made so I’ll have to look into this.

There’s was a few other touch ups I thought I could make but have already spent a few hours on it so wanted to move on!

I actually recorded most of my development for this one and will post it to Enterprise DNA TV soon.

Let me know what you think

Sam

[haroonali1000]

Very nice Sam.

Love the use of the legend that matches the colour scheme.

Great visualisation showing the 1st and 2nd interview split.

Looking forward to reading the write up.

Haroon

[sam.mckay]

I’m excited to see some more submissions coming in the next couple of days

[sunip]

Here is my submission:

[https://app.powerbi.com/reportEmbed?reportId=7c61869c-79a4-4148-a001-dfd20f285209&autoAuth=true&ctid=5916d88a-baa6-44fa-bdb5-94b954e98df7&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLWNlbnRyYWwtYS1wcmltYXJ5LXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9

Simple measures and calculated column on a table to get the final outcome.

[Greg]

Hi eDNA. Thanks for setting-up and hosting this design challenge. Here’s my submission. I’m looking forward to the eDNA Team’s general comments on the submitted design approaches. Thanks, Greg

[haroonali1000]

Nice work @sunip and @Greg some awesome reports .

[Luke]

Here is my submission (and first post on the EDNA forum)

I have been learning PowerBI this year and don’t have any formal experience so welcoming any and all feedback!

Report link

Loved doing this challenge. Great to have a real world scenario provided. Keep 'em coming!

[sunip]

@Greg
Nice work. How did you do, Reset Slicers?
@sam.mckay @haroonali1000
It would be helpful if we can upload pbix files after the contest is closed so that we can download and learn from other’s work.

[sunip]

@Luke
Nice work, Luke. Keep going and we all are learning

[Greg]

Hi @sunip. Just a normal button with “Reset” icon shape and “Bookmark” action, to activate the “Reset Slicers” bookmark I made. Greg

[JarrettM]

Here is my submission for the 3rd Challenge. Did this without creating any measures. I’m away on holiday, but put this together pretty quickly!

Here is weblink:

Power BI Report

Thanks
Jarrett

[sunip]

@Greg
Thank you, Greg!

[BrianJ]

Due to a very busy week on the forum with a unusually high number of very difficult questions, plus work on the Enterprise DNA TV YouTube videos, I just didn’t have the time to put together a full entry on this challenge. However when I started putting my entry together, I pulled on what I think is a pretty interesting thread that I haven’t seen addressed in the other entries yet so I wanted to share it here.

My first thought in looking at the interview data was “are these data are reliable and valid”? ( Reliability addresses the consistency of a measure, and validity adddresses the accuracy of a measure. This graphic is a good illustration of the difference between reliability and validity:

In analyzing reliability and validity, I first created a numeric metric called Internal Consistency Score Squared (ICS Sq). For each interview, Unhappy was assigned a score of -1, Neutral = 0 and Happy = 1. I then took the difference of the Interview #1 and Interview #2 scores and then squared the difference, to put an increasing weight on larger deviations. ICS Sq has a max value of 4 (if one interview was scored Happy and the other Unhappy, or vice versa) and a min score of 0 (if the score for Interview #1 and #2 was the same). Every single step deviation (e.g, Unhappy to Neutral, Neutral to Happy, etc) gets a score of 1,

To assess reliability of the interview process, I compared the average ICS Sq for Interview #1 and Interview #2:

Results don’t get any more reliable than that. So, on to validity…

In terms of “accuracy”, we don’t know what each interviewee’s “true” score is, since there will be some natural variability in peoples’ scores. This variability could be due to additional consideration given/information acquired between the first and second interviews, peer and/or supervisor interactions, or factors completely unrelated to the relative merits of each policy (e.g., interviewee had an excellent breakfast and a traffic-free commute before the second interview, or conversely a loud argument with their surly teenage kid…). The key issue in assessing validity here is to make sure that the interviewer is not injecting their own variability/evaluation bias into the interview process. Fortunately, within the data we have an excellent control and experimental groups with which to explore this issue, since a little over 20% of the interviews were conducted by the same interviewer for both interview #1 and #2.

So, the first thing I looked at was whether average ICS Sq score differed by whether the interviews were conducted by the same interviewer or not:

Average scores were slightly lower when the same person did both interviews, but the difference was not statistically significant.

So, what about if you break this down further by interview?

Exact same result as above, and not statistically significant.

Now, what about individual interviewer effects?:

Some slight variability, but not even close to statistically significant.

And what if we break this down further by interview?

Again some variability observed across interviewers, but not approaching statistically significant.

So, we can sign off on validity as well, right? Not quite - we still have one more comparison to look at, and that’s the interaction between same/different interviewer and individual interviewers:

And this is where the red flags go up and the alarm bells go off, since Maria’s scores are exactly 75% higher when she is paired with another interviewer than when she is doing both interviews herself. This effect is statistically significant at the p = .06 level, and this is likely not a small sample size-driven finding, since Maria conducted 315 total interviews (2nd most) and for 25.5% of them she was the sole interviewer. When Maria is removed from the data and the analysis rerun, the differences do not approach statistically significant.

BOTTOM LINE
There is good reason to be concerned about the validity of Maria’s interviews. Before making any policy decisions based on this data overall, I would look at all the results both with and without Maria’s interviews included (i.e., include an interviewer slicer with which we can recalculate our report including and removing Maria).

• Brian

[alexbadiu]

Please find below my first Challenge submission. Open to any constructive feedback.
Best regards

Power BI Report Link

[Mohammed_ali]

My submission to this challenge, any suggestions/feebacks are most welcome.

HR Data Insights - Employee Survey on Company Polices

Power BI Report

[Martin]

@alexbadiu Nice visualization idea! I like the bookmarks to the findings on the first page.

[BrianJ]

@alexbadiu,

I agree with Martin - really like the modified heatmap on page 1. Very creative, information-rich visualization that I haven’t seen done exactly in this way before.

My one constructive suggestion would be to apply a different sort order to your stacked bars on page 2. Instinctively, I think people expect the order to be unhappy on the bottom, neutral in the middle and happy on top.

Overall, really nice job.

• Brian

[Martin]

Excellent analysis, @BrianJ ! Whenever looking at survey result, I should request this kind of data first before paying attention to further outcomes.
This brings me to the question: Is this data random? I just had a look at the correlation between first and second response and in a real world scenario I would expect that employees that don’t change their mind dominate (= largest bubbles along the diagonal axis). Actually, this is my personal hypothesis. If this is real world data, then it would proof my hypothesis wrong:

[DianaB]

Hi All,
This is my report for Challenge 3. I am not too much into the dark side and I am a little minimalist, but this time I did something different. In my last showcase from Sam, I learned about buttons, so I wanted to use buttons, you can click in the buttons to change page. So, this is the result, I hope you like it and any feedback is welcome.

I did not record my work, is not like I sit and do everything at once, I am busy during the week, so I did it in the weekends.
Last weekend:

1. I read the Challenge and download the data.
2. I create my Power BI dataset (Measures and Dimensions), the data was very strait forward, so I did everything in Power Query.
3. I review the information provided to see what kind of insight we can get from the data.
   This weekend:
4. I look from some inspiration for my design. I created my background in PowerPoint and I use the Color Theme Generator Tool to create my theme. I love this tool I am using it all the time.
5. I sketched out some ideas to see how to order the information on the space.
6. And finally, I started the report, the fun part, I created a very simple Measures, I did some adjustment to my design and Voilà!!!
   I use Power BI Server from work, but I cannot publish personal reports there. I do not know how to publish my report in another place so you can access, any recommendation is welcome.

Thanks, and have a wonderful summer.