ANALISIS DAN PERANCANGAN DATA WAREHOUSE UNTUK MENDUKUNG KEPUTUSAN REDAKSI TELEVISI MENGGUNAKAN METODE NINE-STEP KIMBALL

ABSTRAK Masalah yang sering dihadapi di redaksi televisi dalam rutinitas editorial atau pemberitaan adalah tidak adanya suatu sistem yang dapat menjadi instrumen pendukung keputusan cepat untuk merespon setiap perubahan informasi yang bergerak sangat cepat. Teknologi data warehouse yang dapat dimanfaatkan dalam bisnis maupun lembaga, organisasi, atau pun korporasi memiliki kemampuan dalam mengumpulkan data dalam kurun waktu tertentu dan dari berbagai sumber, dan informasi hasil pengolahan data warehouse dapat dimanfaatkan untuk mendukung pengambilan keputusan cepat. Aplikasi pusat data pada data warehouse dengan mengumpulkan berbagai data, informasi, dan pengetahuan dalam kurun waktu tertentu mampu memenuhi kebutuhan pencarian cepat atau query, pelaporan rutin dan berkala atau reporting, dan data mining. Dengan demikian, teknologi data warehouse dapat dimanfaatkan di redaksi televisi untuk mendukung pengambilan keputusan cepat, termasuk membantu memberikan informasi dan pengetahuan yang lebih akurat dalam membuat suatu keputusan strategis. Selain itu, kemampuan data warehouse juga dapat dimanfaatkan untuk pengukuran kinerja karyawan dan tim redaksi televisi untuk kepentingan pengembangan tim dan pengembangan karier. Sebagai tahap awal, diperlukan suatu analisis dan perancangan data warehouse untuk mendukung keputusan redaksi televisi. Masalahnya adalah bagaimana melakukan perancangan analisis dan perancangan data warehouse untuk mendukung keputusan redaksi televisi? Dengan mengkaji kasus redaksi Kompas TV Jakarta, pada riset ini, peneliti menganalisis dan merancang data warehouse untuk mendukung keputusan redaksi televisi menggunakan metode nine-step Kimball. Hasil analisis dan perancangan tersebut dapat diimplementasikan untuk mendukung keputusan cepat terkait pemilihan berita untuk ditayangkan, dan keputusan penjenjangan karier dan pemberian insentif bagi karyawan dengan kinerja bagus. ABSTRACT The problem that often occurs in the editorial editorial or reporting routine is that there is no system that can be an instrument that supports quick decisions to receive information that moves very quickly.Data warehouse technology that can be utilized in businesses and institutions, organizations, or even corporations has the ability to collect data within a certain period of time and from various sources, and information on the results of data warehouse processing can be used to support rapid decision making. Data center applications in the data warehouse by collecting various data, information, and knowledge within a certain period of time can meet the needs of quick search or query, routine and periodic reporting or reporting, and data mining. Thus, data warehouse technology can be utilized in television editors to support quick decision making, including helping to provide more accurate information and knowledge in making strategic decisions. In addition, the data warehouse capability can also be used to measure the performance of employees and the television editorial team for the benefit of team development and career development. As an initial stage, an analysis and design of a data warehouse is needed to support the decision of the television editor. The problem is how to design the analysis and design of a data warehouse to support the decision of the television editor? By reviewing the Kompas TV Jakarta editorial case, in this research, researchers analyzed and designed the data warehouse to support the decision of television editors using the nine-step Kimball method. The results of the analysis and design can be implemented to support quick decisions regarding the selection of news to be aired, and career lending decisions and providing incentives for employees with good performance.

Download Full-text

Analysis and Design of Data Warehouse on Academic STMIK STIKOM Bali

International Journal of Engineering and Emerging Technology ◽

10.24843/ijeet.2017.v02.i01.p08 ◽

2017 ◽

Vol 2 (1) ◽

pp. 35

Author(s):

Komang Budiarta ◽

Putu Agung Ananta Wijaya ◽

Cokorde Gede Indra Partha

Keyword(s):

Decision Making ◽

Data Warehouse ◽

Evaluation Process ◽

Process Data ◽

Study Program ◽

Analysis And Design ◽

Self Evaluation ◽

Data Source ◽

System Information

College accreditation by BAN-PT is one of the parameters in determining the quality of universities in Indonesia. As consideration to achieve the standard from BAN-PT, so they have an evaluation process itself in study program or college to be meet the standard universities when set by the BAN-PT. In carrying out the process of self evaluation, required data source that is used as the basis in assessing on a criteria. In most of the study program, all data spread on the system information and physical document that different, that is require more time and effort to integrate up to interpret. Data warehouse fight important in collecting data that spread and become an information. The process data warehouse with ETL used to integrate, extract, clean, transforming and reload into the data warehouse. With the existence of the data warehouse on Academic STIMIK STIKOM Bali can make it easier for executives to get the information to support the standard accreditation standart three and can be used as a reference in decision making.

Download Full-text

Casey's Collections: A Strategic Decision-Making Case Using the Systems Development Lifecycle—Planning and Analysis Phases

