ServiceNow Weekly Analysis Dashboard

High Level Design

Overview

ServiceNow is one of the widely used IT Management systems in the world by many of the enterprise customers to have a one-stop for all their IT related activities. The major use of the application is to manage the tickets that the users create when they have an issue with their IT services or even if they want to replace any of their IT assets. Depending on the priority of the ticket or the incident, they are given an ‘expected to complete’ time-based on the Service Level Agreement (SLA).

In any organization, solving the incident before the SLA breaches is the prime responsibilities of the IT engineers who are working inhouse or the third-party company that manages the IT services/maintenance of the organization. These IT organizations also manage a lot of other applications to manage different functions of their business and there would be different teams working to making changes to the design of these applications – both frontend and backend designs.

Whenever there is a change that needs to be implemented in the Production instance of these applications, then the development team submits a change requests which would then be tested, reviewed, authorized and then implemented in the production instance by a set of admins. ServiceNow supports this process seamlessly by maintaining these stages and involving appropriate IT admins in the various stages.

Goals

To understand the current state of the different types of incidents raised by the IT users and also analyze how well the SLAs are handled by the IT agents which would give a good overview of how the team has been prioritizing and performing to the Mangers and Directors of the IT team. Also need the ability the types of change requests that need attention and are raised with the highest priority, so the business functions are not hampered by the pending change requests. This will help the various owners of the applications within the organization to take a look at this dashboard to know the weekly status.

Objectives

• Analyze how well the SLAs are handled and have a weekly check on how many SLA breaches happen
  • Based off this, the directors could redesign the SLA hours based on the priorities
  • The high-level management can also understand if there is any agent who is continuously slacking on solving the incidents within SLA – Performance analysis
• Study the incident distribution raised by the IT Users and understand the efficiency of the Agents team
  • The manager of the team could alter the assignment rules of the tickets to Agents based on this study
  • Also, plan with the existing manpower to close the tickets based on the tickets open more than a week
• Ability to identify and prioritize the change requests based on the volume in each type and, figure currently in which stage, most of change requests stagnate
  • The application owners can reach out to the Admin if more tickets are being stagnated at one stage

KPIs Architecture

Entities Relationship Diagram

Plugins & Scripts

1. Plugin : BloX (V2.1.2)

There is an image used that is available in the “Source Files” folder which needs to be pasted in the following location “Sisense\app\plugins\BloX\blox-images\IndicatorCenter” and the name of the image is “ServiceNow.png”

2. Plugin : Custom Bar Column Chart
3. Plugin : Style Widget Title
4. Others: In the admin settings, the start of the week is set to be Monday