Power BI Challenge 8 - Jira IT Service Desk Analysis Entry from Zoe

Here’s Zoe’s entry for Power BI Challenge 8. @datazoe, would you like to share how you built this dashboard and what your inspiration is in building it?

image

image

image

image

Here is the link to the report:

To learn about the real-life scenario presented for the challenge, be sure to click on the image below.

power-bi-chal-1

3 Likes

Overall

The report was to provide insights on the tickets created in JIRA for the IT department.

Design

Lately I’ve been trying to improve my report design so I decided to use a design toolkit/template from numerro.io, which was awesome. They do have a try out demo one available if you are curious.

Colors

It comes with a few color palettes and I chose their red/black because I rarely use those colors.

Icons

The icons are from https://remixicon.com/.

Charticulator

I used https://charticulator.com/ again and this time to create the radial bar charts. I saw these on @Greg’s submission (though his were in python) and realized I could do that in charticulator. I wrote a short run through of what I did on my site. I tweaked these for hours!

TTR by Isssue Type (2).chart (28.1 KB)

You can open that chart file above in charticulator and pick up right where I left off.

And here is some more info and examples of that type of chart: https://datavizproject.com/data-type/circular-bar-chart/

Report

The navigation panel is really neat and wasn’t too difficult to set up and adjust to my report.

Navigation/Panel

These were part of the template and moved the slicers off the page, and I customized the text on each page. The slicers are all linked.

Ticket Overview

Here is an overall summary, with quick view of volume over time, how many are currently not done, how many were overdue, and summary of the time to resolve by issue type in the radial bar charts.

I originally had a table instead of those radial bar charts, but the data is much more accessible in the charts. There is some caution in using the radial bar charts as the bars get smaller the closer to the center (even if they are the same value), but I think they look awesome.

The top arches also include a smart narrative hidden by that little “T” in the top right hand corner:

There is also a distribution of the ticket priorities using a number of DAX measures to pull it off. It’s not as interactive so I am not sure I like it, but it does give an idea of the distribution nicely.

Ticket Patterns

The patterns looks at trends over time with issue type in a ribbon chart (which I love). I also used a ribbon chart to show the overdue/waiting for tickets. These are probably the most actionable by management, not the assignee, which is why I included it. They can follow up and make sure these blockers are removed. Overdue was chosen because those are the higher priority for management as well.

I have a scatter on top, with quadrants determined by average volume and average time to resolve.

Time to resolve trends are also included, and again I provided the average line for reference as there was not stated target.

Ticket Issues

These data issues were actually determined in Power Query.

Which I then followed up with another column to give them a number (so I could highlight them in the Ticket Detail table too).

Afterwards, I thought it may have been best to do them in individual columns so I could call out tickets with multiple issues. But at least this way when I showed volume of issues there were no duplicates.

I gave a summary of how many tickets with issues, and what % of the tickets were with an issue to show how widespread of an issue it was, and included the % of assignees that also had tickets with data issues. This would be to see if it may be something that only a few people are doing, so could maybe be resolved with a meeting only with those, or if it’s with everyone, then perhaps a mandatory training session would be more advisable.

Ticket Details

This is really the drill-through page but I used it frequently to get into the details of the data, so I made it accessible from outside of drill-through too. Here I bucketed the TTR too.

I highlighted some of the ticket issues here in the brightest color, so they were also hard to miss. I did consider icons or a legend too, but I stuck with the simpler approach.

Thanks!

Again for this wonderful challenge, I love seeing all the other submissions!

3 Likes

Awesome work on this Zoe. I was so impressed by your design when I first saw it. I thought it was so innovative how you had built the navigation and it looks so clean and modern.

And you know I’d never heard of numerro before but that is actually an awesome idea. I feel like they have created something that we could do ourselves especially in the Analyst Hub. We could create these types of templates ourselves and add that as part of the Analyst Hub. So thanks so much for giving me this idea as I can see how it can speed up and improve various aspects of reports development and design.

I really like your choice of visuals here as well especially with the multi layered donut charts. It just tells a really good story within the reporting application you have developed. And that’s ultimately what you want to do with Power BI you want to tell good stories. You want to be able to showcase and unearth the key insights out of raw data and then compel consumers to engage with it and make superior decisions based on it. I feel like you’ve nailed all of those aspects with this particular report so well done.

Sam

4 Likes

@sam.mckay Thanks for the kind feedback! I am super impressed by what numerro has done, and the more I play with the toolkit, the more I like it. Your reports all do have a similar design to them, so it would be interesting to see if you could toolkit it.

Power BI does have the grid which is similar to their canvas. I’ve been playing around with the new mobile views in Power BI and the grid there is really nice to use now they have made it smaller and allowed overlapping of visuals. I then tried to use the regular view grid and couldn’t figure out how to make the grid smaller and gave up ha.

@Greg deserves all the credit for those donut charts! I saw them on his report and decided they were the coolest thing and I needed something other than a table for those TTRs by Project/Issue Type.

2 Likes

Hi @datazoe,
Is the .pbix file available for this report as I was unable to locate it. Thanks.

we can get pbix file of this dashboard?