Organizational Data Warehousing

Author(s):  
John Wang ◽  
Xiaohua Hu ◽  
Dan Zhu

A data warehouse (or smaller-scale data mart) is a specially prepared repository of data created to support decision making. Data are extracted from source systems, cleaned/scrubbed, transformed, and placed in data stores (Gorla, 2003). A data warehouse has data suppliers who are responsible for delivering data to the ultimate end users of the warehouse, such as analysts, operational personnel, and managers. The data suppliers make data available to end users either through structured query language (SQL) queries or custom-built decision-support applications, including decision support systems (DSS) and executive information systems (EIS).

Author(s):  
Soraya Rahma Hayati ◽  
Mesran Mesran ◽  
Taronisokhi Zebua ◽  
Heri Nurdiyanto ◽  
Khasanah Khasanah

The reception of journalists at the Waspada Daily Medan always went through several rigorous selections before being determined to be accepted as journalists at the Waspada Medan Daily. There are several criteria that must be possessed by each participant as a condition for becoming a journalist in the Daily Alert Medan. To get the best participants, the Waspada Medan Daily needed a decision support system. Decision Support Systems (SPK) are part of computer-based information systems (including knowledge-based systems (knowledge management)) that are used to support decision making within an organization or company. Decision support systems provide a semitructured decision, where no one knows exactly how the decision should be made. In this study the authors applied the VlseKriterijumska Optimizacija I Kompromisno Resenje (VIKOR) as the method to be applied in the decision support system application. The VIKOR method is part of the Multi-Attibut Decision Making (MADM) Concept, which requires normalization in its calculations. The expected results in this study can obtain maximum decisions.Keywords: Journalist Acceptance, Decision Support System, VIKOR


Author(s):  
Alysson Bolognesi Prado ◽  
Carmen Freitas ◽  
Thiago Ricardo Sbrici

In the growing challenge of managing people, Human Resources need effective artifacts to support decision making. On Line Analytical Processing is intended to make business information available for managers, and HR departments can now encompass this technology. This paper describes a project in which the authors built a Data Warehouse containing actual Human Resource data. This paper provides data models and shows their use through OLAP software and their presentation to end-users using a web portal. The authors also discuss the progress, and some obstacles of the project, from the IT staff’s viewpoint.


2017 ◽  
Vol 19 (1) ◽  
pp. 17-28 ◽  
Author(s):  
Siew-Phek T. Su ◽  
Ashwin Needamangala

Data warehousing technology has been defined by John Ladley as "a set of methods, techniques, and tools that are leveraged together and used to produce a vehicle that delivers data to end users on an integrated platform." (1) This concept h s been applied increasingly by industries worldwide to develop data warehouses for decision support and knowledge discovery. In the academic sector, several universities have developed data warehouses containing the universities' financial, payroll, personnel, budget, and student data. (2) These data warehouses across all industries and academia have met with varying degrees of success. Data warehousing technology and its related issues have been widely discussed and published. (3) Little has been done, however, on the application of this cutting edge technology in the library environment using library data.


2015 ◽  
Vol 4 (1) ◽  
pp. 45-66 ◽  
Author(s):  
Patrizia Lombardi ◽  
Valentina Ferretti

Purpose – Policy makers are frequently challenged by the need to achieve sustainable development in cities and regions. Current decision-making processes are based on evaluation support systems which are unable to tackle the problem as they cannot take a holistic approach or a full account of actors. The purpose of this paper is to present a new generation of evaluation systems to support decision making in planning and regeneration processes which involve expert participation. These systems ensure network representation of the issues involved and visualization of multiple scenarios. Design/methodology/approach – A literature review is used for both revising existing evaluation tools in urban planning and the built environment and highlighting the need to give stakeholders (industry, cities, operators, etc.) new tools for collaborative or individual decisions and to facilitate scaling up solutions. An overview of the new generation of decision support systems, named Multicriteria Spatial Decision Support Systems (MC-SDSS) is provided and real case studies are analyzed to show their ability to tackle the problem. Findings – Recent research findings highlight that decisions in urban planning should be supported by collaborative and inclusive processes. Otherwise, they will fail. The case studies illustrated in this study highlight the usefulness of MC-SDSS for the successful resolution of complex problems, thanks to the visualization facilities and a network representation of the scenarios. Research limitations/implications – The case studies are limited to the Italian context. Practical implications – These SDSS are able to empower planners and decision makers to better understand the interaction between city design, social preferences, economic issues and policy incentives. Therefore, they have been employed in several case studies related to territorial planning and regeneration processes. Originality/value – This study provides three case studies and a review of the new MC-SDSS methodology which involve the Analytic Network Process technique to support decision-making in urban and regional planning.


