Explanatory Business Analytics in OLAP

2013 ◽  
Vol 4 (3) ◽  
pp. 67-82 ◽  
Author(s):  
Emiel Caron ◽  
Hennie Daniels

In this paper the authors describe a method to integrate explanatory business analytics in OLAP information systems. This method supports the discovery of exceptional values in OLAP data and the explanation of such values by giving their underlying causes. OLAP applications offer a support tool for business analysts and accountants in analyzing financial data because of the availability of different views and managerial reporting facilities. The purpose of the methods and algorithms presented here, is to extend OLAP applications with more powerful analysis and reporting functions. The authors describe how exceptional values at any level in the data, can be automatically detected by statistical models. Secondly, a generic model for diagnosis of atypical values is realized in the OLAP context. By applying it, a full explanation tree of causes at successive levels can be generated. If the tree is too large, the analyst can use appropriate filtering measures to prune the tree to a manageable size. This methodology has a wide range of applications such as interfirm comparison, analysis of sales data and the analysis of any other data that possess a multi-dimensional hierarchical structure. The method is demonstrated in a case study on financial data.

2013 ◽  
Vol 16 (1) ◽  
pp. 59-67

<p>The Soil Science Institute of Thessaloniki produces new digitized Soil Maps that provide a useful electronic database for the spatial representation of the soil variation within a region, based on in situ soil sampling, laboratory analyses, GIS techniques and plant nutrition mathematical models, coupled with the local land cadastre. The novelty of these studies is that local agronomists have immediate access to a wide range of soil information by clicking on a field parcel shown in this digital interface and, therefore, can suggest an appropriate treatment (e.g. liming, manure incorporation, desalination, application of proper type and quantity of fertilizer) depending on the field conditions and cultivated crops. A specific case study is presented in the current work with regards to the construction of the digitized Soil Map of the regional unit of Kastoria. The potential of this map can easily be realized by the fact that the mapping of the physicochemical properties of the soils in this region provided delineation zones for differential fertilization management. An experiment was also conducted using remote sensing techniques for the enhancement of the fertilization advisory software database, which is a component of the digitized map, and the optimization of nitrogen management in agricultural areas.</p>


Oxford Studies in Ancient Philosophy provides, twice each year, a collection of the best current work in the field of ancient philosophy. Each volume features original essays that contribute to an understanding of a wide range of themes and problems in all periods of ancient Greek and Roman philosophy, from the beginnings to the threshold of the Middle Ages. From its first volume in 1983, OSAP has been a highly influential venue for work in the field, and has often featured essays of substantial length as well as critical essays on books of distinctive importance. Volume LV contains: a methodological examination on how the evidence for Presocratic thought is shaped through its reception by later thinkers, using discussions of a world soul as a case study; an article on Plato’s conception of flux and the way in which sensible particulars maintain a kind of continuity while undergoing constant change; a discussion of J. L. Austin’s unpublished lecture notes on Aristotle’s Nicomachean Ethics and his treatment of loss of control (akrasia); an article on the Stoics’ theory of time and in particular Chrysippus’ conception of the present and of events; and two articles on Plotinus, one that identifies a distinct argument to show that there is a single, ultimate metaphysical principle; and a review essay discussing E. K. Emilsson’s recent book, Plotinus.


Energies ◽  
2021 ◽  
Vol 14 (5) ◽  
pp. 1377
Author(s):  
Musaab I. Magzoub ◽  
Raj Kiran ◽  
Saeed Salehi ◽  
Ibnelwaleed A. Hussein ◽  
Mustafa S. Nasser

The traditional way to mitigate loss circulation in drilling operations is to use preventative and curative materials. However, it is difficult to quantify the amount of materials from every possible combination to produce customized rheological properties. In this study, machine learning (ML) is used to develop a framework to identify material composition for loss circulation applications based on the desired rheological characteristics. The relation between the rheological properties and the mud components for polyacrylamide/polyethyleneimine (PAM/PEI)-based mud is assessed experimentally. Four different ML algorithms were implemented to model the rheological data for various mud components at different concentrations and testing conditions. These four algorithms include (a) k-Nearest Neighbor, (b) Random Forest, (c) Gradient Boosting, and (d) AdaBoosting. The Gradient Boosting model showed the highest accuracy (91 and 74% for plastic and apparent viscosity, respectively), which can be further used for hydraulic calculations. Overall, the experimental study presented in this paper, together with the proposed ML-based framework, adds valuable information to the design of PAM/PEI-based mud. The ML models allowed a wide range of rheology assessments for various drilling fluid formulations with a mean accuracy of up to 91%. The case study has shown that with the appropriate combination of materials, reasonable rheological properties could be achieved to prevent loss circulation by managing the equivalent circulating density (ECD).


2021 ◽  
Vol 11 (5) ◽  
pp. 2153
Author(s):  
Nadia Giuffrida ◽  
Maja Stojaković ◽  
Elen Twrdy ◽  
Matteo Ignaccolo

