Visualization of Client Service Events Statistics

This paper summarizes work performed to develop new types of charts for the visualization of statistics associated with client service events: the matrix bar chart and the flower bed chart. In the problem that led to these charts, we had to visualize time series data of service events sequence related to specific clients. The flower bed and matrix bar charts can be plotted for any specific interval of time. The raw data were aggregated into two tables: Frequency(PrevEv, Ev) and Time(PrevEv, Ev). Then these two tables were visualized. The charts give the user the ability to identify immediately the most business important factors. The program was implemented as VBA - MS Excel macro.