Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico

Enrique M. Avendaño Delgado; Gianella Angelica Guzmán Fabián; Fiorella Emperatriz Quito Angeles; Odar R. Florian Castillo

Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico

Translated title of the contribution: Business Intelligence Model for Decision-Making in a Gastronomic Sector MyPE

Enrique M. Avendaño Delgado, Gianella Angelica Guzmán Fabián, Fiorella Emperatriz Quito Angeles, Odar R. Florian Castillo

Universidad Privada del Norte

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

Abstract

The objective of the research was to design a business intelligence model for decision making in a mype of the gastronomic sector of the gastronomic sector in the city of Trujillo 2021. The study has a qualitative, applied, prospective, cross-sectional, observational, and non-experimental approach. The population consisted of 2,000 clients and a sample of 50 clients determined by convenience with a survey validated by expert judgment and a reliability of 0.86 Cronbach's alpha. For the situational diagnosis of the mype, the matrices Porter's 5 forces, PESTE, evaluation of external factors (MEFE), value chain were used. The requirements of the model were determined for the design of the database that allows the construction of the Data Mart and ETL. Finally, it was determined that the estimated investment for the implementation of the model is S/. 1,9065, taking into account personnel, equipment, materials, software and services costs. This with the purpose of minimizing attention times.

Translated title of the contribution	Business Intelligence Model for Decision-Making in a Gastronomic Sector MyPE
Original language	Spanish
Title of host publication	Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology
Subtitle of host publication	Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023
Editors	Maria M. Larrondo Petrie, Jose Texier, Rodolfo Andres Rivas Matta
ISBN (Electronic)	9786289520743
State	Published - 2023
Event	21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023 - Buenos Aires, Argentina Duration: 19 Jul 2023 → 21 Jul 2023

Publication series

Name	Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology
Volume	2023-July
ISSN (Electronic)	2414-6390

Conference

Conference	21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023
Country/Territory	Argentina
City	Buenos Aires
Period	19/07/23 → 21/07/23

Cite this

Avendaño Delgado, E. M., Fabián, G. A. G., Angeles, F. E. Q., & Florian Castillo, O. R. (2023). Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico. In M. M. Larrondo Petrie, J. Texier, & R. A. R. Matta (Eds.), Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023 (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology; Vol. 2023-July).

Avendaño Delgado, Enrique M. ; Fabián, Gianella Angelica Guzmán ; Angeles, Fiorella Emperatriz Quito et al. / Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico. Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. editor / Maria M. Larrondo Petrie ; Jose Texier ; Rodolfo Andres Rivas Matta. 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology).

@inproceedings{b8214774a0374ff09bf488c52c4ef4f4,

title = "Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastron{\'o}mico",

abstract = "The objective of the research was to design a business intelligence model for decision making in a mype of the gastronomic sector of the gastronomic sector in the city of Trujillo 2021. The study has a qualitative, applied, prospective, cross-sectional, observational, and non-experimental approach. The population consisted of 2,000 clients and a sample of 50 clients determined by convenience with a survey validated by expert judgment and a reliability of 0.86 Cronbach's alpha. For the situational diagnosis of the mype, the matrices Porter's 5 forces, PESTE, evaluation of external factors (MEFE), value chain were used. The requirements of the model were determined for the design of the database that allows the construction of the Data Mart and ETL. Finally, it was determined that the estimated investment for the implementation of the model is S/. 1,9065, taking into account personnel, equipment, materials, software and services costs. This with the purpose of minimizing attention times.",

keywords = "Business intelligence, Data Mart, Decision making, SME Gastronomic Sector",

author = "{Avenda{\~n}o Delgado}, {Enrique M.} and Fabi{\'a}n, {Gianella Angelica Guzm{\'a}n} and Angeles, {Fiorella Emperatriz Quito} and {Florian Castillo}, {Odar R.}",

note = "Publisher Copyright: {\textcopyright} 2023 Latin American and Caribbean Consortium of Engineering Institutions. All rights reserved.; 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023 ; Conference date: 19-07-2023 Through 21-07-2023",

year = "2023",

language = "Espa{\~n}ol",

series = "Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology",

editor = "{Larrondo Petrie}, {Maria M.} and Jose Texier and Matta, {Rodolfo Andres Rivas}",

booktitle = "Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology",

}

Avendaño Delgado, EM, Fabián, GAG, Angeles, FEQ & Florian Castillo, OR 2023, Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico. in MM Larrondo Petrie, J Texier & RAR Matta (eds), Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology, vol. 2023-July, 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023, Buenos Aires, Argentina, 19/07/23.

Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico. / Avendaño Delgado, Enrique M.; Fabián, Gianella Angelica Guzmán; Angeles, Fiorella Emperatriz Quito et al.
Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. ed. / Maria M. Larrondo Petrie; Jose Texier; Rodolfo Andres Rivas Matta. 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology; Vol. 2023-July).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico

AU - Avendaño Delgado, Enrique M.

AU - Fabián, Gianella Angelica Guzmán

AU - Angeles, Fiorella Emperatriz Quito

AU - Florian Castillo, Odar R.

PY - 2023

Y1 - 2023

N2 - The objective of the research was to design a business intelligence model for decision making in a mype of the gastronomic sector of the gastronomic sector in the city of Trujillo 2021. The study has a qualitative, applied, prospective, cross-sectional, observational, and non-experimental approach. The population consisted of 2,000 clients and a sample of 50 clients determined by convenience with a survey validated by expert judgment and a reliability of 0.86 Cronbach's alpha. For the situational diagnosis of the mype, the matrices Porter's 5 forces, PESTE, evaluation of external factors (MEFE), value chain were used. The requirements of the model were determined for the design of the database that allows the construction of the Data Mart and ETL. Finally, it was determined that the estimated investment for the implementation of the model is S/. 1,9065, taking into account personnel, equipment, materials, software and services costs. This with the purpose of minimizing attention times.

AB - The objective of the research was to design a business intelligence model for decision making in a mype of the gastronomic sector of the gastronomic sector in the city of Trujillo 2021. The study has a qualitative, applied, prospective, cross-sectional, observational, and non-experimental approach. The population consisted of 2,000 clients and a sample of 50 clients determined by convenience with a survey validated by expert judgment and a reliability of 0.86 Cronbach's alpha. For the situational diagnosis of the mype, the matrices Porter's 5 forces, PESTE, evaluation of external factors (MEFE), value chain were used. The requirements of the model were determined for the design of the database that allows the construction of the Data Mart and ETL. Finally, it was determined that the estimated investment for the implementation of the model is S/. 1,9065, taking into account personnel, equipment, materials, software and services costs. This with the purpose of minimizing attention times.

KW - Business intelligence

KW - Data Mart

KW - Decision making

KW - SME Gastronomic Sector

UR - http://www.scopus.com/inward/record.url?scp=85172407289&partnerID=8YFLogxK

M3 - Contribución a la conferencia

AN - SCOPUS:85172407289

T3 - Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology

BT - Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology

A2 - Larrondo Petrie, Maria M.

A2 - Texier, Jose

A2 - Matta, Rodolfo Andres Rivas

T2 - 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023

Y2 - 19 July 2023 through 21 July 2023

ER -

Avendaño Delgado EM, Fabián GAG, Angeles FEQ, Florian Castillo OR. Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico. In Larrondo Petrie MM, Texier J, Matta RAR, editors, Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology).

Modelo de Inteligencia de Negocios para la toma de Decisiones de una SME del Sector Gastronómico

Abstract

Publication series

Conference

Other files and links

Fingerprint

Cite this