Dhanny, Omar (2006) Rancang Bangun Data Warehouse Dan Penerapan Metode Olap Di Bank BPD Kaltim Samarinda. Masters thesis, Institut Teknologi Sepuluh Nopember.
![[thumbnail of 5199201007-Master_thesis.pdf]](http://repository.its.ac.id/style/images/fileicons/text.png) |
Text
5199201007-Master_thesis.pdf Restricted to Repository staff only Download (41MB) |
Abstract
Persaingan yang ketat akibat kebijakan Pemerintah Indonesia di bidang perbankan dan turunnya daya beli masyarakat akibat krisis ekonomi menyebabkan Bank BPD Kaltim dituntut untuk terus meningkatkan kinerjanya. Untuk itu, diperlukan analisis pemasaran dan key performance indicator (KPI) yang bersifat multidimensi, online, terintegrasi, dinamis, konsisten, mempunyai respons yang relatif cepat, dan mudah digunakan. Penelitian ini bertujuan untuk mendesain dan membuat suatu sistem data warehouse dan penerapan metode On-Line Analytical Processing (OLAP) guna membantu pihak manajemen Bank BPD Kaltim dalam melakukan analisis pemasaran yang dibutuhkan. Dalam tahap desain, dibuat skema data warehouse untuk data rekening dan data kredit, yang kemudian diimplementasikan melalui eksekusi script SQL dalam lingkungan Microsoft SQL Server 2005. Proses Extracting, Transforming and Loading (ETL) diimplementasikan menggunakan Microsoft SQL Server Integration Services 2005 untuk beberapa jenis data dan perhitungan yang tidak memiliki data sumber. Proses OLAP diimplementasikan menggunakan Microsoft SQL Server Analysis Services 2005. Sedangkan antarmuka aplikasi diimplementasikan menggunakan Microsoft Excel 2003. Selain itu, juga diimplementasikan antarmuka aplikasi berbasis web. Berdasarkan hasil uji coba yang dilakukan, dapat disimpulkan bahwa melalui penelitian ini telah berhasil dibangun dan diimplementasikan sebuah aplikasi data warehouse beserta analisis berbasis OLAP dalam lingkungan Microsoft SQL Server 2005 untuk keperluan analisis pemasaran produk tabungan, giro, deposito, dan kredit serta analisis KPI di Bank BPD Kaltim.
===================================================================================================================================
Tight competition within the banking industry nowadays is considered to be an impact of the Indonesian government's policy in banking, as well as a decrease in the purchasing power of most Indonesians due to the economic crisis. Knowing these circumstances, Bank BPD Kaltim has to improve its performance continuously. To increase its competitiveness, Bank BPD Kaltim needs marketing and Key Performance Indicator (KPI) analysis characterized as multidimensional, online, integrated, dynamic, consistent, relatively quick in response, and easy to operate. This research is aimed at designing and developing a data warehouse system and implementing the On-Line Analytical Processing (OLAP) method to help the management of Bank BPD Kaltim analyze marketing data. In the design stage, a data warehouse was developed to store account data and credit data, which was then implemented through the execution of SQL scripts in the Microsoft SQL Server 2005 environment. The Extracting, Transforming, and Loading (ETL) process was implemented using Microsoft SQL Server Integration Services 2005 for some types of data and calculations for which no source data were available. The OLAP process was implemented using Microsoft SQL Server Analysis Services 2005, while the application interface was implemented using Microsoft Excel 2003. In addition, a web-based application interface was also implemented. Based on the experiments conducted, it can be concluded that this research successfully developed and implemented a data warehouse application with OLAP-based analysis in the Microsoft SQL Server 2005 environment, which can be used for marketing analysis of savings, current accounts, deposits, and credit products, as well as KPI analysis at Bank BPD Kaltim.
| Item Type: | Thesis (Masters) |
|---|---|
| Additional Information: | RTIf 005.740 68 Dha r |
| Uncontrolled Keywords: | data warehouse, OLAP, analisis pemasaran, key performance indicator, data warehouse, OLAP, marketing analysis, key performance indicator. |
| Subjects: | Q Science > QA Mathematics > QA76.9.D37 Data warehousing. |
| Divisions: | Faculty of Information Technology > Informatics Engineering > 55101-(S2) Master Thesis |
| Depositing User: | magang . |
| Date Deposited: | 22 Sep 2026 01:39 |
| Last Modified: | 22 Sep 2026 01:39 |
| URI: | http://repository.its.ac.id/id/eprint/144764 |
Actions (login required)
 |
View Item |