Journal of Emerging Technologies in Accounting ◽

10.2308/jeta-51472 ◽

2016 ◽

Vol 13 (2) ◽

pp. 231-245

Author(s):

Kimberly S. Church ◽

Pamela J. Schmidt ◽

Georgia Smedley

Keyword(s):

Decision Making ◽

Life Cycle ◽

Information Systems ◽

System Development ◽

Systems Development ◽

Strategic Decision ◽

Strategic Decision Making ◽

Strategic Decisions ◽

Analysis And Design ◽

Development Lifecycle

ABSTRACT The Systems Development Life Cycle (SDLC) model, developed in the 1980s, remains the foundational model for strategic decision making regarding the development or acquisition of new information systems (IS). The SDLC model proposes five system development phases—planning, analysis, design, implementation, and maintenance—using a waterfall theory. These early phases of the SDLC require strategic decisions to be made regarding information systems. Strategic decision making is a model of multi-attribute utility theory, which helps promote decisions that maximize utility among multiple alternatives. This case provides students with experience in making reasoned strategic IT decisions by executing the planning and analysis phases in a new system acquisition life cycle. This educational case is structured to be the first of several cases covering the SDLC involving the same small fictitious public corporation, Casey's Collections. Upon completion of the case, students should have a deeper understanding and appreciation for the process of IS strategic decision making. In addition, students should better understand how to identify an information system's needs and prepare system proposals based on the generation and analysis of alternative solutions. This case is suitable for students in an introductory or graduate accounting systems course; it is also appropriate for use in a IS course on systems analysis and design.

Download Full-text

Data Mining in Human Resources

Data Warehousing and Mining ◽

10.4018/978-1-59904-951-9.ch142 ◽

2008 ◽

pp. 2371-2378

Author(s):

Marvin D. Troutt ◽

Lori K. Long

Keyword(s):

Data Mining ◽

Decision Making ◽

Strategic Planning ◽

Human Resources ◽

Planning Process ◽

Transaction Processing ◽

Strategic Decisions ◽

Strategic Planning Process ◽

Manual Processing ◽

Related Transaction

In this paper, we briefly review and update our earlier work (Long & Troutt, 2003) on the topic of data mining in the human resources area. To gain efficiency, many organizations have turned to technology to automate many HR processes (Hendrickson, 2003). As a result of this automation, HR professionals are able to make more informed strategic HR decisions (Bussler & Davis, 2002). While HR professionals may no longer need to manage the manual processing of data, they should not abandon their ties to data collected on and about the organization’s employees. Using HR data in decision-making provides a firm with the opportunity to make more informed strategic decisions. If a firm can extract useful or unique information on the behavior and potential of their people from HR data, they can contribute to the firm’s strategic planning process. The challenge is identifying useful information in vast human resources databases that are the result of the automation of HR related transaction processing.

Download Full-text

Web Page Extension of Data Warehouses

Encyclopedia of Data Warehousing and Mining, Second Edition ◽

10.4018/978-1-60566-010-3.ch320 ◽

2011 ◽

pp. 2090-2095

Author(s):

Anthony Scime

Keyword(s):

Decision Making ◽

Data Warehouse ◽

Decision Maker ◽

Search Engine ◽

External Information ◽

Data Warehouses ◽

Strategic Decisions ◽

Web Searches ◽

To Come ◽

The Web

Data warehouses are constructed to provide valuable and current information for decision-making. Typically this information is derived from the organization’s functional databases. The data warehouse is then providing a consolidated, convenient source of data for the decision-maker. However, the available organizational information may not be sufficient to come to a decision. Information external to the organization is also often necessary for management to arrive at strategic decisions. Such external information may be available on the World Wide Web; and when added to the data warehouse extends decision-making power. The Web can be considered as a large repository of data. This data is on the whole unstructured and must be gathered and extracted to be made into something valuable for the organizational decision maker. To gather this data and place it into the organization’s data warehouse requires an understanding of the data warehouse metadata and the use of Web mining techniques (Laware, 2005). Typically when conducting a search on the Web, a user initiates the search by using a search engine to find documents that refer to the desired subject. This requires the user to define the domain of interest as a keyword or a collection of keywords that can be processed by the search engine. The searcher may not know how to break the domain down, thus limiting the search to the domain name. However, even given the ability to break down the domain and conduct a search, the search results have two significant problems. One, Web searches return information about a very large number of documents. Two, much of the returned information may be marginally relevant or completely irrelevant to the domain. The decision maker may not have time to sift through results to find the meaningful information. A data warehouse that has already found domain relevant Web pages can relieve the decision maker from having to decide on search keywords and having to determine the relevant documents from those found in a search. Such a data warehouse requires previously conducted searches to add Web information.

Download Full-text

The Research of Intelligence Data Mining Oriented to Battlefield Situation Assessment

Applied Mechanics and Materials ◽

10.4028/www.scientific.net/amm.427-429.1662 ◽

2013 ◽

Vol 427-429 ◽

pp. 1662-1665

Author(s):

Jing Xue Liu ◽

Wei Tang

Keyword(s):

Data Mining ◽

