ITSM Analysis Dashboard / Service Desk Management Analysis Dashboard
Originally published: 25/10/2021 12:58
Publication number: ELQ-88638-1
View all versions & Certificate
certified

ITSM Analysis Dashboard / Service Desk Management Analysis Dashboard

ITSM Analysis Dashboard / Service Desk Management Analysis Dashboard using Excel and pbix

Description
This is an ITSM Analysis Dashboard / Service Desk Management Analysis Dashboard.
Pages:
In this report, we have the following 4 pages.
1. Home
2.Open Cases Analysis
3. Services Users Analysis
4. Pareto Analysis
5. Summary

KPIs:

In this report, I have created the following KPIs.
1.Created Cases
2.Users
3.Open Cases
4.Closed Cases
5. Resolution Duration Days
6.Open Cases Duration Days
7.Requests
8.Incidents
9.High Priority Open Cases
10.Low Priority Open Cases
11.Closed Cases Per Assignees
12.Created Cases Per Users
In which you will see I have used custom tooltip for Pareto Analysis.
Process:
In which the data source is an Excel file. First I have uploaded excel data into the Power BI file.
Then I did a little bit of transformation in the power query. Then created DAX measures for all above define KPIs. Then added background Images that I created in Adobe XD. Then created visuals as shown in the attached images.

Modification if Needed :

If you want any modification in background images or visualization, you can connect with me through Eloquens.

Deliverable :
I will provide you Excel dataset file and a power bi file in which all KPIs and visualization are present.

Usage:
You can use this report for Real Time project, learning purposes or entering into a competition or commercial use.
if you want to create any other domain reports then you can also let me know.
God Bless you.
Thanks and Regards
Muhammad Umair Shahid

This Best Practice includes
Excel Dataset file, .pbix file, Background Images

Acquire business license for $20.00

Add to cart

Add to bookmarks

Discuss

Further information

You can use this report for Real Time project, learning purposes or entering into a competition or commercial use.


0.0 / 5 (0 votes)

please wait...