Heat Demand Forecasting Models’ Development: Use of Data Mining Tools in SQL Server Analysis Services

This thesis introduces heat demand forecasting models which are generated by using data mining algorithms. The forecast spans one full day and this forecast can be used in regulating heat consumption of buildings. For training the data mining models, two years of heat consumption data from a case building and weather measurement data from Finnish Meteorological Institute are used. The thesis utilizes Microsoft SQL Server Analysis Services data mining tools in generating the data mining models and CRISP-DM process framework to implement the research. Results show that the built models can predict heat demand at best with mean average percentage errors of 3.8% for 24-h profile and 5.9% for full day. A deployment model for integrating the generated data mining models into an existing building energy management system is also discussed.

Spectral characteristics of bacteriorhodopsin water solution

The object of the study is bacteriorhodopsin. This light-sensitive protein have been selected as perspective substance for optical and optoelectronic applications. Bacteriorhodopsin carries out pumping protons through the cell membrane. Biomolecule converts light into an electric signal when sandwiched between electrodes. These properties were utilized in this research to implement photosensors on the basis of BR layers. These properties were utilized in this research to the bR water solution. According to the absorption spectra and using Kramers – Kronig relation the extinction coefficient has been calculated, as well as the related change of the refractive index value.

Location intelligence strategisen päätöksenteon tukena

Kilpailuetua tavoittelevan yrityksen pitää kyetä jalostamaan tietoa ja tunnistamaan sen avulla uusia tulevaisuuden mahdollisuuksia. Tulevaisuuden mielikuvien luomiseksi yrityksen on tunnettava toimintaympäristönsä ja olla herkkänä havaitsemaan muutostrendit ja muut toimintaympäristön signaalit. Ympäristön elintärkeät signaalit liittyvät kilpailijoihin, teknologian kehittymiseen, arvomaailman muutoksiin, globaaleihin väestötrendeihin tai jopa ympäristön muutoksiin. Spatiaaliset suhteet ovat peruspilareita käsitteellistää maailmaamme. Pitney (2015) on arvioinut, että 80 % kaikesta bisnesdatasta sisältää jollakin tavoin viittauksia paikkatietoon. Siitä huolimatta paikkatietoa on vielä huonosti hyödynnetty yritysten strategisten päätösten tukena. Teknologioiden kehittyminen, tiedon nopea siirto ja paikannustekniikoiden integroiminen eri laitteisiin ovat mahdollistaneet sen, että paikkatietoa hyödyntäviä palveluja ja ratkaisuja tullaan yhä enemmän näkemään yrityskentässä. Tutkimuksen tavoitteena oli selvittää voiko location intelligence toimia strategisen päätöksenteon tukena ja jos voi, niin miten. Työ toteutettiin konstruktiivista tutkimusmenetelmää käyttäen, jolla pyritään ratkaisemaan jokin relevantti ongelma. Konstruktiivinen tutkimus tehtiin tiiviissä yhteistyössä kolmen pk-yrityksen kanssa ja siihen haastateltiin kuutta eri strategiasta vastaavaa henkilöä. Tutkimuksen tuloksena löydettiin, että location intelligenceä voidaan hyödyntää strategisen päätöksenteon tukena usealla eri tasolla. Yksinkertaisimmassa karttaratkaisussa halutut tiedot tuodaan kartalle ja luodaan visuaalinen esitys, jonka avulla johtopäätöksien tekeminen helpottuu. Toisen tason karttaratkaisu pitää sisällään sekä sijainti- että ominaisuustietoa, jota on yhdistetty eri lähteistä. Tämä toisen tason karttaratkaisu on usein kuvailevaa analytiikkaa, joka mahdollistaa erilaisten ilmiöiden analysoinnin. Kolmannen eli ylimmän tason karttaratkaisu tarjoaa ennakoivaa analytiikkaa ja malleja tulevaisuudesta. Tällöin ohjelmaan koodataan älykkyyttä, jossa informaation keskinäisiä suhteita on määritelty joko tiedon louhintaa tai tilastollisia analyysejä hyödyntäen. Tutkimuksen johtopäätöksenä voidaan todeta, että location intelligence pystyy tarjoamaan lisäarvoa strategisen päätöksenteon tueksi, mikäli yritykselle on hyödyllistä ymmärtää eri ilmiöiden, asiakastarpeiden, kilpailijoiden ja markkinamuutoksien maantieteellisiä eroavaisuuksia. Parhaimmillaan location intelligence -ratkaisu tarjoaa luotettavan analyysin, jossa tieto välittyy muuttumattomana päätöksentekijältä toiselle ja johtopäätökseen johtaneita syitä on mahdollista palata tarkastelemaan tarvittaessa uudelleen.

