PENGEMBANGAN DATA WAREHOUSE SEBAGAI SARANA PENUNJANG KEGIATAN AKADEMIK INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL
DOI:
https://doi.org/10.31000/jika.v4i2.2466Abstrak
Perkembangan kebutuhan informasi yang meliputi seluruh bidang, baik di bidang bisnis, pendidikan, dan lain-lain. Dalam bidang pendidikan di Institut Sains dan Teknologi Al-Kamal terutama dalam mengelola data-data akademik yang berhubungan dengan aktifitas kegiatan perkuliahan baik dosen maupun mahasiswa, saat ini pihak manajemen mengalami kesulitan mendapatkan informasi yang akurat disebabkan data diperoleh dari laporan dan sumber data yang berbeda. Kondisi sistem informasi akademik yang ada belum mampu menghasilkan informasi yang diinginkan pihak manajemen mengenai profil mahasiswa baru, Â profil mahasiswa dan profil lulusan, hasil informasi dari profil tersebut akan digunakan sebagai landasan analisa dalam pengambilan keputusan. Untuk memenuhi kebutuhan, maka dirancang sebuah data warehouse akademik yang mempunyai peranan penting dalam membantu manajemen dalam penganbilan keputusan. Metode yang digunakan dalam perancangan data warehouse adalah Four Step Design Methodology, teknik untuk memodelkan data menggunakan snowflake schema, hasil dari data warehouse akan dianalisis menggunakan Business Intelligence dengan OLAP (On-Line Analytical Processing). Bentuk laporan yang dihasilkan dalam sebuah dashboard sistem yang menghasilkan laporan dalam bentuk grafik, data base yang digunakan adalah Microsoft SQL Server 2008. Hasil dari penelitian ini terciptanya sebuah pangkalan data dan aplikasinya yang dapat menghasilkan informasi tentang profil mahasiswa baru, profil mahasiswa dan profil lulusan dari periode ke periode yang akan digunakan sebagai dasar dalam mengevaluasi kinerja setiap program studi oleh manajemen.
Â
Kata Kunci :Â Â Â Data Warehouse, Four Step Design Methodology, Snowflake Schema.
Unduhan
Diterbitkan
Terbitan
Bagian
Lisensi
License and Copyright Agreement
In submitting the manuscript to the journal, the authors certify that:
- They are authorized by their co-authors to enter into these arrangements.
- That it is not under consideration for publication elsewhere,
- That its publication has been approved by all the author(s) and by the responsible authorities – tacitly or explicitly – of the institutes where the work has been carried out.
- They secure the right to reproduce any material that has already been published or copyrighted elsewhere.
- They agree to the following license and copyright agreement.
Copyright
Authors who publish with International Journal of Advances in Intelligent Informatics agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.Â
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
Licensing for Data Publication
International Journal of Advances in Intelligent Informatics use a variety of waivers and licenses, that are specifically designed for and appropriate for the treatment of data:
Open Data Commons Attribution License, http://www.opendatacommons.org/licenses/by/1.0/ (default)
Creative Commons CC-Zero Waiver, http://creativecommons.org/publicdomain/zero/1.0/
Open Data Commons Public Domain Dedication and Licence, http://www.opendatacommons.org/licenses/pddl/1-0/
Other data publishing licenses may be allowed as exceptions (subject to approval by the editor on a case-by-case basis) and should be justified with a written statement from the author, which will be published with the article.
Open Data and Software Publishing and Sharing
The journal strives to maximize the replicability of the research published in it. Authors are thus required to share all data, code or protocols underlying the research reported in their articles. Exceptions are permitted but have to be justified in a written public statement accompanying the article.
Datasets and software should be deposited and permanently archived inappropriate, trusted, general, or domain-specific repositories (please consult http://service.re3data.org and/or software repositories such as GitHub, GitLab, Bioinformatics.org, or equivalent). The associated persistent identifiers (e.g. DOI, or others) of the dataset(s) must be included in the data or software resources section of the article. Reference(s) to datasets and software should also be included in the reference list of the article with DOIs (where available). Where no domain-specific data repository exists, authors should deposit their datasets in a general repository such as ZENODO, Dryad, Dataverse, or others.
Small data may also be published as data files or packages supplementary to a research article, however, the authors should prefer in all cases a deposition in data repositories.
