Power BI Challenge 8 - Jira IT Service Desk Analysis

Hideo · October 26, 2020, 10:54am

Thank you for your warm feedback. It took some time for me to understand this Jira IT data set as they are not consistent. I recalled myself your Challenge7 analysis “Refocus on the essential” trying not to lose the destination I should reach. It is important for me what and how the constant high performer like you are feeling to build excellent report consistently. Nice to hear from you who I believe has the most talent of creativity and diligence.

Regards,

Hideo

haroonali1000 · October 26, 2020, 12:06pm

WOW WOW WOW!!!

Incredible work from everyone! Some of the techniques used and analysis generated are truly mind blowing.

A massive well done to everyone on your incredible reports.

I am looking forward to picking a winner .

Our community continues to blossom and with each passing challenge we are hitting some incredible heights.

The creativity on display is immense and real testament to the work you are all putting into the challenges.

#BestPowerBICommunityByFar

If you haven’t submitted yet there is still time, so please do so as soon as you can.

Once again awesome work , speak to you all soon on the wrap up.

Thanks,
Haroon

MudassirAli · October 26, 2020, 12:28pm

@Gifted I like the way you categorized by situation, project name and duration. This immediately highlights which project has the highest issues and take longer days to be resolved. One thing I would advise is to make the slicer as dropdown and use that space to include one more visualization for your analysis.

Good Work!!

MudassirAli · October 26, 2020, 12:36pm

@Neba Great Report and nice looking Key Findings Page. I guess White & Blue color really stands out. I have seen some videos about Calculation Groups in Tabular editor but haven’t really dived into that yet and you have made really good use of the editor.

P.S. This made me laugh really hard

MudassirAli · October 26, 2020, 12:42pm

@bradsmith
Wow that’s one way to look at data. Really amazed how you came up with Average Age calculation. However, my only concern is that the report was expected in English Language

Neba · October 26, 2020, 1:16pm

@MudassirAli , Thank you for your kind words. This is the first time I used calculation Groups and they are awesome. Especially for Time related calculations using the same measure like Sales LY , LM , LQ etc… .

BTW I was watching some YouTube videos about Charticulators after I saw the discussions about them in the Forum. Interesting stuff.

P.S. I can’t wait for your interview with Sam on your work.

Nebiyu

DavieJoe · October 26, 2020, 1:20pm

Really, really love the report @datazoe . The EDNA Challenges are really fantastic inspiration. Really love how the Challenges take you through from the basic data all the way through to a final report, the write ups are absolute gold dust. I’ll hopefully set aside some proper time to complete the next challenge.

MudassirAli · October 26, 2020, 1:25pm

@alexbadiu
Your reports always have one thing constant and that’s Elegance , combined with great analysis, navigation, interactivity and last but not least the ability to narrow down the scope to focus on the root cause has always been the highlight.
Really good use of the colors in this one and love how you placed the charts inside the circle shape. The one that says HD, actually looks like HD (High Definition)
This one is Special:

If I am not wrong, this is the Area Chart right?

bradsmith · October 26, 2020, 1:31pm

For the topic modelling? Oh I just chose English because that’s my native language haha plus, then I could use the same module in Python for the k-means clustering, topic modelling, and anomaly detection.

I hadn’t thought about it before but… I could probably have it detect the language the program is using, return that as the corpus language, and perform the same calculations… but I’d only be confident in being able to validate the findings if the language was either English, French, Italian, Spanish, or Mandarin as those are the only ones I am comfortable speaking and thus building a quality corpus. I have some experience with Russian and Arabic, but not enough to be able to validate my findings or tune the model. If I had a native speaker of whichever language though I could replicate this process for any language. Technically though, the script is using unsupervised learning… so as long as I had a corpus for whichever language then I could do the same for any language…

Sorry, that was just me thinking out loud haha I really like that idea so I was trying to think out how to do it. Essentially I could make it compatible with any language.

MudassirAli · October 26, 2020, 1:35pm

@bradsmith LOL Good ONE!
The terms and the types of analysis you have used are new to most of us. We will have to dig in deep to understand what you have done and how you have done. Waiting for your write-up though

alexbadiu · October 26, 2020, 1:42pm

Thank you for your feedack @MudassirAli!
The graph you pointed out is actually a simple stacked bar chart using Cumulative Totals of tickets created and status on legend.

datazoe · October 26, 2020, 1:51pm

@DavieJoe Thank you! I used numerro.io’s template for this submission, which has really helped me understand the importance of space in a report. And I agree, these challenges are awesome! Looking forward to seeing what you create for the next challenge!

Senabiz · October 26, 2020, 3:24pm

Excited for the Challenge 8 Wrap up. Power BI Challenge 9 will be my first challenge!

BrianJ · October 26, 2020, 3:31pm

@alexbadiu

I love this report. Because your designs are always so striking and creative, I think the quality of your analysis sometimes gets overlooked. However, while this design is beautiful as well, I think the user experience and the analysis really shine through here. Much the way that @Hideo’s report really engaged me to dive in and explore the data, yours did the same and the level of thought that went into the user experience in this report is evident. Also, the report does a wonderful job providing recommendations and areas for focus, and ties them together in a really clear way with the results of the analysis.

Really inspiring, and so much to consider and learn from here. Awesome work.

Brian

DavieJoe · October 26, 2020, 3:58pm

I’ve checked out Numerro, looks pretty helpful. Did you purchase it personally or did you go through your employer?

alexbadiu · October 26, 2020, 4:02pm

Thank you for your feedback @BrianJ ! The user experience is always a priority for me when I create reports. It takes a lot of energy and thought but I am sure it s worth the investment. The data story and user journey in a report is a challenge to build every single time. I am glad I can participate to EDNA challenges and get to test and push myself to improve.

MudassirAli · October 26, 2020, 5:05pm

@Senabiz
Welcome to the amazing EDNA Power BI Community.
If you have time, you can get started with this challenge’s dataset. It will help you a lot for the next one.

datazoe · October 26, 2020, 5:14pm

I purchased it, but they have a free demo one too.

tweinzapfel · October 27, 2020, 11:43am

@MudassirAli - I agree with the others - a fantastic report. The page showing the performance comparison among the staff was something I was thinking about but really like how you displayed this.

Great job!

-Tim W.

DavieJoe · October 27, 2020, 1:10pm

Greg:

Status Category = 
VAR _DoneList = { "Canceled", "Closed", "Completed", "Done", "Resolved" }
VAR _InProgressList = { "Awaiting Verifier", "In Progress", "Verified", "Waiting for customer", "Waiting for support", "Work in progress" }
VAR _ToDoList = { "Accepted by Assignee", "Awaiting IT Security Course Completion", "Open", "Opened", "Pending", "Waiting for approval" }

RETURN
SWITCH( TRUE(),
    'Status'[Status] IN _ToDoList, "To Do", 
    'Status'[Status] IN _InProgressList, "In Progress",
    'Status'[Status] IN _DoneList, "Done",
    BLANK()
)

I’ve started to use your technique for using Variables with IN and the Switch statement, really nice and easier to read.