R as a data analysis and visualization tool using Business Intelligence and PowerBI

Abstract

Introduction. The use of R today in the academic, statistical and research fields is a tool with good potential. It is important, it can be applied in basic and applied science since it allows complex statistical calculations to be automated to conduct the corresponding data analysis. Objective. Make a dashboard using Excel and PowerBI with R applying Business Intelligence (BI) and Data Warehouse (DW) in reporting for quality decision making. Methodology. This research is descriptive, it uses the Methodology for the Construction of an Algorithm for Systemic Learning of ICT students in the first semester (Mejía et al, 2018), adapted to the use of a dashboard, which provides tools that allow planning and implementing a dashboard, to make scripts within the scope of work of R. Within this methodology additional steps are inserted to be able to solve through BI and DW. Tests were conducted with fourth-semester Statistics students to determine problem solving before and after using a type of software. Results. Students using BI and DW only 28.57% reach a perfect conclusion using Excel, while students using BI reach a perfect 85.71% using PowerBI, to complete the exercises. Conclusion. It is concluded that under the parameters of use of Business Intelligence and Data Warehouse for the presentation of reports in decision making, the percentages favor these techniques provided by the researcher, this result in statistical terms is very favorable, since these techniques are based on in improving the quality of presentation of a report for the web and for the manager or president of an institution within the well-being of the company. Students with these techniques will be able to perform better in the professional field.