Claim Missing Document
Check
Articles

Design of Data Warehouse for Minimarket’s Sales Information Using Tabular Models I Gusti Ngurah Agung Jaya Sasmita; Made Sudarma; Dewa Made Wiharta
International Journal of Engineering and Emerging Technology Vol 5 No 2 (2020): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24843/IJEET.2020.v05.i02.p06

Abstract

Alongside with development of technology, more business need support of business intelligence tools to transform its data in a meaningful way which is accumulated rapidly in every transaction occurred. In order to achieved that, data warehouse with its online analytical processing (olap) can be considered as a solution. One tools for creating an olap from data warehouse is SSAS. This tools consist of two models, first one is multidimensional models or can be said the traditional one and the new one is tabular models. One best feature that tabular models give is the time needed for building it. The tabular models does not require the data in format of fact and dimension tables so reduce the time to change particular data into some scheme (star or snowflake). Hence, the purpose of this research is to design a data warehouse for minimarket’s sales information using the advantage of tabular modeling for creating the analysis. Its also known that, the data analysis created using tabular, support reporting application such as pivot table excel, so the user not need to create a new application for reporting analysis
Design of E-Grant Application Data Warehouse A.A Ngurah Narendra; Santi Ika Murpratiwi; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 2 No 1 (2017): January - June
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Grants is a program launched by the government as a means to develop the potential of the region or contribute to society in the form of money or objects In submitting as Grant there are many sources of data stored in the system e -Grant, The amount of the proposal Grant is very much in each period so as to be reorganized, One solution for the storage of e-submission of the Grant is to build a data warehouse, Due to the technological development of data warehouse will be able to support the creation of a single access door managerial parties in obtaining information in the data warehouse, The design of the data warehouse were calculated using a four step Kimball, Methods Kimball 4 step has the advantages of a more compact, dynamic, and supports the creation of a data warehouse that is structured output of the data warehouse to the e-Grant in the form of Reports Grant and a recapitulation of Grant where reports Grant is being used as an attachment to a defense in response to the report Expenditure Provincial Bali whereas Summary of Grants used for List SKPD to evaluate the Grant recipient.
Implementation of EM Algorithm in Data Mining for Clustering Female Cooperative Putu Angelina Widya; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 3 No 1 (2018): January - June
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Cooperatives have a key role for women by providing access to generating income activities. Women have access to general production resources like credit, land, marketing facilities, infrastructure, equipment, and technology. All of that resources can increase their income. By shaping themselves into cooperatives, they can get benefit from economies scale and increase their access to the labor market. Cooperatives can be the best instruments to improve women’s welfare and for the development of transformations such as more open minded by using the most profitable female cooperatives. As one of the existing regencies in Bali Province, Gianyar regency has rapid development of female cooperative. In this research will clustering female cooperative by using WEKA application with Expectation-Maximization Algorithm. From the result, government can maintance which female cooperation should be put on watchlist.
Project Management Information System Audit with COBIT 5 Framework Focused on DSS Domains Andrew Sumichan; I Made Gede Yudiyana; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 3 No 2 (2018): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Information system management as a recording media for transactions, especially a construction project, is a management and financial strength for the company. Poor IT governance can cause various problems to arise and harm related parties that lead to company failures and losses. Auditing Information system is conducted to find the value of the maturity level of a management of information technology management in a company to fix existing problems. This study conducted an audit process on a project management information system with Cobit 5 Framework focusing on DSS domain. Study case is PT.K a contracting companies with the results of the capability level at the company is 2.16 and requires a quick fix on the DSS05 process.
Management Information System Design Hospital Health Services Using Scrum I Gusti Ngurah Agung Surya Mahendra; Ida Bagus Leo Mahadya Suta; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 3 No 2 (2018): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

The standard of health services for health providers is to provide maximum service to patients. Based on the Ministry of Health Number: 129 / Menkes / SK / II / 2008 the waiting time of patients is approximately 60 minutes so we can assume that the management of the average time in the field is 15 minutes the process of retrieving queue numbers, 40 minutes waiting time and checking patients and 25 minutes time prescription retrieval at the pharmacy, with the translation of the allocation time we can develop an Agile development system with Scrum framework. Development using Scrum framework itself is used to overcome the problems of development time and human resources so that the results obtained can be evaluated to determine the level of functionality and effectiveness of the system in terms of user satisfaction and increase the quality of service providers and medical personnel.
Classification and Prediction of Smoking Behavior and Hypertension in the Healthy Family Program with R (Case Study : Bali Provincial Government Department of Health) I Gede Abi Yodita Utama; Nyoman Pramaita; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 5 No 2 (2020): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24843/IJEET.2020.v05.i02.p07

