*Please note this is in progress according to the ongoing Dashboard improvements*

Table of Contents

  1. Introduction
  2. Accessing the Dashboard
  3. Navigating the Dashboard
  4. Support

1. Introduction

Welcome to the DT DASH - Data Availability Starts Here. 

The goal of this dashboard is to prvide day to day useful DT information from a user friendly perspective, in near real time (1h refresh) and at a click, hence improving transparency, supporting daily tasks and easing data-driven decision-making.


This guide will assist you in navigating and using the dashboard to access and analyse key DT data, based on insights provided (this is a continuous improvement Dashboard, so additional features are expected to be added, enhancing its analytical capabilities).


2. Accessing the Dashboard (for all DT DASH views)

To access this Qlik Sense dashboard, follow these steps:

  1. Open your web browser and go to Qlik Sense Solvay Hub- link here.
  2. Log in using your company credentials.
  3. Once logged in, you can search for DT DASH.


By default, you will have access to the page called DT DASH: Your Single Point of Contact with DT

Depending on your role within Solvay, you can eventually ask to have access to other pages - currently available: DT DASH: Site Control Tower (for Site Managers and Country Managers). Planned pages: DT Owner / Manager View.


Tip: You can add this dashboard to your Qlik favorites by clicking on the star in the up right corner of the DT DASH image:



Installing DT DASH on Mobile

To install DT DASH on your mobile device:


  1. Enter the Personal Area in your phone and scan the QRCode.

     

  2. Click on the Plus button.


                     


         3. Copy the following link: https://qliksensedesign.solvay.com/solvay/sense/app/a558632d-7a0c-4324-aafc-ad6f404c9ab5/sheet/bca3d89f-c5b5-4f72-b960-e8664ac1c197/state/analysis

         4. Tap on the Enter button and enter your login, password, and third-level authentication details.



Tip: You can rename the dashboard for a better user experience.



3. Navigating the Dashboard


PAGE FOR ALL USERS >  DT DASH: Your Single Point of Contact with DT


Information is updated every hour - you can check the last reload time on the top right:

             


Ongoing and Resolved Major Incidents

Imagine starting your day knowing exactly what’s happening in DT. Here you’ll find any ongoing major incidents and those resolved within the last 24 hours. It’s your go-to spot for staying updated on critical issues affecting DT services.

DT Weather

Just like a weather forecast, this section gives you an overview of the health and performance of all DT services with the related details.

Network Speed

Need to know how fast things are moving in your site? This gauge shows you the current network speed for your site, like checking the speedometer of a car. If it’s in the green, you’re good to go!



Coming Soon:

Maintenance: Future updates will be posted here, giving you a heads-up on upcoming maintenance schedules.

Application Status (Coming Soon): Ever wonder if an app is having issues? This section lists the status of various applications, so you know if everything’s running smoothly or if there’s an issue.




Three filters to quickly access the tickets list and its details



Below it, you find a table with more details about the corresponding requests, resulting from the selection done in the three previous filters:

       


Tips: You can move the order of the columns to better fit your needs - just click and move it. And besides the quick filters, you can search directly for any ticket using the magnifying glass on top of each column in the table.


Direct Hyperlink from Service Request ID to Service One request page 

The Service One Request column contains a direct hyperlink for each request. This feature is designed to streamline your interaction and improve efficiency.

How It Works

Benefits




                                                                                   

You can find in that section information related to the average time that your site teams are taking to resolve requests:

                                         



You also have direct links to this User Guide, and to Service One pages to report IT issues - for any application (Report an IT issue) or for this dashboard (DT DASH Hypercare Issue):

                               


This Dashboard is in continuous development to answer your needs, so your inputs are critical - you can use the GForm to provide feedback and any extra information you would like to see here:

                             






Here the user can find the below KPIs:


Total Incidents and Service Requests in <user site>
  • The current total number of incidents, from the total Backlog in the user site, that are yet not resolved, closed or cancelled.
Incidents
  • The current total number of Incidents, from the total Backlog in the user site, that are yet not resolved, closed or cancelled.
Service Requests
  • The current total number of all Service Requests except Incidents from the total Backlog in the user site, that are yet not resolved, closed or cancelled.
Local Average Time to Resolve a Service Request (days)
  •  The average number of days to resolve a WorkOrder locally, in the user site, considering the last 3 months timing until Closed and Resolved tickets status.
Submitted Today in <user site>
  • This shows the total number of tickets submitted today in the user site.
Incidents
  • The current total number of incidents, from the total tickets submitted today in the user site.
