[
ABSTRAKIndikator kinerja utama Direktorat Jenderal Pajak (DJP) adalah tercapainya penerimaan pajak sesuai target yang ditentukan dalam APBN atau APBN-P. Setiap tahun target tersebut selalu mengalami peningkatan sehingga perlu adanya upaya ekstra untuk melakukan penggalian potensi dari wajib pajak (WP) terdaftar. Potensi pajak dapat dianalisis dan dideteksi dengan memanfaatkan data riwayat perpajakan wajib pajak yang ada dalam sistem informasi utama DJP dan beberapa aplikasi pendukung. Penggunaan aplikasi terpusat dan jumlah data transaksi yang besar serta tersebar di beberapa sistem database menyebabkan lamanya waktu yang diperlukan dalam mendapatkan data untuk kebutuhan penggalian potensi pajak. Penelitian ini bertujuan untuk mengembangkan prototype data warehouse dan OLAP yang sesuai dengan kebutuhan DJP untuk menyediakan data yang diperlukan untuk kebutuhan analisis dengan lebih cepat dan akurat. Struktur data warehouse dikembangkan dengan menerapkan pendekatan bottom up yang dikemukakan oleh Kimball yang dimulai dengan pengumpulan data, identifikasi kebutuhan, perancangan arsitektur, perancangan model dimensional, proses Extract, Transform, Load (ETL) dan dilanjutkan dengan pengembangan OLAP object dalam rangka menyajikan informasi yang dibutuhkan. Hasil penelitian berupa purwarupa (prototype) data warehouse dan OLAP yang dapat dimanfaatkan oleh pengguna untuk melakukan analisis potensi pajak.
ABSTRACTKey performance indicator of the Directorate General of Taxation (DGT) is to achieve appropriate tax revenue target. Every year the target is always increasing so that is needed some extra effort to analyze potential tax from taxpayer listed. Potential tax can be analyzed and detected by using data history of taxpayer that is supported by information system application in DGT and some supporting application. With the centralized application and large amount of data transaction in many database system cause the length of time required to retrieve data for analysis in order to explore potential tax. This research aims to develop data warehouse and OLAP prototype that is suitable with the requirement of DGT to present data quickly and accurately. Data warehouse structure was developed by applying bottom up approach proposed by Kimball that begins with data collection, requirement identification, design architecture, designing dimensional model, The Extract, Transform, and Load (ETL) and continued with the development of OLAP object to present the information needed. The result of this research is prototype of the data warehouse and OLAP can be used by users for potential tax analysis., Key performance indicator of the Directorate General of Taxation DGT is to achieve appropriate tax revenue target Every year the target is always increasing so that is needed some extra effort to analyze potential tax from taxpayer listed Potential tax can be analyzed and detected by using data history of taxpayer that is supported by information system application in DGT and some supporting application With the centralized application and large amount of data transaction in many database system cause the length of time required to retrieve data for analysis in order to explore potential tax This research aims to develop data warehouse and OLAP prototype that is suitable with the requirement of DGT to present data quickly and accurately Data warehouse structure was developed by applying bottom up approach proposed by Kimball that begins with data collection requirement identification design architecture designing dimensional model The Extract Transform and Load ETL and continued with the development of OLAP object to present the information needed The result of this research is prototype of the data warehouse and OLAP can be used by users for potential tax analysis ]