Abstract

The Healthy Indonesia Program with the Family Approach aims to improve the quality of human life and is a government program that starts from the family environment. There are 12 indicators marking the health status of a family. The Provincial Government of Bali in implementing the 12 indicators there are two main problems of non-communicable diseases, namely patients with hypertension and smoking behavior. An analysis in the form of classification and prediction is needed to overcome these problems. Classification and prediction is one of the techniques in data mining. Through R, a decision tree can be produced which can be used to help the classification process and produce predictions related to the problem of non-communicable diseases. The decision tree results can be predicted that the dominant hypertension are in the age group classification of 20-40 years and 41-70 years with a probability of 0.14. As for smoking behavior, the highest smoking tendency was obtained in the classification of male sex whose status worked with a probability of 0.44.
Bussines Intelligent in Telemarketing Using SVM Putu Agung Ananta Wijaya; Komang Budiarta; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 2 No 1 (2017): January - June
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Direct marketing provides an advantage in approaching consumers. Communication that happens allows us more closely, able to change the behavior and know the needs required by consumers accurately. But this technique has a lack of time. It takes a long time to convince consumers to buy the products offered. Bussines intelligent with data mining approach to consumer data is required. This process will analyze the potential possessed by a consumer. At the stage of the DSS used SVM method to predict whether consumers will buy products that have been offered. Bussines intelligent built proven able to predict consumers who have the potential to buy products. Tests show the greatest prediction accuracy rate is 89.5% with a combination of data traning of 70% of the dataset.
Middleware ETL with CDC based on Event Driven Programming I Gede Adnyana; Made Sudarma; Wayan Gede Ariastina
International Journal of Engineering and Emerging Technology Vol 3 No 2 (2018): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

To achieve the real time data warehouse is strongly influenced by the process in the data warehouse known as Extract, Tranform, Loading (ETL). One way to optimize the ETL process is processing only data that undergoes changes on the On Line Transaction Processing (OLTP) system. This technique is known as Change Data Capture (CDC) which is designed to maximize the efficiency of the ETL process. In this research middleware was built as a place where the ETL process will be carried out, transaction data from the OLTP system will be captured and sent directly to the middleware for further processing. The method used to capture changes in OLTP systems is Change Data Capture (CDC) based on Event Driven Programming, where this technique relies on events that occur in OLTP in capturing data changes. Functional testing is done by making a simulation of the insert and update processes in test applications namely OLTP CRM system.The results of the research obtained are (1) Change Data Capture (CDC) based on Event Driven Programming can capture changes in data that occur in OLTP CRM database;(2) ETL process to load data from Normalized Data Store (NDS ) to data warehouse with Timestamp technique can load data that only undergoes changes that are processed to be loaded in Data Warehouse;(3) An increase in the amount of data that is processed has an effect on increasing processing time. Other factors that affect the value of process time are execution plan and cache memory
Analysis Of Data Warehouse Design Using Powell Method Hisyam Rahmawan Suharno; Nyoman Gunantara; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 5 No 2 (2020): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24843/IJEET.2020.v05.i02.p03

Abstract

