scholarly journals PENGEMBANGAN DATA WAREHOUSE CALL CENTER DENGAN METODOLOGI KIMBALL NINE-STEP PADA BINA SARANA INFORMATIKA

2016 ◽  
Vol 2 (2) ◽  
Author(s):  
ADJAT SUDRADJAT

ABSTRACT - As an educational institution, Bina Sarana Informatika of course requires summary of information which is comprehensive and sustainable as a support to management in doing evaluation, planning and decision-making in the field of academic services. But the information system from operational data processing today can’t meet the needs, because it’s only able to produce detailed reports periodically. The research studies the development of a data warehouse for Call Center on The Division of Public Information of Bina Sarana Informatika in order to explore the strategic information contained in the operational database and present them in the form of summary information which is useful as input in improving the quality of academic services. By using a nine steps kimball approach, the research produce a data warehouse which is equipped with a web-based presentation application that can be easily accessed by all stakeholders of Bina Sarana Informatika. The development of data warehouse has been able to extract operational data into strategic information summaries that are useful to Bina Sarana Informatika management as supporting in doing evaluation, planning and decision-making in the field of academic services. Keywords : Nine Steps Kimball, Call Center, Data Warehouse, Decision Support. ABSTRAKSI - Sebagai sebuah institusi pendidikan, Bina Sarana Informatika tentu membutuhkan ringkasan informasi yang komprehensif dan berkesinambungan sebagai penunjang bagi manajemen dalam melakukan evaluasi, perencanaan dan pengambilan keputusan di bidang pelayanan akademik. Namun sistem informasi yang berasal dari pengolahan data operasional saat ini tidak dapat memenuhi kebutuhan tersebut, karena hanya mampu menghasilkan laporan–laporan yang bersifat detail dan periodik. Penelitian ini mengkaji pengembangan data warehouse Call Center pada Divisi Informasi Publik Bina Sarana Informatika untuk menggali informasi strategis yang terdapat pada database operasional dan menyajikannya dalam bentuk ringkasan informasi yang berguna sebagai masukan dalam usaha peningkatan kualitas pelayanan akademik. Dengan menggunakan metodologi kimball nine-step, penelitian menghasilkan sebuah data warehouse dilengkapi dengan aplikasi presentasi berbasis web yang dapat diakses dengan mudah oleh seluruh stakeholder Bina Sarana Informatika. Pengembangan data warehouse telah mampu mengekstrak data operasional menjadi ringkasan informasi strategis yang berguna bagi manajemen Bina Sarana Informatika sebagai penunjang dalam melakukan evaluasi, perencanaan dan pengambilan keputusan di bidang pelayanan akademik. Kata Kunci : Nine Steps Kimball, Call Center, Data Warehouse, Decision Support.

Author(s):  
Hadrian Peter ◽  
Charles Greenidge

Good database design generates effective operational databases through which we can track customers, sales, inventories, and other variables of interest. The main reason for generating, storing, and managing good data is to enhance the decision-making process. The tool used during this process is the decision support system (DSS). The information requirements of the DSS have become so complex, that it is difficult for it to extract all the necessary information from the data structures typically found in operational databases. For this reason, a new storage facility called a data warehouse has been developed. Data in the data warehouse have characteristics that are quite distinct from those in the operational database (Rob & Coronel, 2002).


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.


Author(s):  
Miguel Fabrício Zamberlan ◽  
Carolina Yukari Veludo Watanabe

The use of technology to assist in the performance of daily activities and to carry out communication between individuals has become a necessary task in the face of technological advances. In the context of public institutions, the insertion of technology is also based on the possibilities of making the activities of this sector more efficient and better quality, in addition to allowing greater transparency and accessibility of information for society. For public managers, the information and communication technology tools allow for a more accurate assessment of the variables and possibilities involved in a decision-making process and, thus, to make better decisions in a sector whose main customer is society (users). Therefore, this paper aimed to analyze the use and acceptance of a decision support tool in a public educational institution called the Indicators Panel. For this, the Unified Theory of Acceptance and Use of Technology (UTAUT) was used, and the results were measured using the paraconsistent logic. The results indicate that it is possible to consider the use and acceptance of the decision support system in the public educational institution by reducing the propositions of the UTAUT Model in three factors: Usability, Performance, and Relationship. Regarding the UTAUT Model, it was found that the moderating variables of gender, age, and experience do not significantly influence the adoption of the decision support system. It is important to note that managers point the tool as very important for the development of their activities and emphasize that ease of use is one of the main points for the adoption of technology.


