Missing Data in OLAP Cubes

2021 ◽  
Vol 32 (3) ◽  
pp. 1-28
Author(s):  
Monica Chiarini Tremblay ◽  
Alan R. Hevner
Keyword(s):  
Missing Data ◽  
Decision Makers ◽  
Controlled Experiments ◽  
Aggregated Data ◽  
Decision Context ◽  
Decision Confidence ◽  
Tolerance For Ambiguity ◽  
Analytical Processing ◽  
Omission Bias

Online analytical processing (OLAP) engines display aggregated data to help business analysts compare data, observe trends, and make decisions. Issues of data quality and, in particular, issues with missing data impact the quality of the information. Key decision-makers who rely on these data typically make decisions based on what they assume to be all the available data. The authors investigate three approaches to dealing with missing data: 1) ignore missing data, 2) show missing data explicitly (e.g., as unknown data values), and 3) design mitigation algorithms for missing data (e.g., allocate missing data into known value categories). The authors evaluate the approach with focus groups and controlled experiments. When one tries to inform decision-makers using the approaches in the research, the authors find that they often alter their decisions and adjust their decision confidence: individual differences of tolerance for ambiguity and pre-existing omission bias in the decision context influence their decisions.

scholarly journals Meaningful, but effective? A critical evaluation of Ireland’s citizens’ dialogues on the future of Europe

Politics ◽  
2021 ◽  
pp. 026339572199148
Author(s):  
Anthony Costello
Keyword(s):  
European Union ◽  
Public Relations ◽  
Public Discourse ◽  
Critical Evaluation ◽  
Participatory Approach ◽  
Decision Makers ◽  
Deliberative Process ◽  
Political Will ◽  
The Future

On the 25 March 2017, leaders of the EU27 and European Union (EU) institutions ratified the Rome Declaration. They committed to invite citizens to discuss Europe’s future and to provide recommendations that would facilitate their decision-makers in shaping their national positions on Europe. In response, citizens’ dialogues on the future of Europe were instituted across the Union to facilitate public participation in shaping Europe. This paper explores Ireland’s set of dialogues which took place during 2018. Although event organisers in Ireland applied a relatively atypical and more systematic and participatory approach to their dialogues, evidence suggests that Irelands’ dialogues were reminiscent of a public relations exercise which showcased the country’s commitment to incorporating citizens into the debate on Europe while avoiding a deliberative design which could have strengthened the quality of public discourse and the quality of public recommendations. Due to an absence of elite political will for a deliberative process, as well as structural weaknesses in design, participants’ recommendations lacked any clear and prescriptive direction which could shape Ireland’s national position on the future of Europe in any constructive or meaningful way.

Quality of learning experience, student satisfaction and perceived overall experience in the COVID-19 context

2021 ◽  
Vol ahead-of-print (ahead-of-print) ◽  
Author(s):  
Venugopal Prabhakar Gantasala ◽  
Swapna Bhargavi Gantasala ◽  
Tareq Na'el Al Tawil ◽  
Prerana Prasad
Keyword(s):  
Higher Education ◽  
Student Satisfaction ◽  
Online Courses ◽  
Learning Experience ◽  
Decision Makers ◽  
Undergraduate Level ◽  
Content Type ◽  
The Relationship ◽  
Medical Programs

PurposeThe intention for this study was to explore any relationship that might exist between quality of learning experience (QLE), the second construct student satisfaction (SS) and the third construct perceived overall experience (POE) among undergraduate students within the higher education context. This study also attempts to explain the path direction between QLE, SS and POE.Design/methodology/approachThe researchers utilized structural equation modeling to analyze the variables considered for this study – QLE, SS and POE and for hypotheses testing. Respondents for this study were medical students' coordinators of the undergraduate level of medical colleges in the 28 states of India. Data collected for the study were possible by utilizing a questionnaire that was emailed to these student coordinators. The emailing effort returned 198 (n) filled questionnaires (complete) representing 198 institutions offering undergraduate-level medical programs out of a total of 542 institutions that offer undergraduate medical programs.FindingsFindings from this study confirm the relationship between QLE with SS, and PLE. Interestingly, the findings established a significant relationship between SS and POE.Practical implicationsDecision-makers and administrators of higher education institutions (HEIs) can utilize the findings from this study to focus on strengthening important elements of QLE in ways that positively impact SS and POE of students taking online courses and program offerings. The study reiterates the importance of course content, course structure, lecture-delivery quality, instructor mentoring and student-instructor interactions on SS and POE. The role of SS in reinforcing confirmation, perceived usefulness, perceived openness of the online courses and the perceived reputation was established. This relationship is key to administrators while they focus on improving SS and building on the institutions' reputation in addition to their efforts to support marketing and enrollments during the pandemic.Originality/valueResearchers in the past have examined the relationships between QLE and another construct of this study – SS. Past research has also examined the relationship between QLE and POE. However, there is not enough research exploring the relationship between SS and POE. This study establishes the relationship between SS and POE that benefits decision-makers in higher education.