Decision Making ◽

Data Warehouse ◽

Data Warehouses ◽

Situation Assessment ◽

Basic Construction ◽

Holistic Conception

Battlefield situation assessment has a positive significance on improving the efficiency of commanding decision-making; moreover, battlefield situation assessment cannot be made successfully without the support of some integrated and exact intelligence data. In this paper, basing on the demand of identifying the battlefield situation, the corresponding knowledge context database was first discussed; on this basic, construction of the intelligence data warehouses framework was explored. Then, the study of data mining based on the intelligence data warehouse was made from the view of a holistic conception, and a detailed arithmetic was presented by making use of the tactic from data mining driven fishbone.

Download Full-text

Marketing Decision and Decision Support System Design Based on Web

Advanced Materials Research ◽

10.4028/www.scientific.net/amr.850-851.1048 ◽

2013 ◽

Vol 850-851 ◽

pp. 1048-1051

Author(s):

Guang Yu Peng

Keyword(s):

Data Mining ◽

Decision Making ◽

Decision Support ◽

Decision Support System ◽

Data Warehouse ◽

Support System ◽

Logical Structure ◽

The Internet ◽

Marketing Decision ◽

Online Analysis Processing

This paper analyzes the DSS characteristics about the marketing under the internet as well as the influencing factors of the market decisions, Studying the decision-making functions of marketing decision support system DSS. It proposed the marketing DSS design, logical structure and its implementation based on a data warehouse as the center, online analysis processing and data mining as a means.

Download Full-text

Data warehousing and data mining: A case study

Yugoslav journal of operations research ◽

10.2298/yjor0501125s ◽

2005 ◽

Vol 15 (1) ◽

pp. 125-145 ◽

Cited By ~ 1

Author(s):

Milija Suknovic ◽

Milutin Cupic ◽

Milan Martic ◽

Darko Krulj

Keyword(s):

Data Mining ◽

Decision Making ◽

Data Warehouse ◽

Business Decision ◽

Serbia And Montenegro ◽

Data Mining Algorithms ◽

Use Of Data ◽

Business System ◽

Time Period ◽

Mining Algorithms

This paper shows design and implementation of data warehouse as well as the use of data mining algorithms for the purpose of knowledge discovery as the basic resource of adequate business decision making process. The project is realized for the needs of Student's Service Department of the Faculty of Organizational Sciences (FOS), University of Belgrade, Serbia and Montenegro. This system represents a good base for analysis and predictions in the following time period for the purpose of quality business decision-making by top management. Thus, the first part of the paper shows the steps in designing and development of data warehouse of the mentioned business system. The second part of the paper shows the implementation of data mining algorithms for the purpose of deducting rules, patterns and knowledge as a resource for support in the process of decision making.

Download Full-text

Data Warehouse, Data Mining Dan Konsep Cross-Selling Pada Analisis Penjualan Produk

ComTech Computer Mathematics and Engineering Applications ◽

10.21512/comtech.v1i2.2368 ◽

2010 ◽

Vol 1 (2) ◽

pp. 344

Author(s):

Eka Miranda ◽

Natalya Elfreida

Keyword(s):

Data Mining ◽

Decision Making ◽

Data Warehouse ◽

Ad Hoc ◽

Data Warehousing ◽

Problem Analysis ◽

Literature Study ◽

Product Analysis ◽

Huge Amount ◽

Design And Testing

This paper is about designing and implementing data warehousing and data mining, along with their roles in supporting decision-making related to sales product analysis in cross-selling concept of PT XYZ. The database the company used is not supporting data analysis and decision-making. Therefore, it made a data warehousing design that could be used to keep data in a huge amount and could give report and answer from user’s questions in ad hoc. The method is used to design and implement data warehousing and data mining which consists of literature study, company problem analysis, and data warehousing design, and testing result. The writing results are a data warehousing design and data mining and also the implementation of cross-selling concept to analysis the sales, purchases, and customers’ cancellation data. The data could be showed and analyzed from some point of views that could help managers to analyse and acknowledge more information.

Download Full-text

The Research of Intelligence Data Mining Oriented to Battlefield Situation Assessment

Applied Mechanics and Materials ◽

10.4028/www.scientific.net/amm.380-384.1282 ◽

2013 ◽

Vol 380-384 ◽

pp. 1282-1285

Author(s):

Jing Xue Liu ◽

Wei Tang

Keyword(s):

Data Mining ◽

Decision Making ◽

Data Warehouse ◽

Data Warehouses ◽

Situation Assessment ◽

Basic Construction ◽

Holistic Conception

Battlefield situation assessment (BSA) has a positive significance on improving the efficiency of commanding decision-making, moreover, BSA cannot be made successfully without the support of some integrated and exact intelligence data. In this paper, basing on the demand of identifying the battlefield situation, the corresponding knowledge context database is first discussed; on this basic, construction of the intelligence data warehouses framework is explored. Then, from the view of a holistic conception, the study of data mining based on the intelligence data warehouse is made, and a detailed arithmetic is presented by making use of the tactic from data mining driven fishbone (DMDF).

Download Full-text