This Tableau Accelerator allows you to:

* **Assess & Improve the level of service of your Service Desk: overall and by agent group**
* **Focus your efforts on highest priority cases, or oldest cases**
* **Better serve users**
* **Adapt your resource allocation to peak periods**
* **Audit your ability to increase your level of service over time**

[Demo video](https://youtu.be/KM9tiBbUUPA)

### Answer key business questions

* Which cases are currently open?
* How effective have we been in closing cases?
* What is the performance of our agent groups?
* What types of cases are created most often?
* Who handles the most cases?
* How long does it take to close cases?
* How many users are we servicing?

### Monitor and improve KPIs

#### *Cases*

* **Created Cases**: Number of cases that were created over the period
* **Open Cases**: Number of cases which are currently open
* **Closed Cases**: Number of cases that were closed over the period

#### *Users*

* **Users**: Number of users who created at least one case
* **Created Cases per User**: Average number of cases created by user

#### *Agents*

* **Closed Cases per Agent**: Average number of cases closed per agent
* **Agents**: Number of agents who have been closing at least one case over the period

#### *Time*

* **Open Cases Duration Time**: Average time since cases are open (for currently open cases only)
* **Resolution Duration**: Average time it takes to close a case (expressed in min)

### Required attributes

* **Case #** *(string)*: Case Unique Identifier
* **Case Description** *(string)*: Description of the Case
* **Open Date** *(datetime)*: Case Open Date-Time
* **Close Date** *(datetime)*: Case Close Date-Time
* **Case Category** *(string)*: Case Category
* **Case Priority** *(string)*: Case Priority ← expected values: “High”, “Medium”, “Low”
* **User** *(string)*: Who opened the case
* **Case Status** *(string)*: Case Status ← expected values: “Open”, “Closed”
* **Agent** *(string)*: Agent Working on the case
* **Agent Group** *(string)*: Group of the Agent

## Getting Started Steps

1. Ensure you have Tableau Desktop version 2023.2 or higher installed and that it is licensed. Use the Salesforce Data Cloud connector to connect to Data Cloud. Note that this is a connector released with the Data Cloud Summer ’23 release as described [here](https://help.salesforce.com/s/articleView?id=release-notes.cdp_rn_2023_summer_tableau_connector.htm&release=244&type=5). This accelerator works only with the Salesforce Data Cloud connector.
2. Ensure that Tableau has been provisioned access to pull data from Salesforce Data Cloud (previously known as Salesforce CDP). There is great documentation on how to do this on [Customer Data Platform’s Help site](https://help.salesforce.com/s/articleView?id=sf.c360_a_tableau_connector.htm&type=5).

### Understand the Data Model Requirements

#### The Accelerator shows data from these objects

* ssot\_\_Case\_\_dlm
    * Custom field label: Owner ID and API Name Owner\_Id (the system will add the \_\_c)
    * Custom field label: Opened Date Time and API Name tab\_Opened\_Date\_Time (the system will add the \_\_c)
* ssot\_\_Account\_\_dlm
* ssot\_\_AccountContact\_\_dlm
    * Custom field label: First Name and API Name tab\_First\_Name (the system will add the \_\_c)
    * Custom field label: Last Name and API Name tab\_Last\_Name (the system will add the \_\_c)
    * Custom field label: Full Name and API Name tab\_Full\_Name (the system will add the \_\_c)
* tab\_Data\_Source\_\_dlm (Custom object)
    * Object Label: Data Source
    * Object Category: Other
    * Object API Name: tab\_Data\_Source\_\_dlm
    * Object Fields: Create the Data Model Object using this [CSV file](https://github.com/tableau/Accelerators/blob/b4d621cf475b2cb37cca2acc82efd78c6119179f/DataCloud-CustomDMOs/tab_Data_Source__dlm.csv)
    * How to create Custom Object from CSV file [read more](https://help.salesforce.com/s/articleView?id=sf.c360_a_create_custom_dmo_from_csv.htm&type=5)

Salesforce Data Cloud - Service Desk

Assess & Improve the level of service of your Service Desk: overall and by agent group