Socio-Technical Modeling to Manage Power Distribution for Microgrid Systems with Limited Production Capacity

2021 ◽  
pp. 1-38
Author(s):  
Hailie Suk ◽  
Ayushi Sharma ◽  
Anand Balu Nellippallil ◽  
Ashok Das ◽  
John Hall
Keyword(s):  
Rural Communities ◽  
Power Distribution ◽  
Production Capacity ◽  
Solution Space ◽  
Decision Makers ◽  
Safety Education ◽  
Water Safety ◽  
Water Safety Education ◽  
Water Pumps

Abstract The quality of life (QOL) in rural communities is improved through electrification. Microgrids can provide electricity in areas where grid access to electricity is infeasible. Still, insufficient power capacity hinders the very progress that microgrids promote. Therefore, we propose a decision-making framework to manage power distribution based on its impact on the rural QOL. Parameters are examined in this paper to represent the QOL pertaining to water, safety, education, and leisure/social activities. Each parameter is evaluated based on condition, community importance, and energy dependence. A solution for power allocation is developed by executing the compromise decision support problem (cDSP) and exploring the solution space. Energy loads, such as those required for powering water pumps, streetlamps, and household devices are prioritized in the context of the QOL. The technique also allows decision-makers to update the power distribution scheme as the dynamics between energy production and demand change over time. In this paper, we propose a framework for connecting QOL and power management. The flexibility of the approach is demonstrated using a problem with varying scenarios that may be time-dependent. The work enables sustainable energy solutions that can evolve with community development.

Heuristics as a new way of adjusting the end market value

2021 ◽  
Vol 27 (7) ◽  
pp. 1581-1599
Author(s):  
Semen Yu. BOGATYREV
Keyword(s):  
Behavioral Finance ◽  
Market Value ◽  
Measurement Methods ◽  
Decision Makers ◽  
Emotional Impact ◽  
Psychological Measurement ◽  
Survey Results ◽  
Financial Decision ◽  
The Cost

Subject. The study deals with heuristics as measures of the emotional impact of people who judge about the value and the final result of the valuation. I review ranges of the value variance when influenced by irrational factors. From psychological perspectives, some phenomena are explained with a set of heuristics that exist as part of behavioral finance. Objectives. Referring to the completed studies, I implement elements of behavioral finance, such as heuristics into the method for assessing how financial decision-makers and their emotions influence the value. Methods. The article is based on methods of induction and deduction to process survey results. Results. The article reveals the content of key methods for measuring emotions of financial decision-maker, which conclude on the value, being influenced by heuristics. I demonstrate tools for implementing psychological measurement methods as part of valuation. Conclusions and Relevance. Considering heuristics of value decision-makers, the appraiser and the cost analyst approximate the valuation result to the real conditions, when market actors are irrational. Doing so, they contribute to the quality of the result of appraisal. The findings are applicable to the practice of appraisers, cost analysts, fundamental analysts. Heuristics enrich and expands the classical apparatus of valuation and increases its quality.

Post–Intensive Care Syndrome in Family Decision Makers of Long-term Acute Care Hospital Patients

2017 ◽  
Vol 26 (5) ◽  
pp. 416-422 ◽  
Author(s):  
Amy Petrinec
Keyword(s):  
Quality Of Life ◽  
Intensive Care ◽  
Acute Care ◽  
Acute Care Hospitals ◽  
Summary Score ◽  
Decision Makers ◽  
Family Decision ◽  
Post Intensive Care Syndrome