2012 ◽  
pp. 808-822
Author(s):  
Ori Gudes ◽  
Elizabeth Kendall ◽  
Tan Yigitcanlar ◽  
Jung Hoon Han ◽  
Virendra Pathak

This chapter investigates the challenges and opportunities associated with planning for a competitive city. The chapter is based on the assumption that a healthy city is a fundamental prerequisite for a competitive city. Thus, it is critical to examine the local determinants of health and factor these into any planning efforts. The main focus of the chapter is on e-health planning by utilising Web-based geographic decision support systems. The proposed novel decision support system would provide a powerful and effective platform for stakeholders to access essential data for decision-making purposes. The chapter also highlights the need for a comprehensive information framework to guide the process of planning for healthy cities. Additionally, it discusses the prospects and constraints of such an approach. In summary, this chapter outlines the potential insights of using an information science-based framework and suggests practical planning methods as part of a broader e-health approach for improving the health characteristics of competitive cities.


Author(s):  
Kheri Arionadi Shobirin ◽  
Adi Panca Saputra Iskandar ◽  
Ida Bagus Alit Swamardika

A data warehouse are central repositories of integrated data from one or more disparate sources from operational data in On-Line Transaction Processing (OLTP) system to use in decision making strategy and business intelligent using On-Line Analytical Processing (OLAP) techniques. Data warehouses support OLAP applications by storing and maintaining data in multidimensional format. Multidimensional data models as an integral part of OLAP designed to solve complex query analysis in real time.


2021 ◽  
Author(s):  
Danielle Shojaie ◽  
Aubri S Hoffman ◽  
Ruth Amaku ◽  
Maria E Cabanillas ◽  
Julie Ann Sosa ◽  
...  

BACKGROUND In cancers with a chronic phase, patients and family caregivers may face difficult decisions such as whether to start a novel therapy, whether to enroll in a clinical trial, and when to stop treatment. These decisions are complex, require an understanding of uncertainty, and necessitate consideration of patients’ informed preferences. For some cancers, such as medullary thyroid carcinoma, these decisions may also involve significant out-of-pocket costs and effects on family members. Providers expressed a need for web-based interventions that can be delivered between consultations to provide education and prepare patients and families for discussing these decisions. To ensure these tools are effective, usable, and understandable, studies are needed to identify patients’, families’, and providers’ primary decision-making needs and optimal design strategies for a web-based patient decision aid. OBJECTIVE Following international guidelines for development of a web-based patient decision aid, the objectives of this study were to: 1) engage potential users to guide development; 2) review the existing literature and available tools; 3) assess users’ decision-making experiences, needs, and design recommendations; and 4) identify shared decision-making approaches to address each need. METHODS This study used the Decisional Needs Assessment approach, including creating a Stakeholder Advisory Panel, mapping decision pathways, conducting an environmental scan of existing materials, and administering a decisional needs assessment questionnaire. Thematic analyses identified the current decision-making pathways, unmet decision-making needs, and decision support strategies to meet each need. RESULTS Stakeholders reported wide heterogeneity in decision timing and pathways. Relevant existing materials included two systematic reviews, 9 additional papers, and multiple educational websites, but nothing that met the criteria of a patient decision aid. Patients and family members emphasized needing plain language (46 of 54, 85%), shared decision making (45 of 54, 83%), and help with family discussions (39 of 54, 72%). Additional needs included information about uncertainty, lived experience, and costs. Providers (n = 10) reported needing interventions that address misinformation (9 of 10, 90%), foster realistic expectations (9 of 10, 90%), and address mistrust in clinical trials (5 of 10, 50%). Additional needs included provider tools to support shared decision making. Both groups recommended designing a web-based patient decision aid that can be tailored (64 of 64, 100%) and delivered on a hospital website (53 of 64, 83%), and that focuses on quality of life (45 of 64, 70%) and provides step-by-step guidance (43 of 64, 67%). The study team identified best practices to meet each need, which are presented in the proposed Decision Support Design Guide. CONCLUSIONS Patients, families, and providers report multifaceted decision support needs during the chronic phase of cancer. Web-based patient decision aids are needed that provide tailored support over time, and explicitly address uncertainty, quality of life, realistic expectations, and effects on families.


