ScholarLens Back to search
2018•Unpublished venueRequires access

Development of Data Warehouse to Improve Services in IT Services Company

Fajar Zaki Al Faris, Suharjito Suharjito, Diana Diana, Ariadi Nugroho

Open publisher page 13 citations

Abstract

On time service delivery is one of the ultimate goal of IT services company. The aim of this study is developing data warehouse to help company keeping up the delivery service time is always on target. This study starts with identifying the problem, data collection, literature study, then develop the data warehouse, making analysis with OLAP, build report and dashboard as needed, and at last evaluation of data warehouse already developed. Extract Transform Load process (ETL) transferred data from operational database to data warehouse. OLAP analysis features in data warehouse can help company to analyse information from multidimensional data; report and dashboard build from information in the data warehouse can help sales team to know what best strategy and making decision. As the result, data warehouse that has been built can help sales team deliver the services on time to their customers.

About this research paper

What this paper is about

On time service delivery is one of the ultimate goal of IT services company. The aim of this study is developing data warehouse to help company keeping up the delivery service time is always on target. This study starts with identifying the problem, data collection, literature study, then develop the data warehouse, making analysis with OLAP, build report and dashboard as needed, and at last evaluation of data warehouse already developed. Extract Transform Load process (ETL) transferred data from operational database to data warehouse. OLAP analysis features in data warehouse can help company to analyse information from multidimensional data; report and dashboard build from information in the data warehouse can help sales team to know what best strategy and making decision. As the result, data warehouse that has been built can help sales team deliver the services on time to their customers.

Why it matters

OpenAlex reports 13 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

On time service delivery is one of the ultimate goal of IT services company. The aim of this study is developing data warehouse to help company keeping up the delivery service time is always on target. This study starts with identifying the problem, data collection, literature study, then develop the data warehouse, making analysis with OLAP, build report and dashboard as needed, and at last evaluation of data warehouse already developed. Extract Transform Load process (ETL) transferred data from operational database to data warehouse. OLAP analysis features in data warehouse can help company to analyse information from multidimensional data; report and dashboard build from information in the data warehouse can help sales team to know what best strategy and making decision. As the result, data warehouse that has been built can help sales team deliver the services on time to their customers.

Key concepts: Data warehouse, Online analytical processing, Dashboard, Computer science, Dimensional modeling, Business intelligence, Service (business), Database

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Development of Data Warehouse to Improve Services in IT Services Company — Research Paper | ScholarLens