Background Family members of critically ill patients experience indications of post–intensive care syndrome, including anxiety, depression, and posttraumatic stress disorder. Despite increased use of long-term acute care hospitals for critically ill patients, little is known about the impact of long-term hospitalization on patients’ family members. Objectives To examine indications of post–intensive care syndrome, coping strategies, and health-related quality of life among family decision makers during and after patients’ long-term hospitalization. Methods A single-center, prospective, longitudinal descriptive study was undertaken of family decision makers of adult patients admitted to long-term acute care hospitals. Indications of post–intensive care syndrome and coping strategies were measured on the day of hospital admission and 30 and 60 days later. Health-related quality of life was measured by using the Short Form-36, version 2, at admission and 60 days later. Results The sample consisted of 30 family decision makers. On admission, 27% reported moderate to severe anxiety, and 20% reported moderate to severe depression. Among the decision makers, 10% met criteria for a provisional diagnosis of posttraumatic stress disorder. At admission, the mean physical summary score for quality of life was 47.8 (SD, 9.91) and the mean mental summary score was 48.00 (SD, 10.28). No significant changes occurred during the study period. Problem-focused coping was the most frequently used coping strategy at all time points. Conclusion Family decision makers of patients in long-term acute care hospitals have a significant prevalence of indications of post–intensive care syndrome.

scholarly journals Urinary incontinence as the socioeconomic problem

2017 ◽  
Vol 16 (3) ◽  
pp. 62-66
Author(s):  
Krystyna Klimaszewska ◽  
Mariola Bartusek
Keyword(s):  
Urinary Incontinence ◽  
Epidemiological Data ◽  
Decision Makers ◽  
Health Needs ◽  
Public Funds ◽  
The Social ◽  
The Status ◽  
Costs Of Treatment ◽  
Social Discomfort

Abstract Introduction. Urinary incontinence, meaning irrespective of will leakage of urine, is a serious health problem, and has the status of social disease basing on the epidemiological data concerning number of affected populations suffering from it Taking into consideration the chronic character of the disease and increasing social discomfort including social exclusion, the costs of treatment and rehabilitation should be lower so patients could improve the quality of their lives in other aspects. That is why it is important to deeply analyze the costs of urinary incontinence in terms of diagnostics, treatment and rehabilitation. Aim. Costs analysis related to diagnostics and treatment of urinary incontinence incurred by patient, or co-financed/funded by the National Health Fund on the basis of the literature review. Summary. The few but regularly prepared reports show that there is a clear need for changes in the funding of services provided to patients with health needs. Both the social and economic aspects are important for each patient and should be deeply analysed by public funds decision makers. It would be much easier to take an action if the probability of complete cure was high.

Estimating the effect of treatment on quality of life in the presence of missing data due to drop-out and death

1998 ◽  
Vol 7 (6) ◽  
pp. 487-494 ◽  
Author(s):  
J. M. Raboud ◽  
J. Singer ◽  
A. Thorne ◽  
M. T. Schechter ◽  
S. D. Shafran
Keyword(s):  
Quality Of Life ◽  
Missing Data ◽  
Drop Out ◽  
Effect Of Treatment

Attitudes of Iranian nurses toward caring for dying patients

2008 ◽  
Vol 6 (4) ◽  
pp. 363-369 ◽  
Author(s):  
Sedigheh Iranmanesh ◽  
Helen Dargahi ◽  
Abbas Abbaszadeh
Keyword(s):  
Emotional Support ◽  
Death And Dying ◽  
Negative Attitude ◽  
Decision Makers ◽  
Attitudes Toward Death ◽  
The People ◽  
Dying Patients ◽  
Personal Experiences ◽  
Reflective Narrative

ABSTRACTObjective:To examine the attitudes of Iranian nurses toward caring for dying patients.Methods:Nurses' attitudes toward death and caring for dying patients were examined by using two types of questionnaires: the Death Attitude Profile–Revised (DAP-R) and Frommelt's Attitude towards Caring for Dying Patients (FATCOD), both with a demographic survey.Results:The results showed that most respondents are likely to view death as a natural part of life and also as a gateway to the afterlife. The majority reported that they are likely to provide care and emotional support for the people who are dying and their families, but they were unlikely to talk with them or even educate them about death. They had a tendency not to accept patients and their families as the authoritative decision makers or involve families in patient care. Nurses' personal views on death, as well as personal experiences, affected their attitudes toward care of the dying.Significance of results:Lack of education and experience, as well as cultural and professional limitations, may have contributed to the negative attitude toward some aspects of the care for people who are dying among the nurses surveyed. Creating a reflective narrative environment in which nurses can express their own feelings about death and dying seems to be a potentially effective approach to identify the factors influencing their interaction with the dying. Continuing education may be required for Iranian palliative care nurses in order to improve the patients quality of care at the end of life.

A Systematic Planning Tool for Environmental Characterisation

2009 ◽  
Author(s):  
Steven Wilcox ◽  
Richard Wilkins ◽  
Martin Lyons
Keyword(s):  
Best Practice ◽  
Planning Process ◽  
Cost Effective ◽  
Decision Makers ◽  
Performance Criteria ◽  
Final Decision ◽  
Cost Effective Approach ◽  
Systematic Planning ◽  
Sample Plan

