Reporting adalah proses pengumpulan, analisis, dan penyajian data untuk pengambilan keputusan bisnis, termasuk PT XYZ yang bergerak di bidang financial technology. PT XYZ mengalami kendala pelaporan karena data tersebar di berbagai sistem yang menyebabkan inefisiensi, ketidakakuratan, dan keterlambatan berdasarkan hasil wawancara kepada Head of Data. Datawarehouse menawarkan solusi dengan mengkonsolidasi data dari berbagai sumber ke dalam repositori terpusat. Proses perancangan melibatkan wawancara, analisis sumber data, perbandingan model daatwarehouse, dan focus group discussion. Hasil menunjukkan bahwa model datawarehouse dengan data vault relevan diterapkan pada PT XYZ dikarenakan fleksibilitasnya dalam melacak data historis. Implementasi datawarehouse dengan data vault menghasilkan pelaporan lebih baik. Penelitian ini menyarankan implementasi backup data untuk data yang tidak lagi relevan pada bisnis yang sedang berjalan. Dengan adanya datawarehouse memungkinkan pengingkatan efisiensi, akurasi, dan ketepatan waktu pelaporan. Ini memungkinkan keputusan bisnis yang lebih tepat berdasarkan data terpusat dan terintegrasi.
Reporting is the process of collecting, analyzing and presenting data in usable form for business decision making including PT XYZ that comes from financial technology company. PT XYZ faces reporting challenges due to data being dispersed across various systems, resulting in inefficiencies, inaccuracies, and delays, as revealed through an interview with Head of Data. A data warehouse offers a solution by consolidating data from various sources into a centralized repository. The design process involves interviews, data source analysis, comparison of data warehouse models, and focus group discussions. The results indicate that the data warehouse model with a data vault is relevant for PT XYZ due to its flexibility in tracking historical data. Implementing a data warehouse with a data vault results in better reporting. This research suggests implementing data backups for data that is no longer relevant to ongoing business. The existence of a data warehouse enhances the efficiency, accuracy, and timeliness of reporting, allowing for more precise business decisions based on centralized and integrated data.