With the evolution in this digital era, many industrial organizations and companies have begun to move towards digitization to increase the company's business opportunities. Data is something that is very useful in a company's business. If the dataprocessed correctly can provide a variety of information needed by the company to continue to grow. Now Data also becomes digital and data processing have many techniques and can provide us with a decision support for the information generated by the data. The data processing is usually called Data Warehouse. In running a business, business owners must certainly analyze a number of things so that the business continues to run and grow, including one of which is a fabric business in Bali, namely CV Phalani Bali. CV Phalani Bali still needs a centralized system that integrates sales data from online stores and offline stores, therefore a data warehouse is needed that can help manage all these data and make it a new information needed by CV Phalani Bali. With the data warehouse, it can help the owner of CV Phalani Bali in reporting and historical information of the business they run. Helps manage historical data and provides strategic information to support evaluation and take decision analysis at the executive level. So one of the data warehouse design methods is used, is the Powell method. This Powell method focuses on the ETL (Extract, Transform, Load) process to become a data warehouse that is ready to be processed by OLAP (Online Analytical Processing). This Powell method will be assisted by Microsoft SQL Server Business Intelligence as a tool that will design and process the sales data into a data warehouse that will produce the information needed by CV Phalani Bali for analyze and make decisions to bring cv phalani bali even more advanced.
Audit E-Signature Public Service Project Using Knowledge Quality Management Gde Brahupadhya Subiksa; Kadek Ary Budi Permana; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 2 No 2 (2017): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Management Information System Project (E-Signature) is a collaborative project between the Department Investment and Integrated Service Denpasar City with Institute for Research and Community Service of Udayana University. This project is commenced on 21 April 2017 and must be completed on 21 August 2017, the project is supervised and controlled directly by the Section Data Processing and Investment Information System. The plan of this project will be launched in January 2018. Before the system is launched and used by permit applicants and related officials, we need to have an audit on the quality of project management. To measure the quality of project management we used one of the knowledge in the Project Management Body Framework of Knowledge (PMBOK) that is Management Quality Project. We also use Capability Maturity Model (CMM) to help define the maturity level of information systems management. With this we can know the quality of Project Management Information System Management License (E-Signature) at the Department Investment and Integrated Service Denpasar City and provide recommendations or information related to the results of the audit we have done.
Co-Authors A. A. K. Oka Sudana A.A Ngurah Narendra A.A Raka Novi Aristi Adi Darmawan Ervanto Adinata Mas Pratama Aggry Saputra Aggry Saputra Agus Aan Jiwa Permana Agus Dharma Ahmad Catur Widyatmoko Ajeng Anandra Anak Agung Kompiang Oka Sudana Anak Agung Ngurah Prawira Yudha Andrew Sumichan Andrew Sumichan Ari Kamayanti Ariyady Kurniawan Muchsin Asri Prameshwari Casya Nova Nitali Ginting Charolina Devi Oktaviana Soleman Charolina Devi Oktaviana Soleman Dandy Pramana Hostiadi Darma Kotama, I Nyoman Darma Putra Dea Novim Kartikasari Dewa Ayu Putri Wulandari Dewa Made Wiharta Dima Nurfitri Apriani Dita Rizky Prahayuningtyas Duman Care Khrisne Erwin Saraswati Faraz Muhammad Aulia Fauziah, Farah Ferry Angga Irawan Gde Brahupadhya Subiksa Hanif Prio Ariantono Hardi yusa Hisyam Rahmawan Suharno Hisyam Rahmawan Suharno I Dewa Made Krisnayana I Dewa Nyoman Anom Manuaba I Dewa Nyoman Anom Manuaba I Gede Abi Yodita Utama I Gede Adnyana I Gede Harsemadi I Gede Herry Juniartha I Gede Sujana Eka Putra I Gede Totok Suryawan I Gede Wira Darma I Gst Agung Alit Wismaya I Gusti Agung Gede Mega Perbawa I Gusti Agung Indrawan I Gusti Agung Komang Diafari Djuni Hartawan I Gusti Kade Harta Kesuma Wijaya I Gusti Made Panji Indrawinatha I Gusti Ngurah Adhy Pradhana I Gusti Ngurah Agung Jaya Sasmita I Gusti Ngurah Agung Surya Mahendra I Gusti Ngurah Agung Surya Mahendra I Gusti Ngurah Gede Agung Suniantara I Gusti Ngurah Rai Dharma Widhura I Gusti Rai Agung Sugiartha I Kadek Agung Bagus Satria Bumi Kelana I Kadek Arya Wiratama I Kadek Dwi Gandika Supartha I Kadek Sastrawan I Kadek Yuda Setiadi I ketut Gede Darma Putra I Ketut Putra Swastika I Komang Yogi Sutrisna I Made Adi Bhaskara I Made Arsa Suyadnya I Made Artawan I Made Budi Sentana I Made Cakra Pustaka1 I Made Dwi Ardiada I Made Dwi Jendra Sulastra I Made Gede Yudiana I Made Gede Yudiyana I Made Oka Widyantara I Made Sukarsa I Made Sukarsa I N Satya Kumara I Nyoman Adi Putra I Nyoman Gunantara I Nyoman Putu Suwindra I Putu Adi Pradnyana Wibawa I Putu Agung Bayupati I Putu Agus Eka Darma Udayana I Putu Agus Eka Darma Udayana, I Putu Agus Eka I Putu Agus Priska Suryana I Putu Alit Putra Yudha I Putu Arya Putrawan I Putu Astya Prayudha I Putu Gd Sukenada Andisana I Putu Oka Wisnawa I Putu Putra Diyastama I Putu Putrayana Wardana I Putu Sugi Almantara I Putu Warma Putra I Wayan Agus Surya Darma I Wayan Eka Krisna Putra I Wayan Suarna Ida Ayu Dwi Giriantari Ida Ayu Listia Dewi Ida Ayu Putu Febri Imawati Ida Bagus A. Swamardika Ida Bagus Agung Eka Mandala Putra Ida Bagus Dwijaya Kesuma Ida Bagus Gede Manuaba Ida Bagus Gede Widnyana Putra Ida Bagus Leo Mahadya Suta Ida Bagus Leo Mahadya Suta Ida Bagus Leo Mahadya Suta Ida Bagus Surya Paramarta IGAM Yoga Mahaputra Irvan Dinda Prakoso Irwansyah Cahya Irwansyah Cahya Adha L Iskandar, Adi Panca Saputra Isnan Murdiansyah IW Dani Pranata Jauzaa Maylia Suhendro Josep Geas Sapalatua Kadek Ary Budi Permana Kadek Ary Budi Permana Kadek Ary Budi Permana Kadek Ary Budi Permana Kheri Arionadi Shobirin Komang Agus Putra Kardiyasa Komang Ayu Triana Indah Komang Budiarta Komang Budiarta Komang Budiarta Komang Isabella Anasthasia Komang Nova Artawan Komang Oka Saputra Komang Sri Utami Lanang Bagus Amertha Lanang Bagus Amertha Leonardus Guido Adi Wungo Lie Jasa Linawati Linawati Luh Gede Putri Suardani Luh Ria Atmarani M. Azman Maricar Made Dinda Pradnya Pramita Made Dinda Pradnya Pramita Made Pasek Agus Ariawan Made Pradnyana Ambara, Made Pradnyana Made Sri Indradewi Adnyana Manuh Artana Michael Tanduk Langi Londong Allo Minho Jo Minho Jo Minho Jo Mirna Amirya Muhammad Ridwan Satrio Murpratiwi, Santi Ika Naser Jawas Nengah Widiangga Gautama Ni Ketut Novia Nilasari Ni Komang Sri Julyantari Ni Komang Sukri Antariani Ni Luh Gede Pivin Suwirmayanti, S.Kom, MT, Ni Luh Gede Pivin Ni Luh Ratniasih, Ni Luh Ni Made Ananda Putri Pratiwi Ni Made Ari Lestari Ni Made Dwi Antari Ni Putu Sutramiani Ni Wayan Lusiani Ni Wayan Sri Ariyani Nurkholis - Nyoman Dewi Ayu Ratih Arya Dewanti Nyoman Gede Yudiarta Nyoman Paramaita Nyoman Pramaita Nyoman Putra Sastra Nyoman Swastika Dharma Pande Made Sutawan Philipus Novenando Mamang Weking Purwania Ida Bagus Gede Putri Sintya Dewi Putri Suardani Putu Agung Ananta Wijaya Putu Angelina Widya Putu Arya Mertasana Putu Bagus Satria Paramartha Putu Risanti Iswardani Putu Wirya Kastawan R. Sapto Hendri Boedi Soesatyo Reni Surmayanti Ricky Aurelius Nutanto Diaz, Ricky Aurelius Rifky Lana Rahardian Risky Aswi R, Risky Rizal W.H. Siagian Rizky Muharram Julyanto Rodrick Benediktus Kainama Roekhudin, Roekhudin Rukmi Sari Hartati Rukmi Sari Hartati Tria Hikmah Fratiwi Vony Wahyunurani Wahyudin Wahyudin Wayan Gede Ariastina Wikan Pradnya Dana, Gde Y. Yuliati Yogiswara Dharma Putra Yogiswara Dharma Putra Yoni Yogiswara Yudhistira Bayu Perkasa Zulfachmi, Zulfachmi