Author : Jyotsna Lilani, Shikha Duggal, Sudhir Zanje and B.B. Gite

Data today is being analyzed thoroughly by all organizations in order to take important business decisions. Though large organizations work with a large amount of data, small organizations work with data that is smaller in size and may have a different format as well. Microsoft Excel is often used by such organizations to store data in tabular format. However it is inefficient in terms of certain operations to be carried out on data such as filtering and good visualization. DIVA overcomes the disadvantages of Excel by converting Excel-based tables into MySQL tables by generating a SQL script and executing it. It allows joins and merges to be easily performed on this converted data. Also, it represents the converted data in various graphical forms and performs statistical analysis on it.

Keywords: Data Integration, Data Visualization, Data Analysis, R programming language, Merging, Fusion, Correlation, Regression, Statistical Analysis, MySQL, Excel

Article published in International Journal of Current Engineering and Technology, Vol.5, No.3 (June-2015)