Data management as a part of performance management: Case study about production reporting development project

Because of the increased availability of different kind of business intelligence technologies and tools it can be easy to fall in illusion that new technologies will automatically solve the problems of data management and reporting of the company. The management is not only about management of technology but also the management of processes and people. This thesis is focusing more into traditional data management and performance management of production processes which both can be seen as a requirement for long lasting development. Also some of the operative BI solutions are considered in the ideal state of reporting system. The objectives of this study are to examine what requirements effective performance management of production processes have for data management and reporting of the company and to see how they are effecting on the efficiency of it. The research is executed as a theoretical literary research about the subjects and as a qualitative case study about reporting development project of Finnsugar Ltd. The case study is examined through theoretical frameworks and by the active participant observation. To get a better picture about the ideal state of reporting system simple investment calculations are performed. According to the results of the research, requirements for effective performance management of production processes are automation in the collection of data, integration of operative databases, usage of efficient data management technologies like ETL (Extract, Transform, Load) processes, data warehouse (DW) and Online Analytical Processing (OLAP) and efficient management of processes, data and roles.

Chronic beryllium disease as a re-emerging occupational disorder possibly misdiagnosed as sarcoidosis : a Swiss study project

Background: Beryllium (Be) is increasingly used worldwide for numerous industrial applications. Occupational exposure to Be may lead to Be sensitization (BeS), a CD4-mediated immune response. BeS may progress to chronic beryllium disease (CBD), a granulomatous lung disorder closely resembling sarcoidosis. The recognition of CBD requires detection of Be exposure at occupational history, and detection of BeS on blood or BAL lymphocytes. Since methods for CBD detection are not routinely available in Switzerland, we hypothesized that CBD cases are not recognized but misdiagnosis as sarcoidosis. Objective: To present an ongoing Swiss study screening patients with sarcoidosis in search of Be exposure, BeS, and CBD. Methods: Both a prospective and a retrospective cohort are being studied. In the prospective cohort, the main steps include: 1) recruitment of 100 consecutive patients with newly diagnosed pulmonary sarcoidosis at 2 centers (Lausanne, Bern). 2) screening for possible occupational Be exposure by self-administered patient questionnaire. 3) standardized detailed occupational interview and clinical visit by occupational health specialist. If step 3 is positive, then 4) blood and BAL sampling for detection of BeS by specifically developed Elispot assay and CFSE flow cytometry, with subsequent comparison to the classical Be lymphocyte proliferation test. If step 4 is positive, then 5) review of medical records and diagnostic revision from sarcoidosis to CBD. 6) appropriate measures for exposure cessation and case reporting to SUVA as occupational disease. The retrospective cohort will include 400 patients with previously diagnosed pulmonary sarcoidosis, either treated or untreated, recruited through the SIOLD Registries. Steps 2 to 5 will be peformed as above, except for a) end of study after step 2 if screening questionnaire does not reveal Be exposure, and b) step 4 done on blood sample only (BAL not needed). Current status: Self-administered screening questionnaire and tools for standardized occupational interview have been developed. BeS testing has been implemented and undergoes validation. Inclusions in the prospective phase have started at both study sites. The retrospective phase is in preparation. Conclusion: The current study status allows to conclude to technical feasibility of the project. The prospective phase if this study is funded by the SUVA. The SIOLD Registries are supported by the Swiss Pulmonary League.

The EU-ADR Web Platform: delivering advanced pharmacovigilance tools

PURPOSE: Pharmacovigilance methods have advanced greatly during the last decades, making post-market drug assessment an essential drug evaluation component. These methods mainly rely on the use of spontaneous reporting systems and health information databases to collect expertise from huge amounts of real-world reports. The EU-ADR Web Platform was built to further facilitate accessing, monitoring and exploring these data, enabling an in-depth analysis of adverse drug reactions risks.METHODS: The EU-ADR Web Platform exploits the wealth of data collected within a large-scale European initiative, the EU-ADR project. Millions of electronic health records, provided by national health agencies, are mined for specific drug events, which are correlated with literature, protein and pathway data, resulting in a rich drug-event dataset. Next, advanced distributed computing methods are tailored to coordinate the execution of data-mining and statistical analysis tasks. This permits obtaining a ranked drug-event list, removing spurious entries and highlighting relationships with high risk potential.RESULTS: The EU-ADR Web Platform is an open workspace for the integrated analysis of pharmacovigilance datasets. Using this software, researchers can access a variety of tools provided by distinct partners in a single centralized environment. Besides performing standalone drug-event assessments, they can also control the pipeline for an improved batch analysis of custom datasets. Drug-event pairs can be substantiated and statistically analysed within the platform's innovative working environment.CONCLUSIONS: A pioneering workspace that helps in explaining the biological path of adverse drug reactions was developed within the EU-ADR project consortium. This tool, targeted at the pharmacovigilance community, is available online at https://bioinformatics.ua.pt/euadr/. Copyright © 2012 John Wiley & Sons, Ltd.

Reporting customer information for sales management