2008 ◽  
pp. 397-407
Author(s):  
Alexander Anisimov

This chapter is dedicated to the major managerial, organizational and technological aspects of development of data warehouses in a global information environment, when different external sources of information are available and potentially may have value for decision support and managerial analysis. It summarizes the major benefits that become available for businesses if they decide to integrate information from external sources into their data warehouses. It also introduces the overall organizational framework of development of data warehouses that are based upon the information from different external sources. Furthermore the author hopes that understanding of the framework introduced will not only inform practitioners (both information technology (IT) specialists and managers in different spheres of business) of new possible approaches to design of decision support systems but also assist in the improvement of approaches to decision-making procedures.


Author(s):  
John D. Wells ◽  
Traci J. Hess

Many businesses have made or are making significant investments in data warehouses that reportedly support a myriad of decision support systems (DSS). Due to the newness of data warehousing and related DSS (DW-DSS), the nature of the decision support provided to DW-DSS users and the related impact on decision performance have not been investigated in an applied setting. An explanatory case study was undertaken at a financial services organization that implemented a particular type of DW-DSS, a Customer Relationship Management (CRM) system. The DSS-decision performance model has provided some theoretical guidance for this exploration. The case study results show that the decision-making support provided by these systems is limited and that an extended version of the DSS-decision performance model may better describe the factors that influence individual decision-making performance.


Author(s):  
Guisseppi Forgionne ◽  
Manuel Mora ◽  
Jatinder N.D. Gupta ◽  
Ovsei Gelman

Decision-making support systems (DMSS) are specialized computer-based information systems designed to support some, several or all phases of the decision-making process (Forgionne et al., 2000). They have the stand-alone or integrated capabilities of decision support systems (DSS), executive information systems (EIS) and expert systems/knowledge based systems (ES/KBS). Individual EIS, DSS, and ES/KBS, or pair-integrated combinations of these systems, have yielded substantial benefits for decision makers in real applications.


2021 ◽  
Vol 937 (4) ◽  
pp. 042079
Author(s):  
B M Pilecki ◽  
A V Vicentiy

Abstract The problem of monitoring and management of industrial and natural complexes in the Arctic is an important problem, without solving which the effective development of the Arctic zones of the Russian Federation is impossible. Specialized information systems are actively used to support decision-making on planning and managing various types of activities in the Arctic, as well as the socio-economic development of the Arctic territories of the Russian Federation. Spatial information visualization tools are an important part of such systems. Visual representation of data is one of the most convenient types of information representation for human processing. This paper describes a method of automated geoimage generation for decision support systems based on the analysis of natural language texts. The use of such geoimages reduces the complexity of decision making for the management tasks of spatially distributed bio-socio-economic systems of the region. The paper describes the formulation of the research problem, review of geocoding tools and services, the original technology of automated geoimages (digital maps) generation based on the use of cloud geoservices. Particular attention is paid to the problem of recognition of named entities in natural language text. The recognition results are used as input data for geocoding and geovisualization process. As a result of the method, the text is converted into a geoimage (map) which can be used to support decision-making by a decision maker. In the final part of the paper, plans for further work are described to develop the capabilities of the automated geoimage generation method for decision support systems based on the analysis of natural language texts.


2008 ◽  
pp. 18-25
Author(s):  
James E. Yao ◽  
Chang Liu ◽  
Qiyang Chen ◽  
June Lu

As internal and external demands on information from managers are increasing rapidly, especially the information that is processed to serve managers’ specific needs, regular databases and decision support systems (DSS) cannot provide the information needed. Data warehouses came into existence to meet these needs, consolidating and integrating information from many internal and external sources and arranging it in a meaningful format for making accurate business decisions (Martin, 1997). In the past five years, there has been a significant growth in data warehousing (Hoffer, Prescott, & McFadden, 2005). Correspondingly, this occurrence has brought up the issue of data warehouse administration and management. Data warehousing has been increasingly recognized as an effective tool for organizations to transform data into useful information for strategic decision-making. To achieve competitive advantages via data warehousing, data warehouse management is crucial (Ma, Chou, & Yen, 2000).


Sign in / Sign up

Export Citation Format

Share Document