2014 ◽  
Vol 8 (3) ◽  
pp. 1364-1371
Author(s):  
Mohammed A. I. Ayoub

Web-based decision support systems are increasingly used over the past years. However, few studies have been conducted on evaluation of web-based decision support systems especially in the field of online shopping. This paper attempts to explore the critical success factors that influence decision making satisfaction in online shopping context by providing a conceptual model for this purpose. Although there are various factors which contribute in making online shopping decisions but this study focuses on five factors i.e. web site quality, data quality, knowledge management, decision making satisfaction, and perceived net benefit. Also, this research will use existing models that explain and predict information systems success. However, these success models need to be updated to recurrent industry developments since the updating existing IS success models, a better understanding of web-based DSS practitioner success can be achieved.


2011 ◽  
Vol 383-390 ◽  
pp. 4653-4659
Author(s):  
Amro F. Alasta ◽  
Muftah A. Enaba

Since the use of computers in business world, data collection has become one of the most important issues due to the available knowledge in the data; such data has been stored in database. Database system was developed which led to the evolvement of hierarchical and relational database followed by Standard Query Language (SQL). As data size increases, the need for more control and information retrieval increase. These increases lead to the development of data mining systems and data warehouses. This paper focuses on the use of data warehouse as a supporting tool in decision making. We to study the effectiveness of data warehouse techniques in the sense of time and flexibility in our case study (Manpower Employment). The study will conclude with a comparison of traditional relational database and the use of data warehouse. The fundamental role of data warehouse is to provide data for supporting decision-making process. Data in data warehouse environment is multidimensional data store. We can simply say that data warehouse is a process not a product, for assembling and managing data from various sources for the purpose of gaining a single detailed view of part or all an establishment. The data warehouse concept has changed the nature of decision support system, by adding new benefits for improving and expanding the scope, accuracy, and accessibility of data. The warehouse is the link between the application and raw data, which is scattered in separate database but now is unified. The objectives of this work are to study the impact of using data warehouse on Manpower Employment Decision Support System, in the sense as far as the data quality concern. We will focus on the benefits gained from using data warehouse, and why it is more powerful than the use of traditional databases in decision making. The case study will be the Libyan national manpower employment agency. The data warehouse will collect database scattered from different sources in Libya in order to compare the performance and time.


2008 ◽  
pp. 2749-2761
Author(s):  
Hugh J. Watson ◽  
Barbara H. Wixom ◽  
Dale L. Goodhue

Data warehouses are helping resolve a major problem that has plagued decision support applications over the years — a lack of good data. Top management at 3M realized that the company had to move from being product-centric to being customer savvy. In response, 3M built a terabyte data warehouse (global enterprise data warehouse) that provides thousands of 3M employees with real-time access to accurate, global, detailed information. The data warehouse underlies new Web-based customer services that are dynamically generated based on warehouse information. There are useful lessons that were learned at 3M during their years of developing the data warehouse.


Author(s):  
Iftikhar U. Sikder ◽  
Aryya Gangopadhyay

There are numerous technical and organizational challenges in the design and implementation of spatial decision support systems. Part of the problem stems from the distributed and uncoordinated land management practices of individual decision-makers. For example, in environmental planning, multiple decision makers with conflicting goals may need to make collective decisions. This requires collaborative decision-making tools and conflict resolution capabilities. In this chapter, we identify the research issues related to the design and implementation of Web- based collaborative spatial decision-making support systems in the context of distributed environmental planning. We implemented a Web-based Spatial Decision Support System called GEO-ELCA (Exploratory Land Use Change Assessment) for typical decision-making tasks by urban or municipal planning agencies where resource managers or stakeholders of different interest groups can express their options for future land use changes and assess the resulting hydrological impacts in a collaborative environment.


Sign in / Sign up

Export Citation Format

Share Document