Visualizing Statistical Analysis of Multi Tabular Attributes with SQL

Abstract

Data extraction and data management is playing a vital role in today’s world. Databases are widely used by all the organizations. Analysis of data is very crucial when comparisons are done between different subjects. There are many software’s developed for statistical analysis of data. Various visualization techniques are used for representation. In statistical analysis of tabular data in databases, data is either extracted as external sheets or the statistical software’s are connected to the servers to test data. In our approach, we introduce a web based interface where users can select any number of attributes and view the results with some simple visualizations. SQL queries are written for different methodologies to analyze data. Formulas and structure of all the queries are visualized and represented for the users to understand the query processing and the test methodologies. All the statistical tests are performed on multi tabular data. Ranking is performed on categorical data to replace these values with ranks. With the selected attributes, views are created in the database with the ranks replacing the categorical values in these views. The developed interface is tested with different users to evaluate the visualizations used and the understandability of the statistical tests.