Automation of longitudinal time series data visualization using plot specifications obtained from XL file

Abstract

Longitudinal Time Series data visualization plays important role in all sector of business decision making [9]. With enormous amount of complex data [11] from cloud and business requirement, number of graphs needed for decision making increased many folds. Generating enormous number of plots manually with more human input is tedious, time consuming and error prone. To avoid these issues, suitable visualization techniques with solid design principles become very important. We conceptualized and designed a novel method for automation of these processes. R-GGPLOT2[7] package and XL specifications file were primarily used to achieve this goal. We here show as how we can create multiple plots from time series data, plots specifications-XL file and R package GGPLOT2[7] in a single run. Since all required information are entered in XL sheet, R function can be run with no modification. Multiple plots can be generated by using enormous data available in production and service sectors such as finance, healthcare, transportation and food industries etc.