Metalli-ionin ja hapon erotus toisistaan kalvosuodatuksella

Työn tarkoituksena oli kuparin ja hapon erottaminen toisistaan malliaineliuoksesta membraanitekniikalla. Kaivannaisteollisuudessa happoja käytetään metalleiden liuottamiseen. Lisäksi happamia jätevesiä syntyy sulfidikaivoksissa, sadeveden liuottaessa metalleja. Raskasmetallit ovat erittäin myrkyllistä vesieliöille. Työn tavoitteena oli saada happo ja metalli hyödynnettävään muotoon. Työn kokeellisessa osassa vertailtiin kahta polymeeristä ja keraamista membraania hapon ja metallin erotuksessa. Mittauksissa käytetyt membraanit olivat: AMS Technologies A-3012 ja A-3014 sekä Inopor ® Type SKR. Syöttöliuos sisälsi kuparisulfaattia ja rikkihappoa. Suodatukset tehtiin 30 ºC lämpötilassa useissa paineissa ja pH-arvoissa. Polymeeristen membraanien suodatusnäytteistä saadut retentiot kuparille olivat vastaavia aikaisempien tutkimusten tuloksien kanssa. A-3012 kalvon kuparin retentio oli 95 % ja A-3014 kalvolle kuparin retentio oli 90 %. Lisäksi mittausten korkeimmissa pH-arvoissa (2,9-2,3) happo konsentroitui permeaattiin. Polymeerisillä membraaneilla ei ollut merkkejä kalvon likaantumisesta tai hajoamisesta. Keraamisella membraanilla mitatut tulokset eivät olleet vastaavia aikaisempien tutkimusten tuloksien kanssa. Kuparin retentio olivat 2 ja 20 prosentin välillä, eikä liuoksen pH eronnut syötön ja permeaatin välillä. Tulosten perusteella molemmat tutkitut polymeeriset membraanit soveltuvat kuparin erottamiseen happamasta liuoksesta. Mittauksissa käytetty keraaminen membraani ei sovellu tähän tehtävään.

Datenherrschaft – an Ethically Justified Solution to the Problem of Ownership of Patient Information

Patient information systems are crucial components for the modern healthcare and medicine. It is obvious that without them the healthcare cannot function properly – one can try to imagine how brain surgery could be done without using information systems to gather and show information needed for an operation. Thus, it can be stated that digital information is irremovable part of modern healthcare. However, the legal ownership of patient information lacks a coherent and justified basis. The whole issue itself is actually bypassed by controlling pa- tient information with different laws and regulations how patient information can be used and by whom. Nonetheless, the issue itself – who owns the patient in- formation – is commonly missed or bypassed. This dissertation show the problems if the legislation of patient information ownership is not clear. Without clear legislation, the outcome can be unexpected like it seems to be in Finland, Sweden and United Kingdom: the lack of clear regulation has come up with unwanted consequences because of problematic Eu- ropean Union database directive implementation in those countries. The legal ownership is actually granted to the creators of databases which contains the pa- tient information, and this is not a desirable situation. In healthcare and medicine, we are dealing with issues such as life, health and information which are very sensitive and in many cases very personal. Thus, this dissertation leans on four philosophical theories form Locke, Kant, Heidegger and Rawls to have an ethically justified basis for regulating the patient infor- mation in a proper way. Because of the problems of property and ownership in the context of information, a new concept is needed and presented to replace the concept of owning, that concept being Datenherrschaft (eng. mastery over in- formation). Datenherrschaft seems to be suitable for regulating patient infor- mation because its core is the protection of one’s right over information and this aligns with the work of the philosophers whose theories are used in the work. The philosophical argumentation of this study shows that Datenherrschaft granted to the patients is ethically acceptable. It supports the view that patient should be controlling the patient information about themselves unless there are such specific circumstance that justifies the authorities to use patient information to protect other people’s basic rights. Thus, if the patients would be legally grant- ed Datenherrschaft over patient information we would endorse patients as indi- viduals who have their own and personal experience of their own life and have a strong stance against any unjustified paternalism in healthcare. Keywords: patient information, ownership, Datenherrschaft, ethics, Locke, Kant, Heidegger, Rawls