Service Requests
  • The current total number of all Service Requests except Incidents, from the total tickets submitted today in the user site.













******************************************************************************************************************************************************************************************************************************************************************************************************************

- SITE MANAGEMENT VIEW -


The Site Management View is designed specifically for Site Management team members and other site management related users.

Each section provides specific insights and data points essential for monitoring and managing service operations.


The user site is  automatically identified upon user connection and the information shown is automatically filtered to the user profile corresponding site. However, in this DT DASH view the site management user can select other sites under his perimeter in 'Change site' , and the dashboard will show cumulative results.




Site-Specific Insights:

TO UPDATE WITH THE 2 SEPARATE SECTIONS + THE TREND KPI


Created Incidents (Last Calendar Week)

  • Displays the total number of incidents created in the last calendar week.

Resolved Incidents (Last Calendar Week)

  • Shows the total number of incidents resolved in the last calendar week.

Incidents Average Time to Resolve (Last Calendar Week)

  • Indicates the average time taken to resolve incidents in the last calendar week.

Incidents Backlog per GBU

  • Indicates the number of incidents in the backlog per requester GBU

Unassigned Incidents Backlog (%)

  • Shows  the percentage of unassigned incidents compared to the total backlog.

Pending - Sub State Wise Backlog Volume

  • Breaks down the backlog volume by sub-state categories such as Infrastructure Change, Client Hold, Third Party Action Required, and Client Action Required.

WorkOrders Average Time to Resolve (Last Calendar Week)

  • Shows the average time taken to resolve work orders in the last calendar week.



In the table included below the KPIs, the site management user can find the list of all the tickets related to the selected site(s). Each entry provides detailed information including:


  • Service One Request ID
  • Request ID reference created automatically in Service One when the user raises the ticket. This is an unique identifier that can be alphanumeric (e.g., REQ000000xxxxxx or CASE-000xxxxxxx) or purely numeric (e.g., 1234567).
  • Type (Incident, WorkOrder)
  • Indicates whether the ticket is an Incident, a WorkOrder or a Case.
  • Fulfilment Number
  • A specific number associated with the technical fulfilment process.
  • Site
  • Refers to the specific location (e.g., CARNAXIDE) where the incident or work order originated or is being addressed.
  • Priority
  • Shows the priority level of each ticket (e.g., Low, Medium, High, Fastlaned).
  • Status
  • Indicates the current status of the ticket (e.g., Cancelled, Closed).
  • Description
  • Provides a brief description or purpose of the ticket, usually the same as the one entered by the user upon its creation but can have additional info according to the technical fulfilment process.
  • Submit Date
  • The date the ticket was submitted.
  • Resolved Date
  • The date the ticket was resolved.



Dynamic Table Functionality

In the DSDS View of the DT DASHboard, the table displaying detailed ticket information is designed to be dynamic and responsive to user interactions with the pie charts. Specifically, the table data updates according to the selections made in the following pie charts:

  1. Unassigned Incidents Backlog (%)
  2. Pending - Sub State Wise Backlog Volume

How It Works

  1. Unassigned Incidents Backlog (%)

  2. Pending - Sub State Wise Backlog Volume

Benefits of Dynamic Interaction

Example Scenario

If a site manager notices that a significant percentage of incidents are unassigned, they can click on the "Unassigned" segment of the pie chart to view all unassigned tickets in the table. This allows them to take prompt action to assign these incidents to the appropriate team members.

Similarly, if there is a backlog in a specific sub-state like "Client Action Required," the manager can click on that segment to see all relevant tickets, enabling them to address any bottlenecks or follow up with clients as needed.




Direct Hyperlink from Fulfillment Ticket to Helix Platform

In the DSDS View of the DT DASH, the Service Request and the Fulfilment Ticket Number column contains a direct hyperlink for each ticket. This feature is designed to streamline user interaction and improve efficiency.

How It Works

Benefits

Example Scenario

If a DSDS user sees a ticket that requires action or deep analysis, they can simply click on the Fulfilment Ticket hyperlink to open the ticket in Helix, provide the necessary feedback, and update the ticket, all in a few quick steps.

This direct hyperlink feature is aimed at enhancing user experience by providing a seamless connection between the DT DASHboard and the Helix platform, ensuring timely updates and efficient ticket management.




3. Troubleshooting






4. Support


For Access request, please raise a Service One request xxxxxx

For any issue or data inaccuracy identified, please raise an INCIDENT in Service One xxxxxx


*Please note this is in progress according to the ongoing Dashboard improvements*

