dashboard for statistical visualization of client service events
DESCRIPTION
2. Dashboard for Statistical Visualization of Client Service Events. The raw data: Creation – Received –First_Contact_SW – First_Contact_HW – Request – Pending – Closed. TSC Events: Creation – Received – First_Contact_SW – First_Contact_HW – Request – Comp_Pending – Closed. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/1.jpg)
Dashboard for Statistical Visualization of Client Service Events
Alex Zolot (Zolotovitski), [email protected] www.StatVis.com
![Page 2: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/2.jpg)
www.zolot.us www.StatVis.com 2
2
Dashboard for Statistical Visualization of Client Service Events
The raw data:Creation – Received –First_Contact_SW – First_Contact_HW – Request – Pending – Closed
TSC Events: Creation – Received – First_Contact_SW –
First_Contact_HW – Request – Comp_Pending – Closed
Types: HW Platforms, Products, Geo, Owner, …
![Page 3: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/3.jpg)
www.zolot.us www.StatVis.com 3
Case DateTime Event Type Time PrEvCase1 T1 Ev1 Type1 0 0Case1 T2 Ev3 Type1 T2-T1 E1
Case1 T3 Ev7 Type1 T3-T2 E3
Case2 T4 Ev3 Type1 0 0……
Sorted data
![Page 4: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/4.jpg)
www.zolot.us www.StatVis.com 4
OLAP dimensions.
![Page 5: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/5.jpg)
www.zolot.us www.StatVis.com 5
Dashboard for Statistical Visualization of Client Service Events
Consists of three key elements:
• Run chart for longitudinal (in time) representation of data • Matrix bar chart for types of cases• Flower bed chart for time between events representation.
The flower bed and matrix bar charts can be plotted for any specific interval of time: week, month, or year.
All features of these three charts are clickable, switching is easy between charts, and drilling down can be done to detailed lists of individual cases. These interactive capabilities facilitate identification of the most business important cases.
![Page 6: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/6.jpg)
www.zolot.us www.StatVis.com 6
6
Longitudinal Analysis: Run Chart
TTR = Time-To-Resolve = DateTime(CaseClosed) – DateTime(CaseCreated)
![Page 7: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/7.jpg)
www.zolot.us www.StatVis.com 7
7
Cross-Sectional Analysis –Time Between Events:
The raw TSC data:Creation – Received –First_Contact_SW – First_Contact_HW – Request – Pending – Closed
Events: Creation – Received – First_Contact_SW – First_Contact_HW – Request – Comp_Pending – Closed
Types: HW Platforms, Products, Geo, Owner, …
![Page 8: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/8.jpg)
www.zolot.us www.StatVis.com 8
8
Cross-Sectional Analysis –Time Between Events:
![Page 9: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/9.jpg)
www.zolot.us www.StatVis.com 9
9
Cross-Sectional Analysis –Time Between Events:
![Page 10: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/10.jpg)
www.zolot.us www.StatVis.com 10
10
Cross-Sectional Analysis –Time Between Events:
• Traditional way to represent 2 (pivot) tables: Freq and MTBE (Event x PrevEvent )
Freq
0
20000
40000
60000
80000
100000
R S H Q P C W
Event
Freq
CREATION
RECEIVED
FIRST_CONTACT_SW
FIRST_CONTACT_HW
REQUEST
COMP_PEND
CLOSED
WAREHOUSE_UPDATE
TTR
0
100
200
300
400
500
600
700
800
900
R S H Q P C W
EventTT
R, d
ays
CREATION
RECEIVED
FIRST_CONTACT_SW
FIRST_CONTACT_HW
REQUEST
COMP_PEND
CLOSED
WAREHOUSE_UPDATE
MTBEMTBE
MTB
E
![Page 11: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/11.jpg)
www.zolot.us www.StatVis.com 11
11
Cross-Sectional Analysis –Time Between Events: Variants of possible designs for 2 parameters (Fr and T)
• Area of Circle (“house”) is proportional to frequency of the event.• Width of Petal (arrow, bar) is proportional to frequency of transitions between events.• Length of Petal is proportional to mean time between events.• Color of Petal is the same as color of “To” Circle (“house”)
![Page 12: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/12.jpg)
www.zolot.us www.StatVis.com 12
12
Cross-Sectional Analysis –Time Between Events: Flower Bed Chart
Data visualization – variants of designPetal direction points to next event, with matching petal-circle color. Circle size ~ frequency. Length of petal ~ time and width of petal ~ frequency.
![Page 13: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/13.jpg)
www.zolot.us www.StatVis.com 13
13
Cross-Sectional Analysis – Tower Charts
1 1
3 3
7
7
3
3
1
1
Figure 5. Empirical CDF (left) and sorted sequence (right) of TBE = {1, 1, 3, 3, 7}.
f(i) = Q( i / N) = ECDF-1(i / N)
f(i) = Q( i / N) = ECDF-1(i / N)
. 3D Towers
3D Towers
![Page 14: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/14.jpg)
www.zolot.us www.StatVis.com 14
14
Cross-Sectional Analysis –Time Between Events: Flower Bed Chart with Tower Petals
![Page 15: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/15.jpg)
www.zolot.us www.StatVis.com 15
15
Cross-Sectional Analysis – Evolution of Elements
![Page 16: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/16.jpg)
www.zolot.us www.StatVis.com 16
Cross-Sectional Analysis by Types of Cases:
Traditional way To represent 2 (pivot) tables: Freq and TTR (HW Platform) x (Product)
![Page 17: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/17.jpg)
www.zolot.us www.StatVis.com 17
Cross-Sectional Analysis by Types of Cases: Matrix Bar Chart
Width of cuboid is proportional to time and height is proportional to square root of frequency.
![Page 18: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/18.jpg)
www.zolot.us www.StatVis.com 18
Dashboard for Statistical Visualization of Client Service Events
![Page 19: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/19.jpg)
www.zolot.us www.StatVis.com 19
![Page 20: Dashboard for Statistical Visualization of Client Service Events](https://reader030.vdocuments.us/reader030/viewer/2022032708/56812cdc550346895d919f27/html5/thumbnails/20.jpg)
Dashboard for Statistical Visualization of Client Service Events
Alex Zolot (Zolotovitski), [email protected] www.StatVis.com