Impact of business intelligence on incident management in the control center of a security company

Alfredo Daza; Elmer Marcelino De la Paz Ttito; Yohan Roy Alarcón Cajas

doi:10.11591/eei.v13i1.5819

Impact of business intelligence on incident management in the control center of a security company

Alfredo Daza
, Elmer Marcelino De la Paz Ttito
, Yohan Roy Alarcón Cajas

César Vallejo University

Research output: Contribution to journal › Article › peer-review

1 Scopus citations

Abstract

The main objective of this article is to implement business intelligence (BI) technology to improve incident management in the control center of a security company; making use of the Ralph Kimball method for the development of the data mart, contemplating the phases: planning of projects, definition of requirements, design of technological architecture, performing a dimensional modeling a star with 9 dimensions and 1 table made, also used the structured query language (MySQL) database, extract, transform, and load (ETL). Development the pentaho data integration, which allowed the migration, transformation and cleaning of the data from the online transaction processing (OLTP) and online analytical processing (OLAP) database, obtaining as a result that the BI managed to increase the level of the service by 28.42% and reducing the frequency index by 25%.

Original language	English
Pages (from-to)	422-435
Number of pages	14
Journal	Bulletin of Electrical Engineering and Informatics
Volume	13
Issue number	1
DOIs	https://doi.org/10.11591/eei.v13i1.5819
State	Published - 1 Feb 2024

Access to Document

10.11591/eei.v13i1.5819

Cite this

@article{b01de4c7ebb248fd81f60ad5fe1bb281,

title = "Impact of business intelligence on incident management in the control center of a security company",

abstract = "The main objective of this article is to implement business intelligence (BI) technology to improve incident management in the control center of a security company; making use of the Ralph Kimball method for the development of the data mart, contemplating the phases: planning of projects, definition of requirements, design of technological architecture, performing a dimensional modeling a star with 9 dimensions and 1 table made, also used the structured query language (MySQL) database, extract, transform, and load (ETL). Development the pentaho data integration, which allowed the migration, transformation and cleaning of the data from the online transaction processing (OLTP) and online analytical processing (OLAP) database, obtaining as a result that the BI managed to increase the level of the service by 28.42\% and reducing the frequency index by 25\%.",

keywords = "Business intelligence, Data mart, Incident management, Ralph Kimball, Service level",

author = "Alfredo Daza and \{De la Paz Ttito\}, \{Elmer Marcelino\} and Cajas, \{Yohan Roy Alarc{\'o}n\}",

year = "2024",

month = feb,

day = "1",

doi = "10.11591/eei.v13i1.5819",

language = "English",

volume = "13",

pages = "422--435",

journal = "Bulletin of Electrical Engineering and Informatics",

issn = "2089-3191",

publisher = "Institute of Advanced Engineering and Science",

number = "1",

}

TY - JOUR

T1 - Impact of business intelligence on incident management in the control center of a security company

AU - Daza, Alfredo

AU - De la Paz Ttito, Elmer Marcelino

AU - Cajas, Yohan Roy Alarcón

PY - 2024/2/1

Y1 - 2024/2/1

N2 - The main objective of this article is to implement business intelligence (BI) technology to improve incident management in the control center of a security company; making use of the Ralph Kimball method for the development of the data mart, contemplating the phases: planning of projects, definition of requirements, design of technological architecture, performing a dimensional modeling a star with 9 dimensions and 1 table made, also used the structured query language (MySQL) database, extract, transform, and load (ETL). Development the pentaho data integration, which allowed the migration, transformation and cleaning of the data from the online transaction processing (OLTP) and online analytical processing (OLAP) database, obtaining as a result that the BI managed to increase the level of the service by 28.42% and reducing the frequency index by 25%.

AB - The main objective of this article is to implement business intelligence (BI) technology to improve incident management in the control center of a security company; making use of the Ralph Kimball method for the development of the data mart, contemplating the phases: planning of projects, definition of requirements, design of technological architecture, performing a dimensional modeling a star with 9 dimensions and 1 table made, also used the structured query language (MySQL) database, extract, transform, and load (ETL). Development the pentaho data integration, which allowed the migration, transformation and cleaning of the data from the online transaction processing (OLTP) and online analytical processing (OLAP) database, obtaining as a result that the BI managed to increase the level of the service by 28.42% and reducing the frequency index by 25%.

KW - Business intelligence

KW - Data mart

KW - Incident management

KW - Ralph Kimball

KW - Service level

UR - https://www.scopus.com/pages/publications/85186255395

U2 - 10.11591/eei.v13i1.5819

DO - 10.11591/eei.v13i1.5819

M3 - Article

AN - SCOPUS:85186255395

SN - 2089-3191

VL - 13

SP - 422

EP - 435

JO - Bulletin of Electrical Engineering and Informatics

JF - Bulletin of Electrical Engineering and Informatics

IS - 1

ER -

Impact of business intelligence on incident management in the control center of a security company

Abstract

Access to Document

Other files and links

Fingerprint

Cite this