Mobile applications, solution for sustainable agriculture? - Study of mAgriculture services in Kenya

During the recent years, mobile services have spread to many different sectors, including education, health and agriculture, while changing the practices in those fields. Agriculture sector is under pressure to fill the ever-crowing food demand, while suffering from lack of agriculture resources (such as water and soil) and climate change, as well as figuring how to involve young people in the agriculture sector, in order to replace aging farmers. These issues create a need to bring new sustainable solutions to the agriculture sector. This is the demand, which mobile agriculture, mAgriculture, services are trying to answer. This thesis will examine the mAgriculture services in the Kenyan market. The thesis will provide an overview of the currently available mAgriculture services, their outcome and issues with which they are struggling. The thesis will also present recommendations on how to improve currently existing services and processes behind them. Secondly, thesis will provide four ideas for new services, which would answer for the needs of the farmers. Suitable business models, regarding the new services, are also covered. The thesis focuses with the young farmers as a target group, but findings are also applicable with other potential target groups as well.

Value-based selling of the column connection solution as part of project sales

The objective of this study was to find out how third party influencers can facilitate value-based selling in a network and how suppliers should aim to impact on these third party influencers to facilitate value-based selling. The study considers construction industry, selling the column connection solution and third party influencers. Third party influencers examined in this study were structural designers. The study also aims to find out structural designers’ value drivers and the differences between the market areas that this study related to. The theoretical part of the study focuses on two separate areas. The first part of the theory focuses on a value-based selling concept: what it is, what it requires and what are the main barriers for value-based selling. The second part of the theory examines value creation in networks. The present knowledge over value creation in networks and different network actors are presented. Project marketing is also discussed briefly because this study’s topic, which is highly related to project business. The results reveal structural designers’ value drivers considering the usage of the column connection solution and present ways how suppliers should aim to impact structural designers to facilitate value-based selling. The main result of the study indicates that third party influencers can have a positive impact on facilitating value-based selling. Structural designers are communicating more or less with all the salient actors in different project phases and they can act as sponsors to support the sales of Peikko’s column connection solution and promote solution to other actors involved to the project. This requires that structural designers can understand the actual benefits of how the solution can improve their and their customers’ business.

Improvement of Energy Efficiency in a Gold Mining Industry: Case Study of a Russian Gold Mining Company

The issue of energy efficiency is attracting more and more attention of academia, business and policy makers worldwide due to increasing environmental concerns, depletion of non-renewable energy resources and unstable energy prices. The significant importance of energy efficiency within gold mining industry is justified by considerable energy intensity of this industry as well as by the high share of energy costs in the total operational costs. In the context of increasing industrial energy consumption energy efficiency improvement may provide significant energy savings and reduction of CO2 emission that is highly important in order to contribute to the global goal of sustainability. The purpose of this research is to identify the ways of energy efficiency improvement relevant for a gold mining company. The study implements single holistic case study research strategy focused on a Russian gold mining company. The research involves comprehensive analysis of company’s energy performance including analysis of energy efficiency and energy management practices. This study provides following theoretical and managerial contributions. Firstly, it proposes a methodology for comparative analysis of energy performance of Russian and foreign gold mining companies. Secondly, this study provides comprehensive analysis of main energy efficiency challenges relevant for a Russian gold mining company. Finally, in order to overcome identified challenges this research conceives a guidance for a gold mining company for implementation of energy management system based on the ISO standard.

Earning logics of a portal solution for a medical device manufacturer

The need behind this thesis was in the development of a more modern earning logic for a pelvic floor muscle home training device to which a portal solution is going to be introduced as a part of new upgraded version of the device. The goal is to offer useful guidelines and recommendations for the medical device manufacturer to use in the process of creating the new business model around the new product version. In the theoretical part of this thesis, the used theoretical frameworks for business model generation and pricing models are presented. The special characteristics of healthcare technology industry are also introduced as initial data for the empirical part. The empirical data is collected via interviews and meetings from both inside and outside of the company to gain a comprehensive picture of the issue at hand. The needed changes in the business model as well as possible pricing options are gone through in the empirical chapters with the main focus being on the incoming revenue streams and pricing. As results of the thesis recommendations are presented for the changes that are needed in the business model after the introduction of the portal solution. The results of this thesis can be used for finishing the development process of the new version of the device and especially the earning logic of it.