Elektroniikan alihankintapalveluiden (EMS) liiketoimintaympäristössä yritykset toimivat pääasiassa asiakkaiden projektien ja ulkoistamispäätösten keskellä. Tämän tyyppisessä liiketoimintaympäristössä on asiakas keskeisessä roolissa, kuten liiketoiminnassa yleensäkin. Termi EMS sisältää koko tuotteen elinkaaren aina suunnittelusta myynnin jälkeisiin palveluihin. Asiakkaan olessa erittäin tärkeä yritykselle, on myös selvitettävä mitkä asiakkaat ovat yrityksen kannalta arvokkaimmat. Tämän tutkimuksen tavoitteena oli selvittää myyntijohdon tietotarpeet sekä löytää selkeä ja helppokäyttöinen tapa tuoda tarvittava informaatio heidän käyttöönsä. Tietotarpeet selvitettiin haastatteluilla ja kyselytutkimuksella ja sopivan järjestelmän löytämisessä käytettiin prototyyppi-lähestymistä, jotta saataisiin selville täyttääkö valittu järjestelmä myyntijohdon tarpeet. Nk. dashboard-mittaristot ovat hyvä tapa tuoda asiakasinformaatiota päätöksenteontueksi. Tälläisillä mittaristoilla voidaan myös yhdistellä eri lähteistä olevaa tietoa ja tuoda se ymmärrettävässä muodossa esiin. Tässä tutkimuksessa kuvataan mittariston suunnittelu myyntijohdon tarpeisiin. Ensimmäisenä tutkitaan kyselyn avulla myyntijohtajien tiedon tarpeet ja tämän jälkeen etsitään sopiva tekninen sovellus ja ratkaistaan tiedon siirtoihin liittyvät ongelmat. Kun ensimmäinen versio on valmis, esitellään se myyntijohdolle, jotta saadaan kerättyä kommentit seuraavaan versioon.

Digitization Project of Kindred Languages : materials, methods and tools for researchers

Presentation at "Soome-ugri keelte andmebaasid ja e-leksikograafia" at Eesti Keele Instituut (Institution of Estonian Languages) in Tallnn on the 18th of November 2014.

A Project Portfolio Tool for Forecasting Small Projects Profitability

The case company in this study is a large industrial engineering company whose business is largely based on delivering a wide-range of engineering projects. The aim of this study is to create and develop a fairly simple Excel-based tool for the sales department. The tool’s main function is to estimate and visualize the profitability of various small projects. The study also aims to find out other possible and more long-term solutions for tackling the problem in the future. The study is highly constructive and descriptive as it focuses on the development task and in the creation of a new operating model. The developed tool focuses on estimating the profitability of the small orders of the selected project portfolio currently on the bidding-phase (prospects) and will help the case company in the monthly reporting of sales figures. The tool will analyse the profitability of a certain project by calculating its fixed and variable costs, then further the gross margin and operating profit. The bidding phase of small project is a phase that has not been covered fully by the existing tools within the case company. The project portfolio tool can be taken into use immediately within the case company and it will provide fairly accurate estimate of the profitability figures of the recently sold small projects.

Overview: oxidant and particle photochemical processes above a south-east Asian tropical rain forest (the OP3 project); introduction, rationale, location, characteristics and tools

In April–July 2008, intensive measurements were made of atmospheric composition and chemistry in Sabah, Malaysia, as part of the "Oxidant and particle photochemical processes above a South-East Asian tropical rainforest" (OP3) project. Fluxes and concentrations of trace gases and particles were made from and above the rainforest canopy at the Bukit Atur Global Atmosphere Watch station and at the nearby Sabahmas oil palm plantation, using both ground-based and airborne measurements. Here, the measurement and modelling strategies used, the characteristics of the sites and an overview of data obtained are described. Composition measurements show that the rainforest site was not significantly impacted by anthropogenic pollution, and this is confirmed by satellite retrievals of NO2 and HCHO. The dominant modulators of atmospheric chemistry at the rainforest site were therefore emissions of BVOCs and soil emissions of reactive nitrogen oxides. At the observed BVOC:NOx volume mixing ratio (~100 pptv/pptv), current chemical models suggest that daytime maximum OH concentrations should be ca. 105 radicals cm−3, but observed OH concentrations were an order of magnitude greater than this. We confirm, therefore, previous measurements that suggest that an unexplained source of OH must exist above tropical rainforest and we continue to interrogate the data to find explanations for this.

Developing European conservation and mitigation tools for pollination services: approaches of the STEP (Status and Trends of European Pollinators) project

Pollinating insects form a key component of European biodiversity, and provide a vital ecosystem service to crops and wild plants. There is growing evidence of declines in both wild and domesticated pollinators, and parallel declines in plants relying upon them. The STEP project (Status and Trends of European Pollinators, 2010-2015, www.step-project.net) is documenting critical elements in the nature and extent of these declines, examining key functional traits associated with pollination deficits, and developing a Red List for some European pollinator groups. Together these activities are laying the groundwork for future pollinator monitoring programmes. STEP is also assessing the relative importance of potential drivers of pollinator declines, including climate change, habitat loss and fragmentation, agrochemicals, pathogens, alien species, light pollution, and their interactions. We are measuring the ecological and economic impacts of declining pollinator services and floral resources, including effects on wild plant populations, crop production and human nutrition. STEP is reviewing existing and potential mitigation options, and providing novel tests of their effectiveness across Europe. Our work is building upon existing and newly developed datasets and models, complemented by spatially-replicated campaigns of field research to fill gaps in current knowledge. Findings are being integrated into a policy-relevant framework to create evidence-based decision support tools. STEP is establishing communication links to a wide range of stakeholders across Europe and beyond, including policy makers, beekeepers, farmers, academics and the general public. Taken together, the STEP research programme aims to improve our understanding of the nature, causes, consequences and potential mitigation of declines in pollination services at local, national, continental and global scales.