Container terminals are the main hubs of the global supply chain but, conversely, they play an important role in energy consumption, environmental pollution and even climate change due to carbon emissions. Assessing the environmental impact of this type of port terminal and choosing appropriate mitigation measures is essential to pursue the goals related to a clean environment and ensuring a good quality of life of the inhabitants of port cities. In this paper the authors present a Terminal Decision Support Tool (TDST) for the development of a container terminal that considers both operation efficiency and environmental impacts. The TDST provides environmental impact mitigation measures based on different levels of evolution of the port’s container traffic. An application of the TDST is conducted on the Port of Augusta (Italy), a port that is planning infrastructural interventions in coming years in order to gain a new role as a reference point for container traffic in the Mediterranean.


2019 ◽  
Vol 11 (6) ◽  
pp. 1681 ◽  
Author(s):  
Robert Šakić Trogrlić ◽  
Grant Wright ◽  
Melanie Duncan ◽  
Marc van den Homberg ◽  
Adebayo Adeloye ◽  
...  

People possess a creative set of strategies based on their local knowledge (LK) that allow them to stay in flood-prone areas. Stakeholders involved with local level flood risk management (FRM) often overlook and underutilise this LK. There is thus an increasing need for its identification, documentation and assessment. Based on qualitative research, this paper critically explores the notion of LK in Malawi. Data was collected through 15 focus group discussions, 36 interviews and field observation, and analysed using thematic analysis. Findings indicate that local communities have a complex knowledge system that cuts across different stages of the FRM cycle and forms a component of community resilience. LK is not homogenous within a community, and is highly dependent on the social and political contexts. Access to LK is not equally available to everyone, conditioned by the access to resources and underlying causes of vulnerability that are outside communities’ influence. There are also limits to LK; it is impacted by exogenous processes (e.g., environmental degradation, climate change) that are changing the nature of flooding at local levels, rendering LK, which is based on historical observations, less relevant. It is dynamic and informally triangulated with scientific knowledge brought about by development partners. This paper offers valuable insights for FRM stakeholders as to how to consider LK in their approaches.


Author(s):  
Laura Ballerini ◽  
Sylvia I. Bergh

AbstractOfficial data are not sufficient for monitoring the United Nations Sustainable Development Goals (SDGs): they do not reach remote locations or marginalized populations and can be manipulated by governments. Citizen science data (CSD), defined as data that citizens voluntarily gather by employing a wide range of technologies and methodologies, could help to tackle these problems and ultimately improve SDG monitoring. However, the link between CSD and the SDGs is still understudied. This article aims to develop an empirical understanding of the CSD-SDG link by focusing on the perspective of projects which employ CSD. Specifically, the article presents primary and secondary qualitative data collected on 30 of these projects and an explorative comparative case study analysis. It finds that projects which use CSD recognize that the SDGs can provide a valuable framework and legitimacy, as well as attract funding, visibility, and partnerships. But, at the same time, the article reveals that these projects also encounter several barriers with respect to the SDGs: a widespread lack of knowledge of the goals, combined with frustration and political resistance towards the UN, may deter these projects from contributing their data to the SDG monitoring apparatus.


2008 ◽  
Vol 65 (2) ◽  
pp. 267-275 ◽  
Author(s):  
Tom L. Catchpole ◽  
Andrew S. Revill ◽  
James Innes ◽  
Sean Pascoe

Abstract Catchpole, T. L., Revill, A. S., Innes, J., and Pascoe, S. 2008. Evaluating the efficacy of technical measures: a case study of selection device legislation in the UK Crangon crangon (brown shrimp) fishery. – ICES Journal of Marine Science, 65: 267–275. Bycatch reduction devices are being introduced into a wide range of fisheries, with shrimp and prawn fisheries particularly targeted owing to the heavy discarding common in these fisheries. Although studies are often undertaken to estimate the impact of a technical measure on the fishery before implementation, rarely have the impacts been assessed ex post. Here, the efficacy of the UK legislation pertaining to the use of sievenets in the North Sea Crangon crangon fishery is assessed. Three impacts were evaluated: on fisher behaviour (social), on the level of bycatch (biological), and on vessel profitability (economic). An apparent high level of compliance by skippers was identified despite a low level of enforcement. The estimated reduction in fleet productivity following the introduction of the legislation was 14%, equalling the mean loss of Crangon landings when using sievenets calculated from catch comparison trawls. Sievenets did reduce the unnecessary capture of unwanted marine organisms, but were least effective at reducing 0-group plaice, which make up the largest component of the bycatch. Clearly the legislation has had an effect in the desired direction, but it does not address sufficiently the bycatch issue in the Crangon fishery.


2017 ◽  
Vol 15 (2) ◽  
pp. 145-169
Author(s):  
Roghayeh Farsi

AbstractThe academic field of Qurʾānic Studies employs a wide range of approaches, each one of which helps to open up a new perspective on the Qurʾānic text. The Holy Book was revealed to guide people; it is thus of relevance to all aspects of people’s lives. This article focuses on the way social actors are represented in one Meccansūra, entitled “Ya-Sin”, and employs a case-study approach to do so. The analysis carried out includes the socio-semantic processes that thesūrauses in order to represent social actors either by behavior (action) or meaning (reflection), and it also analyzes the actors as they are represented in processes such as activation and passivation. The methodology adopted is eclectic and analytic. It is a hybrid of Swales’ move analysis, El-Awa’s identification of shift-markers, and Halliday’s and Van Leeuwen’s theories of social actor representation. This study shows how such an analysis can contribute to understanding the apparently fragmented and non-linear nature of “Ya-Sin”.


Sign in / Sign up

Export Citation Format

Share Document