A Multidimensional View Proposal of the Data Collected Through a Questionnaire. Associated Data Mart Deployment Framework

Abstract

Beyond the traditional data analysis approaches based on SPSS (or similar statistical software tools), an alternative demarche will be subject of our debate. Performant data analysis can be completed based on a multidimensional view of the collected data. This implies an additional data mart powered with information obtained through an ETL process from the collected data. Measures and dimensions will facilitate a subject-oriented, time-based analysis. The theoretical approach framework for deploying the data mart will ground a multidimensional analysis on „how the different respondents answered to the questions included into the questionnaire?“. In addition, a study case was proposed, a questionnaire built and different analyses presented.

Keywords

• Multidimensional model
• questionnaire
• data mart
• ETL
• data analysis.