scholarly journals THE DEVELOPMENT OF THE APPLICATION OF A DATA WAREHOUSE AT PT JKL

Author(s):  
Choirul Huda ◽  
Rita Puspita Sari ◽  
Muharram Hasein Haekal ◽  
Tri Agustaria

One rapidly evolving technology today is information technology, which can help decision-making in an organization or a company. The data warehouse is one form of information technology that supports those needs, as one of the right solutions for companies in decision-making. The objective of this research is the development of a data warehouse at PT JKL in order to support executives in analyzing the organization and support the decision-making process. Methodology of this research is conducting interview with related units, literature study and document examination. This research also used the Nine Step Methodology developed by Kimball to design the data warehouse. The results obtained is an application that can summarize the data warehouse, integrating and presenting historical data in multidimensional. The conclusion from this research is the data warehouse can help companies to analyze data in a flexible, fast, and effective data access.Keywords: Data Warehouse; Inventory; Contract Approval; Inventory; Dashboard

Author(s):  
Tino Feri Efendi ◽  
Mutiya Krisanty

Data Warehouse is a computer system for archiving and analyzing historical data of an organization. An organization copies information from its operational systems to a warehouse. The purpose of this research is to help provide information in supporting the decision-making process in the field of sales, purchasing and material inventory control at PT Kanaan Global Indonesia. PT Kanaan Global Indonesia previously presented the data warehouse manually. By designing a data warehouse system, company leaders can be more assisted in making decisions that are faster and more precise. The research method used includes analysis of observations, interviews, documentation and literature study. The result of this research is the availability of a data warehouse that can produce fast and precise information, thus helping the company in making decisions.Keywords— Data, Information, Warehouse


Author(s):  
Eka Miranda

The increasing competition in hotel business forces every hotel to be equiped with analysis tools that can maximize its marketing performance. This paper discusses the development of a data warehouse model and analytic tools to enhance the company's competitive advantage through the utilization of a variety of data, information and knowledge held by the company as a raw material in the decision making process. A study is done at ABC Hotel which uses a database to save the transactional record. However, the database cannot be directly used to support analysis and decision making process. Based on this issue, the company needs a data warehouse model and analytic tools that can be used to store large amounts of data and also potentially to gain a new perspective of data distribution which allows to provide reporting and answers of ad hoc users questions and assist managers in making decisions. Further data warehouse model and analytic tools can be used to help manager to formulate planning and marketing strategies. Data are collected through interviews and literature study, followed by data analysis to analyze business processes, to identify the problems and the information to support analysis process. Furthermore, data warehouse is designed using analysis of records related to the activities in hotel's marketing area and data warehouse model. The result of this paper is data warehouse model and analytic tools to analyze the external and transactional data and to support decision making process in marketing area.


Author(s):  
Putu Widiadnyana ◽  
M. Azman Maricar ◽  
I Nyoman Arnawan ◽  
Sri Ariyani

Utilization of information technology is a necessity in looking at opportunities available for decision making by the management. With the ability of information technology to analyze existing used the data into useful information for a company. OLAP is Able to Overcome problems in the data processing mechanisms guided to know various information from different angles. By utilizing transactional analysis, then we know the reaction of customers in choosing the products that we will market. The result of Web-based sales has Decreased for the Gianyar and Denpasar regions but has Increased for the Ubud and online areas so as to give a benefit in terms of production costs. With the training for a sales increase of sales can evenly across locations and need input from customers related to minimize returns.


2019 ◽  
Vol 2 (1) ◽  
pp. 126-139 ◽  
Author(s):  
Paulina Gackowiec

Abstract This paper presents a literature review of maintenance strategies formulation. The purpose of this article is to provide an overview of different published concepts of maintenance strategies, distinguish the most common approaches to this issue and find a general tendency in strategies classification. Furthermore, the review is aimed to point out the importance of unscheduled downtime which might occur during equipment runtime in a production plant. The paper classifies the existing maintenance concepts and emphasizes key assumptions of the analysed strategies. The literature study and carried out analysis could be useful to find appropriate reliability assurance methods. In addition, defined maintenance approaches might help in decision making process in a company. The paper is a comprehensive overview of discussed strategies, which indicates the most frequent maintenance models in the analysed papers.


2012 ◽  
Author(s):  
Samuel Otero Schmidt ◽  
Edmir P. Vasques Prado ◽  
Hiroo Takaoka

The organizations are investing more in information technology to collect, store and process vast amounts of information. Generally this information has no standard and repeated data, which hinders the decision making process. The cause of the difficulties is related to Information Quality (IQ) that has technical characteristics related to the architecture used in Data Warehouse (DW) and Business Intelligence (BI) environments. Based on the existing literature and insights from the author a research model was created to identify the relations between components of DW/BI architecture and IQ dimensions. We used the case study as research method. This research makes contributions to better understand IT architecture for DW/BI.


