Power BI Builds 3 - HR Data Insights

Challenges HR Data Insights
47

Brian this is such epic thinking. I would have never have thought to look at the data like this, but after reading through your notes it makes a lot of sense.

I really love how you thought out of the box on this one, and it’s amazing what diversity in thinking you can have for the very same problem, for example the challenge that we are putting together and the scenario that we are working on.

This diversity of thought is what is really going to take our members analytical abilities and critical thinking to another level.

Reading this it just makes me think how we can extract as much information out of your brain as we can without placing any more burdens on your time! Appreciate your efforts on this and I’ve learnt something and feel smarter from reading through your thought process here.

Sam

4 Likes
48

Wow @BrianJ seriously awesome share thank you! Not something iv’e come across before but makes so much sense definitely something to consider going forward.

49

Great work all again some outstanding submissions. There is still time to submit if you haven’t yet done so.

Regards,
Haroon

50

Being a self learner, started learning Power BI from Enterprise DNA and a lot more to learn with awesome work done by others in these challenges.
@sam.mckay @haroonali1000
Thank you Enterprise DNA team for the initiative and your time!!!

51

@sam.mckay,

Thanks very much for the kind words. I think years of working on litigation has drilled into me that before asking the question “what do these data mean?” it pays to ask “are these data any good?” (e.g., from the standpoint of internal consistency, data collection/sampling approach, calculation methodologies, etc.).

I think you hit the nail on the head in terms of the incredible value of diversity of thought. My favorite posts on the forum are always those where four or five people post different solutions to the same problem. These data challenges are that same thing taken to the nth degree. Having people from all over the world, with different jobs, skill sets and perspectives working on the same problem with the same tools is really pretty amazing when you think about it, and I find I learn something from every single entry submitted in these challenges.

Glad to have the opportunity to contribute to that learning with perhaps a different set of experiences and perspectives. Plus it’s given me a bunch of new ideas for videos… :wink:

  • Brian
4 Likes
52

Thanks @BrianJ, @Amdi, and @sam.mckay for your comments.

I little bit of my thinking while I built this report
Data Modeling : Steps for creating my dataset in Power BI, this was my quickly thinking, I can be wrong.

To normalize the data, we need to eliminate data duplication and ambiguity as possible.

In this data set we have that our measure or numeric values are the interview Outcome, the count of Happy, Neutral or Unhappy answers by different point of view, this point of view are my dimensions. So, we can see the outcome by interview, date, interviewer, consultation, Employee Name and Region.

From the source file I created a unique value for my dimensions.

For the measure I isolated interview 1 and interview 2 and then appended the two queries and got my Interview table, in this table also keep my key values to make my relationships with my dimensions: Consultation ID, Employee ID, and Interviewer ID.

I have a code for the Dates dimension (from Enterprise DNA) that I use always that I need a Date dimension.

At the end, my dataset looks like:

ds
ds867×587 14.2 KB

For me a report is about Questions and answers. In this case I think the main question is who is happy, neutral, or unhappy, and where and when, and the most important is Why so we can take an action to improve, assuming we want them happy. We do not have data to answer the Why, so I designed my report to answer the other questions.

Summary View, that maybe I should call it Overview, thanks Martin for your comment.

  • Overall view of the three measures (Happy, Neutral, and Unhappy)
  • View of the changes from Interview 1 to Interview 2

Detail View, in this view we can see the result by Employee, I order to see first the top more Happy, Neutral, or Unhappy, again I added lots of filters to have the option to see the data from the different points of view.

Trend View, in this view I wanted to show how happy, neutral, or unhappy the different dimensions are. Also, the participation in the different interviews, having a second look at this view I think I could do something different, but we can always improve.

I did not make a more deeper analysis of the data, there is so many components that we can look at that as I said, we can always improve, at the moment I am trying to improve my knowledge in the use of Power BI. Always is good to learn how others think. Two heads think better than one.

Report Design . For this I use PowerPoint to create the background and I always sketched out some ideas on paper before start on the computer, to see how to use the space and have an idea of the order and size. For the theme I look at some pictures in internet that give the color idea.

I love this kind of assignments; I like to analyze data and convert the data in visualizations that can tell a story. I also love to learn new things

Here is my solution PBIX report.

HR Data Insights - Diana Bello.pbix (363.9 KB)

Thanks,

DianaB

10 Likes
53

Awesome write up @DianaB thanks for sharing very insightful. :slight_smile:

1 Like
54

Well done Diana. Superb write up. Really like what you did with the fact table. And the navigation…wow.

1 Like
55

I think the clarity around the outcomes is great, and the simple icons you’ve used make it easy for the eye to comprehend

image
image1314×722 93.9 KB

4 Likes
56

@DianaB
Great work, Diana! Can you please elaborate on the details of the Navigation.

57

Hi,

Thank you very much to all for your encouraging comments. I really appreciated, I feel motivated to continuing participating; this is an awesome opportunity to improve my skills and learning from very professional and smart people. I wish all the best to all of you.

@sunip

About the navigation. In PowerPoint I created a background to use in Power BI. Is a rectangle with a shadow, and a circle at the end, the trick here is to have half the circle visible, just look in internet for How to create a half circle in PowerPoint? I used a text on top of the circle, finally group all and I copy and paste to create as much as you need, in this case 2 more and put then to the left. Drag one by one from left to right to create the effect of moving in the following slices. I read this in some place in internet some time ago, I just do not remember where.

PP
PP1277×748 46.1 KB
PP2
PP21218×727 22.5 KB

I change the colors and titles to use it in this presentation and save it as jpg.
I added the pictures in Power Bi as the background of my pages and put a buttons on top of the tiles, I make the buttons invisibles and added the action to the buttons, you can see that in the PBIX

Thanks,

Diana

9 Likes
58

@DianaB
Awesome! Thank you for the details!

1 Like
59

Incredible creativity!

60

Very nice report, however, I cannot navigate to the link.

61

Reset slicer approach is typically, set the slicers to whatever ‘reset’ position you like, create a bookmark (with the correct data setting … I never know what is what until I try), and then assign the bookmark to the image action. This will go to the bookmark with the default data setting / slicer setting.

1 Like
62

@sunip See above for reset slicer tip.

63

@Greg
Hi Greg,
I love your clean report. Complexity with simplicity, a very elegant solution. well done.
A few questions:
Is the text in the top left box dynamic? If so I would love to know how you did it.
I also love the bottom section which you show the selections from the slicers. Is there any chance of you posting you pbix for inspiration and learning?
regards
John

64

Hi @jgriffit

Thanks for your kind words.

Yes (kind-of) the text in the top left box is dynamic. I used the Enlighten Data Story custom visual, where you can insert measures into a pre-defined text story; so the measures are dynamic, but the text isn’t. I’m hopeful a newer version of the custom visual will allow for dynamic text too.

Here’s a link to my write-up of my thought process

Here’s my pbix.
eDNA Challenge 3 - HR Data Insights - Greg Philps.pbix (582.5 KB)

Thanks again.
Greg

2 Likes
65

Thank you, I did tried and it worked.

66

Thanks @Greg. Scouring your beautiful solution today … my idea of a great Sunday!