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
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
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
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
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
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
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
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
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
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
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.