2019 ◽  
Vol 33 (3) ◽  
pp. 89-109 ◽  
Author(s):  
Ting (Sophia) Sun

SYNOPSIS This paper aims to promote the application of deep learning to audit procedures by illustrating how the capabilities of deep learning for text understanding, speech recognition, visual recognition, and structured data analysis fit into the audit environment. Based on these four capabilities, deep learning serves two major functions in supporting audit decision making: information identification and judgment support. The paper proposes a framework for applying these two deep learning functions to a variety of audit procedures in different audit phases. An audit data warehouse of historical data can be used to construct prediction models, providing suggested actions for various audit procedures. The data warehouse will be updated and enriched with new data instances through the application of deep learning and a human auditor's corrections. Finally, the paper discusses the challenges faced by the accounting profession, regulators, and educators when it comes to applying deep learning.


2007 ◽  
Vol 97 (1) ◽  
pp. 150-168 ◽  
Author(s):  
Gilat Levy

In this paper I analyze the effect of transparency on decision making in committees. I focus on committees whose members are motivated by career concerns. The main result is that when the decision-making process is secretive (when individual votes are not revealed to the public), committee members comply with preexisting biases. For example, if the voting rule demands a supermajority to accept a reform, individuals vote more often against reforms. Transparent committees are therefore more likely to accept reforms. I also find that coupled with the right voting rule, a secretive procedure may induce better decisions than a transparent one. (JEL D71, D72)


2019 ◽  
Vol 31 (5) ◽  
pp. 1235-1241
Author(s):  
Marina Badarovska Mishevska

The analytic hierarchy process (AHP) is a structured technique for organizing and analyzing complex decisions, based on mathematics and psychology. The method was developed by Thomas L. Saaty in the 1970s and has been extensively studied and refined since then. It has particular application in group decision making and is used around the world in a wide variety of decision situation. Rather than prescribing a "correct" decision, the AHP helps decision makers choose one that best suits their goal and their understanding of the problem. The technique provides a comprehensive and rational framework for structuring a decision problem, for representing and quantifying its elements, for relating those elements to overall goals, and for evaluating alternative solutions. Decision making is the choice of one alternative, from two or more, to which the course of the activity is directed and the problem is solved. The decision-making process is a rational attempt by the manager to achieve the goals of the organizational unit. The decision-making process can be thought of as a "brain and nervous system" of an enterprise. Decisions are made when a person wants things to be different in the future. Given each specific situation, making the right decisions is probably one of the most difficult challenges for managers. Managers in day-to-day work deliver programmed and unprogrammed decisions that solve simple or complex problems. Simple decisions have an impact on the short-term performance of the enterprise, and complex decisions have an impact on the long-term future and success of the enterprise. Users of the AHP first decompose their decision problem into a hierarchy of more easily comprehended sub-problems, each of which can be analyzed independently. Once the hierarchy is built, the decision makers systematically evaluate its various elements by comparing them to each other two at a time, with respect to their impact on an element above them in the hierarchy. The AHP converts these evaluations to numerical values that can be processed and compared over the entire range of the problem. In this article, it is explained the application of the AHP method in order to evaluate and promote employees in the enterprise "X" with several criteria. The obtained results enable the manager to evaluate the employees in an objective way and make an objective decision for their promotion. Its application for selecting the best among employees, in their assessment and promotion, allows managers to use a specific and mathematical tool to support the decision. This tool not only supports and qualifies decisions, it also allows managers to justify their choice, as well as to simulate possible results.


2020 ◽  
Vol 6 (1) ◽  
pp. 111-120
Author(s):  
Rahmat Tri Yunandar ◽  
Amir Amir ◽  
Khairul Rizal

As an Educational institutions need to have more knowledge, in evaluating, designing and making decisions. Where from such knowledge can be obtained from the data stored in the operational activities of educational institutions databases into the data warehose, so it can be used as a support in the decision making process. Data Warehouse has a major role in the provision of strategic information that can be used to meet the needs of management in a business context. This study examines the development of the data warehouse to the data of new admissions to the STIE Binaniaga Bogor, which can dig up important information that can help retrieval strategic decision to support promotional activities at the STIE Binaniaga Bogor. The final goal of this study was to produce a design of a data warehouse that can support the needs of management in making decisions by providing strategic information on new admissions, which produces a summary of information that is accurate and useful as input to determine strategies for promotion.


Sign in / Sign up

Export Citation Format

Share Document