VisCFDI: Interactive web application for visualization and analysis of electronic invoice data in Mexico
DOI:
https://doi.org/10.36825/RITI.11.23.008Keywords:
Dashboard, Data Vizualization, Plotly-Dash, Python, User-Centered DesignAbstract
Digital Tax Receipts via Internet (CFDI) are electronic invoices required by the Tax Administration Service (SAT) on a mandatory basis in Mexico. In addition to supporting a transaction, they are a means of verifying expenses for income tax deduction purposes, as well as the corresponding value added tax. Companies need to know the information that the SAT has regarding their transactions in order to reconcile it with their accounting systems and make decisions based on their data. In the present work, an interactive web dashboard (VisCFDI) is developed that allows the visualization of thousands of CFDI data for analysis, in support of decision making within the field of Business Intelligence in Mexican companies. VisCFDI was developed applying the User Centered Design (UCD) method, involving the end user in the entire development process. The implementation was done entirely in Python code, using the dashboard development framework named Dash, belonging to the Plotly data visualization library. The evaluation of this application was carried out by applying the System Usability Scale (SUS) questionnaire, obtaining favorable usability results for the interactive data visualization developed.
References
Ware, C. (2013). Foundations for an Applied Science of Data Visualization. Information Visualization (Third Edition), 1-30. https://doi.org/10.1016/b978-0-12-381464-7.00001-6
Piovano, L., Garrido, D., Silva, R., Galloso, I. (2014). What (Smart) Data Visualizations Can Offer to Smart City Science. Communications & Strategies, (96), 89–112. https://ssrn.com/abstract=2636382
Tosca Magaña, S., Mapén Franco, F. J., Martínez Prats, G. (2021). Facturación electrónica como herramienta para aumentar la productividad de la empresa. Investigación y Negocios, 14 (23), 6-16 https://doi.org/10.38147/invneg.v14i23.124
Zheng, J. G. (2017). Data visualization in business intelligence. In Global business intelligence (pp. 67-81). Routledge. https://doi.org/10.4324/9781315471136
Qin, X., Luo, Y., Tang, N., Li, G. (2020). Making data visualization more efficient and effective: a survey. VLDB Journal, 29 (1), 93–117. https://doi.org/10.1007/s00778-019-00588-3
Soliman, E., Fetais, N. (2017). Visualization as a mean of big data management: Using Qatar’s electricity consumption data. 9th IEEE-GCC Conference and Exhibition (GCCCE), Manama, Bahrain. https://doi.org/10.1109/IEEEGCC.2017.8447904
Huber, T. C., Krishnaraj, A., Monaghan, D., Gaskin, C. M. (2018). Developing an Interactive Data Visualization Tool to Assess the Impact of Decision Support on Clinical Operations. Journal of Digital Imaging, 31 (5), 640–645. https://doi.org/10.1007/s10278-018-0065-z
Ayad, H. A., Al-Kilani, L. A., Arshad, R., Al-Obadi, M. A., Hussein, H. T., Kucukvar, M. (2020). Developing an Interactive Data Visualization Platform to Present the Adaption of Electrical Vehicles in Washington, California and New York. IEEE 7th International Conference on Industrial Engineering and Applications (ICIEA), Bangkok, Thailand. https://doi.org/10.1109/ICIEA49774.2020.9101928
Eken, S. (2020). An exploratory teaching program in big data analysis for undergraduate students. Journal of Ambient Intelligence and Humanized Computing, 11 (10), 4285–4304. https://doi.org/10.1007/s12652-020-02447-4
Samonte, M. J., Bacer, H. J., Ramirez, R. P., Tuballa, J. J. (2019). An Interactive Data Visualization Tool for Observing History of Fire Incidents. 10th IEEE International Conference on Information and Communication Technology Convergence (ICTC), Jeju, Korea (South). https://doi.org/10.1109/ICTC46691.2019.8939895
Samonte, M. J., Gabriel Bal, T., Recio, Z. N., Mark San Jose, R. (2018). Conditional Cash Transfer Data Analysis of the Philippines: An e-Government Data Visualization Tool. 9th IEEE International Conference on Information and Communication Technology Convergence (ICTC), Jeju, Korea (South). https://doi.org/10.1109/ICTC.2018.8539441
Young, A., Rogers, P. (2019). A Review of Digital Transformation in Mining. Mining, Metallurgy and Exploration, 36 (4), 683–699. https://doi.org/10.1007/s42461-019-00103-w
Halim, K. K., Halim, S., Felecia. (2019). Business intelligence for designing restaurant marketing strategy: A case study. Procedia Computer Science, 161, 615–622. https://doi.org/10.1016/j.procs.2019.11.164
Oggier, F., Phetsouvanh, S., Datta, A. (2018). BiVA: Bitcoin network visualization and analysis. IEEE International Conference on Data Mining Workshops (ICDMW), Singapore. https://doi.org/10.1109/ICDMW.2018.00210
Clement, F., Kaur, A., Sedghi, M., Krishnaswamy, D., Punithakumar, K. (2020). Interactive Data Driven Visualization for COVID-19 with Trends, Analytics and Forecasting. 24th International Conference Information Visualisation (IV), Melbourne, Australia. https://doi.org/10.1109/IV51561.2020.00101
Tlapa García, L. A., Escalante Vega, J. E., Alonso Ramírez, L. (2021). Aplicación interactiva para el aprendizaje con evaluaciones en el área de las matemáticas. Revista de Investigación en Tecnologías de la Información (RITI), 9 (19), 16–31. https://doi.org/10.36825/riti.09.19.002
Vidal Sánchez, D., Ibarra Esquer, J. E., Flores Rios, B. L., Lopez Morteo, G. (2012). Adopción del Estándar ISO 9241-210 : 2010 en la Construcción de Sistemas Interactivos Basados en Computadora. Congreso Internacional de Investigación e Innovación en Ingeniería de Software, Guadalajara, Jalisco.
Benyon, D. (2019). Designing user experience. Pearson UK.
Jokela, T., Iivari, N., Matero, J., Karukka, M. (2003). The standard of user-centered design and the standard definition of usability: Analyzing ISO 13407 against ISO 9241-11. Latin American conference on Human-computer interaction, Rio de Janeiro Brazil. https://doi.org/10.1145/944519.944525
Internacional Organization for Standardization. (2022). Ergonomics of human-system interaction — Part 20: An ergonomic approach to accessibility within the ISO 9241 series. https://www.iso.org/standard/80709.html/
Internacional Organization for Standardization. (2022). Ergonomics of human-system interaction — Part 110: Interaction principles. https://www.iso.org/obp/ui/#iso:std:iso:9241:-110
Nielsen Norman Group. (2022). Why you only need to test with 5 users. https://www.nngroup.com/articles/why-you-only-need-to-test-with-5-users/
Nielsen, J. (1994). Heuristic evaluation. En J. Nielsen, R. L. Mack (Eds.) Usability inspection methods (pp. 25-62). John Wiley & Sons, Inc.
Laubheimer, P. (2018). Beyond the nps: Measuring perceived usability with the sus, nasa-tlx, and the single ease question after tasks and usability tests. Nielsen Norman Group.
Lewis, J. R. (2018). The system usability scale: past, present, and future. International Journal of Human–Computer Interaction, 34 (7), 577–590. https://doi.org/10.1080/10447318.2018.1455307
Embarak, D. O. (2018). Data Analysis and Visualization Using Python. Apress Berkeley. https://doi.org/10.1007/978-1-4842-4109-7
Jolly, K. (2018). Hands-on data visualization with bokeh : interactive web plotting for python using bokeh. Packt Publishing Ltd.
Perrone, G., Unpingco, J., Lu, H. (2020). Network visualizations with Pyvis and VisJS. 19th Python in Science Conference, Austin, Texas. https://doi.org/10.25080/majora-342d178e-008
Sutchenkov, A. A., Tikhonov, A. I. (2020). Embedding Interactive Python Web Applications into Electronic Textbooks. 5th International Conference on Information Technologies in Engineering Education (Inforino), Moscow, Russia. https://doi.org/10.1109/Inforino48376.2020.9111663
Plotly. (2022). Dash Python User Guide. https://dash.plotly.com/
Fuentes Cortes, W., Reyes Jiménez, S., Sánchez González, R. (2022). Aplicación móvil para el fomento, fortalecimiento y preservación del idioma indígena Zapoteca (Diidxazá). Revista de Investigación en Tecnologías de la Información (RITI), 10 (22), 92–102. https://doi.org/10.36825/riti.10.22.007
Bangor, A., Kortum, P. T.,Miller, J. T. (2008). An empirical evaluation of the system usability scale. International Journal of Human-Computer Interaction, 24 (6), 574–594. https://doi.org/10.1080/10447310802205776
Sauro, J. (2011). Measuring Measuring Usability with the System Usability Scale (SUS). https://measuringu.com/sus/
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Revista de Investigación en Tecnologías de la Información
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Esta revista proporciona un acceso abierto a su contenido, basado en el principio de que ofrecer al público un acceso libre a las investigaciones ayuda a un mayor intercambio global del conocimiento.
El texto publicado en la Revista de Investigación en Tecnologías de la Información (RITI) se distribuye bajo la licencia Creative Commons (CC BY-NC
), que permite a terceros utilizar lo publicado citando a los autores del trabajo y a RITI, pero sin hacer uso del material con propósitos comerciales.