Tools for better SLM knowledge management and informed decision-making in addressing land degradation at different scales: the WOCAT–LADA–DESIRE methodology

Desertification research conventionally focuses on the problem – that is, degradation – while neglecting the appraisal of successful conservation practices. Based on the premise that Sustainable Land Management (SLM) experiences are not sufficiently or comprehensively documented, evaluated, and shared, the World Overview of Conservation Approaches and Technologies (WOCAT) initiative (www.wocat.net), in collaboration with FAO’s Land Degradation Assessment in Drylands (LADA) project (www.fao.org/nr/lada/) and the EU’s DESIRE project (http://www.desire-project.eu/), has developed standardised tools and methods for compiling and evaluating the biophysical and socio-economic knowledge available about SLM. The tools allow SLM specialists to share their knowledge and assess the impact of SLM at the local, national, and global levels. As a whole, the WOCAT–LADA–DESIRE methodology comprises tools for documenting, self-evaluating, and assessing the impact of SLM practices, as well as for knowledge sharing and decision support in the field, at the planning level, and in scaling up identified good practices. SLM depends on flexibility and responsiveness to changing complex ecological and socioeconomic causes of land degradation. The WOCAT tools are designed to reflect and capture this capacity of SLM. In order to take account of new challenges and meet emerging needs of WOCAT users, the tools are constantly further developed and adapted. Recent enhancements include tools for improved data analysis (impact and cost/benefit), cross-scale mapping, climate change adaptation and disaster risk management, and easier reporting on SLM best practices to UNCCD and other national and international partners. Moreover, WOCAT has begun to give land users a voice by backing conventional documentation with video clips straight from the field. To promote the scaling up of SLM, WOCAT works with key institutions and partners at the local and national level, for example advisory services and implementation projects. Keywords: Sustainable Land Management (SLM), knowledge management, decision-making, WOCAT–LADA–DESIRE methodology.

Capacity building in the use of geospatial tools for natural resource management in Tajikistan: Inception report BNWPP project

The Centre for Development and Environment (CDE) has been contracted by the World Bank Group to conduct a program on capacity development in use of geospatial tools for natural resource management in Tajikistan. The program aimed to help improving natural resource management by fostering the use of geospatial tools among governmental and non-governmental institutions in Tajikistan. For this purpose a database including a Geographic Information System (GIS) has been prepared, which combines spatial data on various sectors for case study analysis related to the Community Agriculture and Watershed Management Project (CAWMP). The inception report is based on the findings resulting from the Swiss Consultant Trust Fund (CTF) financed project, specifically on the experiences from the awareness creation and training workshop conducted in Dushanbe in November 2007 and the analysis of historical land degradation trends carried out for the four CAWMP watersheds. Furthermore, also recommendations from the inception mission of CDE to Tajikistan (5-20 August 2007) and the inception report for the Swiss CTF support were considered. The inception report for the BNWPP project (The Bank-Netherlands Water Partnership Program) discusses the following project relevant issues: (1) Preliminary list of additional data layers, types of data analysis, and audiences to be covered by BNWPP grant (2) Assessing skills and equipment already available within Tajikistan, and implications for training program and specific equipment procurement plans (3) Updated detailed schedule and plans for all activities to be financed by BNWPP grant, and (4) Proposed list of contents for the final report and web-based presentations.

Advances in camera trap data management tools: Towards collaborative development and integration with GIS

Camera traps have become a widely used technique for conducting biological inventories, generating a large number of database records of great interest. The main aim of this paper is to describe a new free and open source software (FOSS), developed to facilitate the management of camera-trapped data which originated from a protected Mediterranean area (SE Spain). In the last decade, some other useful alternatives have been proposed, but ours focuses especially on a collaborative undertaking and on the importance of spatial information underpinning common camera trap studies. This FOSS application, namely, “Camera Trap Manager” (CTM), has been designed to expedite the processing of pictures on the .NET platform. CTM has a very intuitive user interface, automatic extraction of some image metadata (date, time, moon phase, location, temperature, atmospheric pressure, among others), analytical (Geographical Information Systems, statistics, charts, among others), and reporting capabilities (ESRI Shapefiles, Microsoft Excel Spreadsheets, PDF reports, among others). Using this application, we have achieved a very simple management, fast analysis, and a significant reduction of costs. While we were able to classify an average of 55 pictures per hour manually, CTM has made it possible to process over 1000 photographs per hour, consequently retrieving a greater amount of data.