Tehdasmittausten varastointi moniulotteisella tietomallilla

Tietovarastoissa moniulotteinen tietomalli on tehokkain tapa esittää tietoa päätöksentekijöille. Sen toimivuus on hyväksi havaittu monissa eri liiketoimintaympäristöissä. Tehdasympäristöissä on tuhansia mittalaitteita, joista jokainen mittaa uniikkia valmistusprosessiin liittyvää piirrettä. Tässä työssä kehitettiin tietovarasto tehdasmittausten varastointiin käyttäen moniulotteista tietomallia. Havaittiin, että moniulotteisella mallilla tehdasmittaukset voidaan tallentaa joustavalla tavalla ja esittää käyttäjälle mielekkäässä muodossa. Moniulotteinen malli antaa myös erinomaiset keinot tiedon ryhmittelyyn ja vertailuun. Sillä ei kuitenkaan saada vastaavanlaisia hyötyjä kuin klassisissa kaupanalan tietovarastointi esimerkeissä, koska eri mittaukset ovat keskenään hyvin erilaisia. Vaikka mittaukset eivät olekaan aina vertailtavissa tai summattavissa keskenään, saadaan ne moniulotteisella mallilla tallennettua ja luokiteltua loogisesti siten, että käyttäjän on helppo löytää tarvitsemansa tieto. Lisäksi yleisesti tunnettu ja paljon käytetty tietovaraston suunnittelumalli takaa sen, että markkinoilta on saatavissa työkaluja tietovaraston käyttöön. Tietokannan toteutus tehtiin vapaasti levitettävän MySQLtiedonhallintajärjestelmän avulla. Sitä ei ole suunniteltu pääasiassa tietovarastokäyttöön, mutta halpa lisenssi ja hyvä skaalautuvuus tekevät siitä mielenkiintoisen vaihtoehdon. Sitä onkin käytetty luultua enemmän tietovarastoinnissa ja myös monien nimekkäiden organisaatioiden toimesta. Myös tässä työssä todettiin, että MySQL tarjoaa riittävät välineet tietovaraston kehittämiseen.

A repository is NOT a digital archive

Presentation at Open Repositories 2014, Helsinki, Finland, June 9-13, 2014

Improving reporting management with relational database management system

Data management consists of collecting, storing, and processing the data into the format which provides value-adding information for decision-making process. The development of data management has enabled of designing increasingly effective database management systems to support business needs. Therefore as well as advanced systems are designed for reporting purposes, also operational systems allow reporting and data analyzing. The used research method in the theory part is qualitative research and the research type in the empirical part is case study. Objective of this paper is to examine database management system requirements from reporting managements and data managements perspectives. In the theory part these requirements are identified and the appropriateness of the relational data model is evaluated. In addition key performance indicators applied to the operational monitoring of production are studied. The study has revealed that the appropriate operational key performance indicators of production takes into account time, quality, flexibility and cost aspects. Especially manufacturing efficiency has been highlighted. In this paper, reporting management is defined as a continuous monitoring of given performance measures. According to the literature review, the data management tool should cover performance, usability, reliability, scalability, and data privacy aspects in order to fulfill reporting managements demands. A framework is created for the system development phase based on requirements, and is used in the empirical part of the thesis where such a system is designed and created for reporting management purposes for a company which operates in the manufacturing industry. Relational data modeling and database architectures are utilized when the system is built for relational database platform.

Applying customer value measurement to a customer loyalty program: Case of implementing a key performance indicator based on customer value

In recent decade customer loyalty programs have become very popular and almost every retail chain seems to have one. Through the loyalty programs companies are able to collect information about the customer behavior and to use this information in business and marketing management to guide decision making and resource allocation. The benefits for the loyalty program member are often monetary, which has an effect on the profitability of the loyalty program. Not all the loyalty program members are equally profitable, as some purchase products for the recommended retail price and some buy only discounted products. If the company spends similar amount of resources to all members, it can be seen that the customer margin is lower on the customer who bought only discounted products. It is vital for a company to measure the profitability of their members in order to be able to calculate the customer value. To calculate the customer value several different customer value metrics can be used. During the recent years especially customer lifetime value has received a lot of attention and it is seen to be superior against other customer value metrics. In this master’s thesis the customer lifetime value is implemented on the case company’s customer loyalty program. The data was collected from the customer loyalty program’s database and represents year 2012 on the Finnish market. The data was not complete to fully take advantage of customer lifetime value and as a conclusion it can be stated that a new key performance indicator of customer margin should be acquired in order to profitably drive the business of the customer loyalty program. Through the customer margin the company would be able to compute the customer lifetime value on regular basis enabling efficient resource allocation in marketing.

Measurement of Bioactivity of Immunomodulatory Treatment of Relapsing Multiple Sclerosis. With Emphasis on MxA Protein