Table of Contents

  1. Introduction
  2. Accessing the Dashboard
  3. Navigating the Dashboard
  4. Troubleshooting
  5. Support

1. Introduction

Welcome to the DT DASH - Data Availability Starts Here. 

The goal of this dashboard is to provide day to day useful DT information from a user friendly perspective, in near real time (1h refresh) and at a click, hence improving transparency, supporting daily tasks and easing data-driven decision-making.


This guide will assist you in navigating and using the dashboard to access and analyse key DT data, based on insights provided (this is a continuous improvement Dashboard, so additional features are expected to be added, enhancing its analytical capabilities).



2. Accessing the Dashboard (for all DT DASH views)

To access this Qlik Sense dashboard, follow these steps:

  1. Open your web browser and go to Qlik Sense Solvay Hub- link here.
  2. Log in using your company credentials.
  3. Once logged in, you can search for DT DASH.


By default, you will have access to the page called DT DASH: Your Single Point of Contact with DT

Depending on your role within Solvay, you can eventually ask to have access to other pages - currently available: DT DASH: Site Control Tower (for Site Managers and Country Managers). Planned pages: DT Owner / Manager View.


Tip: You can add this dashboard to your Qlik favorites by clicking on the star in the up right corner of the DT DASH image:



Installing DT DASH on Mobile

To install DT DASH on your mobile device:


  1. Enter the Personal Area in your phone and scan the QRCode.

     

  2. Click on the Plus button.


                     


         3. Copy the following link: https://qliksensedesign.solvay.com/solvay/sense/app/a558632d-7a0c-4324-aafc-ad6f404c9ab5/sheet/bca3d89f-c5b5-4f72-b960-e8664ac1c197/state/analysis

         4. Tap on the Enter button and enter your login, password, and third-level authentication details.


Tip:You can rename the dashboard for a better user experience.


3. Navigating the Dashboard


The information displayed is organised into three main areas: GLOBAL, LOCAL and My Requests clearly identified by the below images:



The GLOBAL and LOCAL sections of the dashboard are designed to provide to all users information on current figures of useful daily information like support tickets backlog, network connectivity status and Major Incidents, reflecting Global status KPIs (totals from all sites) and Local status KPIs (from user local site).  


In the LOCAL section, the user site is  automatically identified upon the user SSO profile site and the information shown is automatically filtered to the user profile corresponding site. This means that the user can be connecting in another site but the info displayed will be from its SSO profile site.


My Requests is fully dedicated to the tickets created by the user and it includes three filter buttons (described in detail further below):



USER VIEW > GLOBAL 

Here the user can find the below KPIs:


Total Incidents Today


Total Submitted Incidents Today




Total Incidents Today
  • The total number of incidents that have been submitted today on a global scale, all sites.
Total Submitted Incidents Today
  • The total number of incidents that have been submitted today on a global scale, all sites.




USER VIEW > LOCAL (Site: <user site>)

Here the user can find the below KPIs:


Total Incidents and Service Requests in <user site>
  • The current total number of incidents, from the total Backlog in the user site, that are yet not resolved, closed or cancelled.
Incidents
  • The current total number of Incidents, from the total Backlog in the user site, that are yet not resolved, closed or cancelled.
Service Requests
  • The current total number of all Service Requests except Incidents from the total Backlog in the user site, that are yet not resolved, closed or cancelled.
Local Average Time to Resolve a Service Request (days)
  •  The average number of days to resolve a WorkOrder locally, in the user site, considering the last 3 months timing until Closed and Resolved tickets status.
Submitted Today in <user site>
  • This shows the total number of tickets submitted today in the user site.
Incidents
  • The current total number of incidents, from the total tickets submitted today in the user site.
Service Requests
  • The current total number of all Service Requests except Incidents, from the total tickets submitted today in the user site.



USER VIEW > MY REQUESTS


This section provides a user-friendly interface to manage the user's requests efficiently. Here are the functionalities available:


TO UPDATE with screenshot including Expected Resolution Date upon its development



Cumulative to the quick filters, the user can search directly for any ticket using the magnifying glass on top of each column in the table.


Direct Hyperlink from Service Request ID to Service One request page 

In the User View of the DT DASH, the Service One Request ID column contains a direct hyperlink for each incident / request. This feature is designed to streamline user interaction and improve efficiency.

How It Works

Benefits

Example Scenario

If a user sees a incident / request that requires their feedback, they can simply click on the Service One Request ID hyperlink to open the incident / request in Service One, provide the necessary feedback, and update the incident / request, all in a few quick steps.

