Data Mart and key performance indicators to optimize decisions in a medical service clinic

Percy De-La-Cruz-Vdv, Santiago Moquillaza-Henriquez, Miguel Valeriano-Pena, Gisella Luisa Elena Maquen-Nino, Hugo Vega-Huerta, Ivan Adrianzen-Olano

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

The objective of this research is to implement an application that allows the Clinic of the Universidad Nacional Mayor de San Marcos (UNMSM) to optimally manage the information and services offered to teachers, employees and students. This improvement involves the combination of technologies with tools and processes that will allow transforming the stored data from information to knowledge aligned with the strategies of the Admissions and General Management areas and is part of the business intelligence proposed by the UNMSM Clinic. The methodology used in the implementation was Hephaestus, which was selected after a 'Benchmarking', the requirements were obtained in a survey that allowed to identify the Key Performance Indicators (KPI) to provide relevant information and improve the decision making of the UNMSM Clinic. As a result, the implemented application allows to generate reports that can be graphs and pivot tables related to each specified requirement, which are generated from the deployment of the OLAP cube whose base is composed of a multidimensional model of a Data Mart. Achieving efficiency in decision making.

Original languageEnglish
Title of host publication2023 18th Iberian Conference on Information Systems and Technologies, CISTI 2023
PublisherIEEE Computer Society
ISBN (Electronic)9789893347928
DOIs
StatePublished - 2023
Event18th Iberian Conference on Information Systems and Technologies, CISTI 2023 - Aveiro, Portugal
Duration: 20 Jun 202323 Jun 2023

Publication series

NameIberian Conference on Information Systems and Technologies, CISTI
Volume2023-June
ISSN (Print)2166-0727
ISSN (Electronic)2166-0735

Conference

Conference18th Iberian Conference on Information Systems and Technologies, CISTI 2023
Country/TerritoryPortugal
CityAveiro
Period20/06/2323/06/23

Bibliographical note

Publisher Copyright:
© 2023 ITMA.

Keywords

  • Benchmarking
  • Business Intelligence
  • Data Mart
  • KPI
  • OLAP Cube

Fingerprint

Dive into the research topics of 'Data Mart and key performance indicators to optimize decisions in a medical service clinic'. Together they form a unique fingerprint.

Cite this