Many organisations are currently dealing with long standing legacy issues in clean up, decommissioning and demolition projects. Industry is required to ensure that all bulk articles, substances and waste arisings are adequately characterised and assigned to the correct disposal routes in compliance with UK legislation and best practice. It is essential that data used to support waste sentencing is of the correct type, quality and quantity, and that it is appropriately assessed in order to support defensible, confident decisions that account for inherent uncertainties. AMEC has adopted the Data Quality Objectives (DQO) based methodology and the software package Visual Sample Plan (VSP) to provide a better, faster, and more cost effective approach to meeting regulatory and client requirements, whilst minimising the time spent gathering data and assessing the information. The DQO methodology is based on a scientific approach that requires clear objectives to be established from the outset of a project and that there is a demonstration of acceptability of the results. Through systematic planning, the team develops acceptance or performance criteria for the quality of the data collected and for the confidence in the final decision. The systematic planning process promotes communication between all departments and individuals involved in the decision-making process thus the planning phase gives an open and unambiguous method to support the decisions and enables the decision-makers (technical authorities on the materials of concern) to document all assumptions. The DQO process allows better planning, control and understanding of all the issues. All types of waste can be sentenced under one controllable system providing a more defensible position. This paper will explain that the DQO process consists of seven main steps that lead to a detailed Sampling and Analysis Plan (SAP). The process gives transparency to any assumptions made about the site or material being characterised and identifies individuals involved. The associated calculation effort is reduced using the statistically based sampling models produced with VSP. The first part of this paper explains the DQO based methodology and Visual Sample Plan and the second part shows how the DQO process has been applied in practice.

scholarly journals Perancangan Data Warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP)

2021 ◽  
Vol 8 (5) ◽  
pp. 1077
Author(s):  
Joko Purwanto ◽  
Renny Renny
Keyword(s):  
Information Technology ◽  
Health Services ◽  
Data Warehouse ◽  
Data Extraction ◽  
Online Analytical Processing ◽  
Data Source ◽  
Analytical Processing ◽  
Quality Of Health Services ◽  
Warehouse Design

<p class="BodyCxSpFirst">Pemanfaatan teknologi informasi sangat penting bagi rumah sakit, karena berpengaruh pula terhadap kualitas pelayanan kesehatan yang secara manual diubah menjadi digital dengan menggunakan teknologi informasi.Dalam penelitian ini penulis menggunakan metodologi <em>Nine step</em> sebagai acuan dalam merancang suatu <em>data warehouse</em><em>,</em> untuk pemodelan menggunakan skema konstelasi fakta dengan 3 tabel fakta dan 11 tabel dimensi. Perbedaan penelitian ini dengan penelitian sebelumnya terletak pada sumber data yang diekstrak langsung dari <em>database</em> SIMRS yang digunakan rumah sakit, sehingga tidak ada ekstraksi data secara manual.Penelitian ini bertujuan untuk menghasilkan desain data warehouse berbasis Online Analytical Processing (OLAP) sebagai sarana penunjang kualitas pelayanan kesehatan rumah sakit. OLAP yang dihasilkan akan berupa desain data warehouse dengan berbagai dimensi yang akan menghasilkan tampilan informasi berupa Chart maupun Grafik sehingga informasinya mudah dibaca dan dipahami oleh berbagai pihak.</p><p class="BodyCxSpFirst"> </p><p class="BodyCxSpFirst"><em><strong>Abtract</strong></em></p><p class="BodyCxSpFirst"><em>The use of information technology is very important for hospitals, because it also affects the quality of health services, which manualy changed to digital using information technology. In this study, the authors used the Nine step methodology as a reference in designing a data warehouse for modeling using a fact constellation schema with 3 fact tables and 11 dimension tables. the different in this study from previous research is that the data source was taken directly from the SIMRS database used by the hospital, so there is no manual data extraction.</em><em>The aim of this research is to be able to produce a Data Warehouse design based on Online Analytical Processing (OLAP) as a means of supporting the quality of hospital health services. The resulting OLAP will be a data warehouse design with various dimensions will produce the displays information in the form of a graph or chart so that the information is easy to read and understand by various parties.</em></p><p class="BodyCxSpLast"><em> </em></p><p class="BodyCxSpFirst"><em><strong><br /></strong></em></p>

Sign in / Sign up

Export Citation Format

Share Document