Power BI Builds 3 - HR Data Insights

BrianJ · July 3, 2020, 8:59pm

Another excellent, challenging scenario.

In my preliminary data review, I think I may have found a problem. As I understand the scenario, each consultation should have two interviews per employee. However, there is no consultation C004, and for each employee there are two different C005 rows. I strongly suspect one of these should be C004. How should we handle this?

Thanks.

Brian

sunip · July 3, 2020, 10:38pm

@haroonali1000
Yes, C004 is missing and each employee has two C005’s

Neba · July 3, 2020, 10:53pm

@BrianJ , @haroonali1000 ,

I think there are four consultations with Ids C001,C002,C003 and C005 and one of the consultations ( C005 i.e Safety ) has been interviewed twice ?

haroonali1000 · July 4, 2020, 10:34am

Thanks @BrianJ @Neba and @sunip.

An error while anonymising the data.

I have updated the excel please get the latest.

Any issues shout.

Haroon

BrianJ · July 4, 2020, 1:59pm

@haroonali1000,

Great – thanks for the quick update. So this one is based on a real-life case? I’ve been wondering how you come up with the ideas for these challenges.

Brian

Martin · July 4, 2020, 5:23pm

Hi!
Here is my initial contribution to a Power BI Challange. I’m using plain vanilla Power BI functionality. Feedback welcome!

The details page is also available as a drillthrough from the summary page.
File submittedted to powerbichallenge@enterprisedna.co
I’m curious to see how you are doing in this challenge!

BR
Martin

BrianJ · July 4, 2020, 5:54pm

@Martin,

Wow! Talk about throwing down the gauntlet. Phenomenal report and absolutely gorgeous design submitted over a week early. Well done!

Brian

Greg · July 4, 2020, 6:57pm

Hi @Martin

Wow x2! The bar has been set high (and quickly). Beautiful!

… hmm, lots of work to do …

Greg

sunip · July 5, 2020, 1:05am

@Martin
Awesome with quick turnaround!

sam.mckay · July 6, 2020, 9:00am

Super work on this. Great example to kick off this challenge

haroonali1000 · July 6, 2020, 1:15pm

No problems. Great question @BrianJ and yes they are based on real-life cases. I will hopefully include some background in the wrap up.

Regards,
Haroon

haroonali1000 · July 6, 2020, 1:18pm

Welcome @Martin to the power bi challenge and what a start.

A super submission with some great insight.

The standard has been set!

Regards,
Haroon

sam.mckay · July 7, 2020, 11:50pm

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 · July 8, 2020, 4:25am

I had a lot of fun thinking through this challenge.

Here’s my submission

Publish to web

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 · July 8, 2020, 1:41pm

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 · July 9, 2020, 10:40pm

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

sunip · July 10, 2020, 12:36am

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 · July 10, 2020, 6:02pm

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 · July 10, 2020, 10:26pm

Nice work @sunip and @Greg some awesome reports .

Luke · July 11, 2020, 3:24am

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!