Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : Jurnal CoreIT

Data Warehouse Design For Sales Transactions on CV. Sumber Tirta Anugerah Syaputra, Muhammad Dwiky; Nazir, Alwis; Gusti, Siska Kurnia; Sanjaya, Suwanto; Syafria, Fadhilah
Jurnal CoreIT: Jurnal Hasil Penelitian Ilmu Komputer dan Teknologi Informasi Vol 8, No 2 (2022): December 2022
Publisher : Fakultas Sains dan Teknologi, Universitas Islam Negeri Sultan Syarif Kasim Riau

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (644.133 KB) | DOI: 10.24014/coreit.v8i2.19800

Abstract

Many data warehouses are implemented in companies engaged in retail, CV. Sumber Tirta Anugerah is one of the paint product retail companies that has not implemented it yet. As time goes by, the sales transaction data is getting more and more difficult to process because it is still stored in Microsoft Excel. This is a serious problem in utilizing historical data to assist in making a decision. It is difficult to store sales data because the data is quite large and a lot. Based on the above problems, a data warehouse design is needed for sales transaction data. This data warehouse design uses Kimball's nine-steps method and star schema. To perform the ETL process (extract, transform, and load) using Pentaho software. In this data warehouse design, Tableau software is used to visualize the processed data into a graph and dashboard report. The result of this research is a data warehouse design using nine steps and a star schema which gets a transformation response time of 4048 MS. 
THE INFLUENCE OF MAJOR EXPERTISE COURSES ON ALUMNI EMPLOYMENT USING THE APRIORI METHOD Irsyad (Scopus ID: 57204261647), Muhammad; Iskandar, Iwan; Gusti, Siska Kurnia
Jurnal CoreIT: Jurnal Hasil Penelitian Ilmu Komputer dan Teknologi Informasi Vol 10, No 2 (2024): December 2024
Publisher : Fakultas Sains dan Teknologi, Universitas Islam Negeri Sultan Syarif Kasim Riau

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24014/coreit.v10i2.34144

Abstract

The role of alumni in university progress and quality is vital. This study used data from the tracer study application to analyze the relationship between skill courses and alumni employment. The data mining technique of association was employed to find linkages between different parameters. The Apriori algorithm was used to identify patterns that described the relationship between skill courses and alumni employment. The findings revealed that the most sought-after professions by alumni of the Informatics Engineering Study Program were educators, such as teachers and lecturers, with a support value of 18.7692%. Programmers were also in high demand, with a support value of 15.3846%. The subjects that were found to have the greatest influence on employment were Database, Computer Network, Computer Human Interaction, and Software Engineering. These findings provide valuable insights for the Informatics Engineering Study Program to prioritize and enhance these influential courses in terms of curriculum, teaching methods, and teaching materials, with the aim of improving the relevancy and quality of the courses in supporting alumni employment.
Co-Authors Abdul Wahid Abdullah Abdullah Abdullah, Said Noor Abdussalam Al Masykur Adi Mustofa Al Rasyid, Nabila Alfaiza, Raihan Zia Alfin Hernandes Alwaliyanto Alwis Nazir Alwis Nazir Alwis Nazir Amelia, Felina Anggi Vasella Azhima, Mohd Baehaqi Beni Basuki Cut Lira Kabaatun Nisa Destri Putri Yani Devi Julisca Sari Dina Septiawati efni humairah Eka Pandu Cynthia Eka Pandu Cynthia Elin Haerani Elin Haerani Elin Haerani Elin Haerani Elvia Budianita Erni Rouza, Erni Fadhilah Syafria Faska, Ridho Mahardika Febi Yanto Fitri Insani Fitri Insani Fitri Wulandari Fitri, Anisa Gusti, Gogor Putra Hafi Puja Hamwar, Syahbudin Iis Afrianty Iis Afrianty Iqbal Salim Thalib Irsyad (Scopus ID: 57204261647), Muhammad Iwan Iskandar Jasril Jasril Jasril Jasril Khair, Nada Tsawaabul Kurniansyah, Juliandi Lestari Handayani M Wandi Dwi Wirawan Maemonah, Maemonah Morina Lisa Pura Muhammad Affandes Muhammad Fauzan Muhammad Irsyad Muhammad Khairy Dzaky Muhammad Rifaldo Al Magribi Nazir, Alwis Norhiza, Fitra Lestari Novriyanto Novriyanto Nurul Ikhsan Okfalisa Okfalisa Pizaini Pizaini Prima Yohana Rahmah Miya Juwita Raja Indra Ramoza Ramadhani, Astrid Risfi Ayu Sandika Robbi Nanda Robby Azhar Sardi, Hajra Satria Bumartaduri Sayyid Muhammad Habib Siti Ramadhani Siti Ramadhani Siti Ramadhani Surya Agustian Suwanto Sanjaya Syafira, Fadhilah Syafria, Fadhillah Syaputra, Muhammad Dwiky Umam, Isnaini Hadiyul Vusuvangat, Imam Wulandari, Fitri Yayuk Wulandari Yelfi Yelfi Yola, Melfa Yusra Yusra, - Yusra, Yusra