DEVELOPMENT DASHBOARD HR LEARNING BASED OLAP IN LIFE INSURANCE COMPANY

  • William Frado Pattipeilohy (1) Universitas Budi Luhur
  • Sanwani Sanwani (2*) STMIK Nusa Mandiri
  • Ade Priyatna (3) Sekolah Tinggi Manajemen Informatika dan Komputer Nusa Mandiri

  • (*) Corresponding Author
Keywords: Human Resources, HRIS, Business Intelligence, OLAP

Abstract

Currently in the business world, companies have the challenge to survive and even thrive in the face of business changes that are so fast and flexible both in terms of markets, consumers, products to competitors. Companies are required to be able to take quick and appropriate decisions in the face of all these business changes. Implementation of Business Intelligence in a company becomes a real solution in facing all those challenges. Where by using Business Intelligence, management within a company can make appropriate decisions based on valid data that has been processed into knowledge and presented from various perspectives needed. This research developed an integrated system in the form of an OLAP-based dashboard to present data reports, especially in the Human Resources Division. Various data in the excel file upload are automatically generated by ETL to the database using SSIS and consolidated into a data warehouse. Processing using SSAS, which is displayed in the form of a dashboard using Reporting Services with a more interesting summary form. With the development of the HR Learning and Development dashboard, top-level management companies get reports for quick, precise and accurate decision making.

Downloads

Download data is not yet available.

References

Z. Nur and I. Mukhlash, “Implementasi Business Intelligence Pada Manajemen Report Bank XYZ,” J. Sains Dan Senni Pomits, vol. 3, no. 3, pp. A16–A21, 2014.

W. S. Prasetya, Kusrini, and H. Al Fatta, “Sistem Pendukung Keputusan Pemilihan Produk Asuransi Studi Kasus : PT Commonwealth Life Pontianak Decision Support System Insurance Product Selection Case Study : PT Commonwealth Life Pontianak,” J. STMIK AMIKOM, vol. 8, no. 1, pp. 105–116, 2018.

A. Zikri, J. Adrian, A. Soniawan, R. Azim, R. Dinur, and R. Akbar, “Implementasi Business Intelligence untuk Menganalisis Data Persalinan Anak di Klinik Ani Padang dengan Menggunakan Aplikasi Tableau Public,” J. Online Inform., vol. 2, no. 1, pp. 20–24, 2017.

C. Vercellis, Business Intelligence: Data Mining and Optimization for Decision Making. 2009.

N. S. Ambarwati, G. A. Yuniarta, and N. K. Sinarwati, “Pengaruh Modal Kerja, Likuiditas, Aktivitas dan Ukuran Perusahaan Terhadap Profitabilitas Pada Perusahaan Manufaktur yang Terdaftar di Bursa Efek Indonesia,” e-journal S1 Ak Univ. Pendidik. Ganesha, vol. 3, no. 1, 2015.

G. Ade and Okfalisa, “Sistem Pendukung Keputusan Untuk Produk Asuransi Jiwa Bagi Nasabah Menggunakan Metode SMARTER,” J. Sains, Teknol. dan Ind., vol. 12, no. 1, pp. 73–79, 2014.

Kusnawi, “Implementasi OLAP dan Reporting Services sebagai Bagian Proses Business Intelligence,” Bisnis Intelejen, vol. 12, no. 2, pp. 43–48, 2010.

E. Turban, J. E. Aronson, and T.-P. Liang, “Decision Support Systems and Business Intelligence,” Decis. Support Bus. Intell. Syst. 7/E, pp. 1–35, 2007.

H. Kurniawan, B. Setiyono, and R. R. Isnanto, “Aplikasi Penjawab Pesan Singkat Automatis Dengan Bahasa Python,” Dr. Diss., 2011.

T. Kusnandar, “Penerapan Crm Dengan Sistem Informasi Berbasis Web Untuk Kepuasan Pelanggan,” J. Comput. BISNIS, vol. 5, no. 1, pp. 6–13, 2011.

S. Kasus, D. Pt, I. Adi, and P. Semarang, “Implementasi Sistem Business Intelligence Untuk Melakukan Analisis Data Guna Mendukung Pembuatan Keputusan Manajer,” Techno.COM, vol. XIV, no. 02, pp. 83–92, 2008.

A. Priyatna, “Implementasi Sistem Penunjang Keputusan Menggunakan Business Intelligence Untuk Umkm Di Gunung Putri Kab.Bogor,” J. Khatulistiwa Inform., vol. 7, no. 1, pp. 7–12, 2019.

L. Hasim, “Penerapan Business Intelligence Pada Manajemen Dashboard Report Perusahaan Asuransi,” Syntax Lit. ; J. Ilm. Indones., vol. 4, no. 12, pp. 123–136, 2019.

N. Ardista, P. Purbandini, and T. Taufik, “Rancang Bangun Data Warehouse Untuk Pembuatan Laporan dan Analisis pada Data Kunjungan Pasien Rawat Jalan Rumah Sakit Universitas Airlangga Berbasis Online Analytical Processing (OLAP),” J. Inf. Syst. Eng. Bus. Intell., vol. 3, no. 1, pp. 40–51, 2017.

A. Dwiputra Wijaya and T. Gantini, “Analisis Forecasting dengan Implementasi Dashboard Business Intelligence Untuk Data Penjualan Pada PT. ‘X,’” Prof. Drg. Surya Sumantri, vol. 1, no. 2, pp. 457–470, 2019.

Maimunah, S. F. Saadah, and R. Andrian, “Rancang Bangun Aplikasi Data Warehouse Untuk Business Intelligence,” CSRID J., vol. 5, no. 1, pp. 1–10, 2012.

Published
2021-02-02
How to Cite
[1]
W. Pattipeilohy, S. Sanwani, and A. Priyatna, “DEVELOPMENT DASHBOARD HR LEARNING BASED OLAP IN LIFE INSURANCE COMPANY”, jitk, vol. 6, no. 2, pp. 205-210, Feb. 2021.
Article Metrics

Abstract viewed = 33 times
PDF downloaded = 8 times