This direct hyperlink feature is aimed at enhancing user experience by providing a seamless connection between the DT DASH and Service One, ensuring timely updates and efficient incident / request management.



******************************************************************************************************************************************************************************************************************************************************************************************************************

- SITE MANAGEMENT VIEW -


The Site Management View is designed specifically for Site Management team members and other site management related users.

Each section provides specific insights and data points essential for monitoring and managing service operations.


The user site is  automatically identified upon user connection and the information shown is automatically filtered to the user profile corresponding site. However, in this DT DASH view the site management user can select other sites under his perimeter in 'Change site' , and the dashboard will show cumulative results.




Site-Specific Insights:

TO UPDATE WITH THE 2 SEPARATE SECTIONS + THE TREND KPI


Created Incidents (Last Calendar Week)

  • Displays the total number of incidents created in the last calendar week.

Resolved Incidents (Last Calendar Week)

  • Shows the total number of incidents resolved in the last calendar week.

Incidents Average Time to Resolve (Last Calendar Week)

  • Indicates the average time taken to resolve incidents in the last calendar week.

Incidents Backlog per GBU

  • Indicates the number of incidents in the backlog per requester GBU

Unassigned Incidents Backlog (%)

  • Shows  the percentage of unassigned incidents compared to the total backlog.

Pending - Sub State Wise Backlog Volume

  • Breaks down the backlog volume by sub-state categories such as Infrastructure Change, Client Hold, Third Party Action Required, and Client Action Required.

WorkOrders Average Time to Resolve (Last Calendar Week)

  • Shows the average time taken to resolve work orders in the last calendar week.



In the table included below the KPIs, the site management user can find the list of all the tickets related to the selected site(s). Each entry provides detailed information including:


  • Service One Request ID
  • Request ID reference created automatically in Service One when the user raises the ticket. This is an unique identifier that can be alphanumeric (e.g., REQ000000xxxxxx or CASE-000xxxxxxx) or purely numeric (e.g., 1234567).
  • Type (Incident, WorkOrder)
  • Indicates whether the ticket is an Incident, a WorkOrder or a Case.
  • Fulfilment Number
  • A specific number associated with the technical fulfilment process.
  • Site
  • Refers to the specific location (e.g., CARNAXIDE) where the incident or work order originated or is being addressed.
  • Priority
  • Shows the priority level of each ticket (e.g., Low, Medium, High, Fastlaned).
  • Status
  • Indicates the current status of the ticket (e.g., Cancelled, Closed).
  • Description
  • Provides a brief description or purpose of the ticket, usually the same as the one entered by the user upon its creation but can have additional info according to the technical fulfilment process.
  • Submit Date
  • The date the ticket was submitted.
  • Resolved Date
  • The date the ticket was resolved.



Dynamic Table Functionality

In the DSDS View of the DT DASHboard, the table displaying detailed ticket information is designed to be dynamic and responsive to user interactions with the pie charts. Specifically, the table data updates according to the selections made in the following pie charts:

  1. Unassigned Incidents Backlog (%)
  2. Pending - Sub State Wise Backlog Volume

How It Works

  1. Unassigned Incidents Backlog (%)

  2. Pending - Sub State Wise Backlog Volume

Benefits of Dynamic Interaction

Example Scenario

If a site manager notices that a significant percentage of incidents are unassigned, they can click on the "Unassigned" segment of the pie chart to view all unassigned tickets in the table. This allows them to take prompt action to assign these incidents to the appropriate team members.

Similarly, if there is a backlog in a specific sub-state like "Client Action Required," the manager can click on that segment to see all relevant tickets, enabling them to address any bottlenecks or follow up with clients as needed.




Direct Hyperlink from Fulfillment Ticket to Helix Platform

In the DSDS View of the DT DASH, the Service Request and the Fulfillment Ticket Number column contains a direct hyperlink for each ticket. This feature is designed to streamline user interaction and improve efficiency.

How It Works

Benefits

Example Scenario

If a DSDS user sees a ticket that requires action or deep analysis, they can simply click on the Fulfilment Ticket hyperlink to open the ticket in Helix, provide the necessary feedback, and update the ticket, all in a few quick steps.

This direct hyperlink feature is aimed at enhancing user experience by providing a seamless connection between the DT DASHboard and the Helix platform, ensuring timely updates and efficient ticket management.




3. Troubleshooting






4. Support


For Access request, please raise a Service One request xxxxxx

For any issue or data inaccuracy identified, please raise an INCIDENT in Service One xxxxxx