Background Multiple sclerosis (MS) is a demyelinating disease of the central nervous system, which mainly affects young adults. In Finland, approximately 2500 out of 6000 MS patients have relapsing MS and are treated with disease modifying drugs (DMD): interferon- β (INF-β-1a or INF-β-1b) and glatiramer acetate (GA). Depending on the used IFN-β preparation, 2 % to 40 % of patients develop neutralizing antibodies (NAbs), which abolish the biological effects of IFN-β, leading to reduced clinical and MRI detected efficacy. According to the Finnish Current Care Guidelines and European Federation of Neurological Societis (EFNS) guidelines, it is suggested tomeasure the presence of NAbs during the first 24 months of IFN-β therapy. Aims The aim of this thesis was to measure the bioactivity of IFN-β therapy by focusing on the induction of MxA protein (myxovirus resistance protein A) and its correlation to neutralizing antibodies (NAb). A new MxA EIA assay was set up to offer an easier and rapid method for MxA protein detection in clinical practice. In addition, the tolerability and safety of GA were evaluated in patients who haddiscontinued IFN-β therapy due to side effects and lack of efficacy. Results NAbs developed towards the end of 12 months of treatment, and binding antibodies were detectable before or parallel with them. The titer of NAb correlated negatively with the amount of MxA protein and the mean values of preinjection MxA levels never returned to true baseline in NAb negative patients, but tended to drop in the NAb positive group. The test results between MxA EIA and flow cytometric analysis showed significant correlation. GA reduced the relapse rate and was a safe and well-tolerated therapy in IFN-β-intolerant MS patients. Conclusions NAbs inhibit the induction of MxA protein, which can be used as a surrogate marker of the bioactivity of IFN-β therapy. Compared to flow cytometricanalysis and NAb assay, MxA-EIA seemed to be a sensitive and more practical method in clinical use to measure the actual bioactivity of IFN-β treatment, which is of value also from a cost-effective perspective.

The Nordic Gene Bank's Prunus clone archive in Finland 1

Selostus: Pohjoismaisen geenipankin Prunus-kokoelma Suomessa : 1. Hapankirsikkakannat

The Nordic Gene Bank's Prunus clone archive in Finland 2

Selostus: Pohjoismaisen geenipankin Prunus-kokoelma Suomessa : 1. Luumukannat

Measurement of the tree root growth using electrical impedance spectroscopy

Abstract

Functions for estimating stem diameter and tree age using tree height, crown width and existing stand database information

Abstract

Estimation of forest canopy cover : a comparison of field measurement techniques

Abstract

The impact of further tariff reduction on the EU sugar sector in the forthcoming multilateral round

Selostus: WTO:n kauppaneuvotteluissa esitettyjen tuontitullien alentamisvaihtoehtojen vaikutukset EU:n sokerimarkkinoihin

Business Development Efforts and Performance Improvements in SMEs Case Study of Business Development Projects Implemented in SME

Under the circumstances of the increasing market pressure, enterprises try to improve their competitive position by development efforts, and a business development project is one tool for that. There are not many answers to the question of how the development projects launched to improve the business performance in SMEs have succeeded. Theacademic interest in the business development project success has mainly focused on projects implemented in larger organisations rather than in SMEs. The previous studies on the business success of SMEs have mainly focused on new business ventures rather than on existing SMEs. However, nowadays a large number of business development projects are undertaken in existing SMEs, where they can pose a great challenge. This study focuses on business development success in SMEs thathave already established their business. The objective of the present study is to gain a deep understanding on business development project success in the SME-context and to identify the dimensions and factors affecting the project success. Further, the aim is to clarify how the business development projects implemented in SMEs have affected their performance. The empirical evidence is based on multiple case study. This study builds a framework for a generic theory of business development success in the SME-context, based on literature from the areas ofproject and change management, entrepreneurship and small business management, as well as performance measurement, and on empirical evidence from SMES. The framework consists of five success dimensions: entrepreneurial, project preparation, change management, project management and project success. The framework provides a systematic way for analysing the business development project and its impact on the performance and on the performing company. This case evidence indicates that successful business development projects have a balanced, high performance concerning all the dimensions. Good performance in one dimension is not enoughfor the project success, but it gives a good ground for the other dimensions. The other way round, poor performance in one success dimension affects the others, leading to poor performance of the project. In the SME-context the business development project success seems to be dependent on several interrelated dimensions and factors. Success in one area leads to success in other areas, and so creates an upward success spiral. Failure in one area seems to lead to failure in other areas, creating a downward failure spiral. The study indicates that the internal business development projects have affected the SMEs' performance widely also on areas and functions not initially targeted. The implications cover all thesuccess categories: the project efficiency, the impact on the customer, the business success and the future potentiality. With successful cases, the success tends to spread out to areas and functions not mentioned as the project goals, andwith unsuccessful cases the failure seems to spread out widely to the SMEs' other functions. This study also indicates that the most important key factors for successful business development project implementation are the strength of intention, business ability, knowledge, motivation and participation of the employees, as well as adequate and well-timed training provided to the employees.