PERANCANGAN DATA WAREHOUSE PENJUALAN UNTUK PERHITUNGAN LABA RUGI (Studi Kasus di Era 5000 Lembuswana Samarinda)

Authors

  • Awang Harsa Kridalaksana Mulawarman University image/svg+xml
  • Hamdani Hamdani
  • Norma Yanti

DOI:

https://doi.org/10.30872/jim.v6i3.78

Abstract

Data Warehouse merupakan sistem repository dan merupakan suatu data yang besar dan mengandung informasi dan di digunakan untuk keperluan analisis dan laporan. Selain itu data warehouse juga digunakan untuk mendukung pengambilan keputusan untuk mementukan kebijakan dan straategi yang akan diambil untuk meningkatkan mutu penjualan dan pendapatan kedapannya. Database OLTP (OnLine Transaction Processing) yang digunakan untuk penelitian ini adalah database penjualan era5000 Lembuswana Samarinda. Database OLTP tersebut diekstrak dan dilanjutkan kedata warehouse untuk kemudian digunakan dalam pembuatan laporan. Hasil dari penelitian ini adalah sebuah data warehouse lengkap dengan pelaporan informasi hasil laba yang diperoleh mulai tahun 2006 sampai dengan 2010. Platform database yang digunakan untuk OLTP dan data warehouse pada peneltian ini adalah Microsoft SQL Server 2005. Untuk proses ETL (Extraction, Transformation, Loading) dilakukan di Integration Service. Sedangkan untuk proses pembuatan laporan dilakukan di Report Service menggunakan sistem OLAP yang dapat di akses melalui browser Internet Explorer. Digunakan query seleksi untuk proses pemilihan data operasional dan menyalurkan ketujuan yaitu data warehouse. Dengan bahasa pemrograman yang digunakan untuk membuat user interface adalah bahasa pemrograman ASP dot Net yang merupakan teknologi Microsoft yang di khususkan untuk pengembangan web dinamis. Aplikasi data warehouse hanya dapat ditampilkan menggunakan browser Internet Explorer.

Author Biography

  • Awang Harsa Kridalaksana, Mulawarman University
    Computer Science

References

Sitompul, S.O. 2006. Data Warehouse Inisiatif di Universitas Sumatra Utara. Skripsi: Teknologi Informasi, Universitas Sumatra Utara.

Turban, E., Aroson, J., dan Liang, P.T., 2005. Decision Support System (Sistem pendukung keputusan dan sistem cerdas). Yogyakarta. Andi.

Nugroho, A.D., Johan, T., Hoetama, J.T., 2008. Aplikasi Data Warehouse Untuk Analisis Penjualan Mobil Berbasis Multimensional Modeling (MDM) dan Star Schema Desain (studi kasus: PT. Asco Automotive) Jurnal Teknologi Informasi. Vol.5 No. 2. Pp 186-197.

Downloads

Published

05-06-2016

Issue

Vol. 6 No. 3 (2011): Informatika Mulawarman : Jurnal Ilmiah Ilmu Komputer

Section

Articles

License

Copyright Transfer Statement

The copyright of this article is transferred to Informatika Mulawarman : Jurnal Ilmiah Ilmu Komputer and when the article is accepted for publication. the authors transfer all and all rights into and to paper including but not limited to all copyrights in the Informatika Mulawarman. The author represents and warrants that the original is the original and that he/she is the author of this paper unless the material is clearly identified as the original source, with notification of the permission of the copyright owner if necessary. The author states that he has the authority and authority to make and carry out this task.
The author states that:

  1. This paper has not been published in the same form elsewhere.
  2. This will not be submitted elsewhere for publication prior to acceptance/rejection by this Journal.

A Copyright permission is obtained for material published elsewhere and who require permission for this reproduction. Furthermore, I / We hereby transfer the unlimited publication rights of the above paper to Informatika Mulawarman : Jurnal Ilmiah Ilmu Komputer. Copyright transfer includes exclusive rights to reproduce and distribute articles, including reprints, translations, photographic reproductions, microforms, electronic forms (offline, online), or other similar reproductions.

The author's mark is appropriate for and accepts responsibility for releasing this material on behalf of any and all coauthor. This Agreement shall be signed by at least one author who has obtained the consent of the co-author (s) if applicable. After the submission of this agreement is signed by the author concerned, the amendment of the author or in the order of the author listed shall not be accepted.

Rights / Terms and Conditions Saved

  1. The author keeps all proprietary rights in every process, procedure, or article creation described in Work.
  2. The author may reproduce or permit others to reproduce the work or derivative works for the author's personal use or for the use of the company, provided that the source and the Informatika Mulawarman copyright notice are indicated, the copy is not used in any way implying the Journal of Informatika Mulawarman (JIM) approval of the product or service from any company, and the copy itself is not offered for sale.
  3. Although authors are permitted to reuse all or part of the Works in other works, this does not include granting third-party requests to reprint, republish, or other types of reuse.

Creative Commons License
Informatika Mulawarman by http://e-journals.unmul.ac.id/index.php/JIM/index is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

under the CC BY-SA license, authors and other users are able to reprint, distribute or use the material for commercial purposes so long as they give attribution to the journal Informatika Mulawarman and license the republished material under the same license.