Hakim, Albi Akhsanul and Karim, Mikhail Shams Afzal and Aprilian, Farrel (2026) Perancangan dan Implementasi Data Warehouse untuk Pengelolaan Database Sales Order pada PT. Temprina Media Grafika. Project Report (Praktek Kerja Lapang dan Magang). UPN Veteran Jawa Timur. (Unpublished)
![[img]](https://repository.upnjatim.ac.id/style/images/fileicons/text.png) |
Text (cover)
22081010194-cover.pdf Download (415kB) |
|
Text (bab 1)
22081010194-bab1.pdf Download (84kB) |
|
Text (bab 2)
22081010194-bab2.pdf Download (298kB) |
|
Text (bab 3)
22081010194-bab3.pdf Restricted to Repository staff only until 18 July 2028. Download (410kB) |
|
Text (bab 4)
22081010194-bab4.pdf Restricted to Repository staff only until 18 July 2028. Download (1MB) |
|
Text (bab 5)
22081010194-bab5.pdf Restricted to Repository staff only until 18 July 2028. Download (126kB) |
|
Text (daftar pustaka)
22081010194-daftarpustaka.pdf Download (119kB) |
|
Text (lampiran)
22081010194-lampiran.pdf Restricted to Repository staff only Download (295kB) |
Abstract
PT Temprina Media Grafika faced challenges in sales data analysis due to complex and scattered OLTP system structures. This research aims to build a centralized Data Warehouse (DWH) to integrate data and improve reporting efficiency. Using the waterfall method, the system is implemented on a PostgreSQL database with a snowflake schema. The ETL ((Extract, Transform, Load)) process is automated using Apache Airflow and Python, applying incremental load techniques and Slowly Changing Dimension (SCD) Type 2 for historical data tracking. Integrated results are visualized via interactive dashboards in Google Looker Studio. This implementation has successfully improved data consistency and availability for reporting, as well as supporting more structured report presentation; quantitative evaluation of performance before and after is recommended.
| Item Type: | Monograph (Project Report (Praktek Kerja Lapang dan Magang)) |
|---|---|
| Subjects: | Q Science > QA Mathematics > QA76 Computer software Q Science > QA Mathematics > QA76.6 Computer Programming |
| Divisions: | Faculty of Computer Science > Departemen of Informatics |
| Depositing User: | Albi Akhsanul Hakim |
| Date Deposited: | 20 Jul 2026 06:14 |
| Last Modified: | 20 Jul 2026 06:14 |
| URI: | https://repository.upnjatim.ac.id/id/eprint/56273 |
Actions (login required)
 |
View Item |