Tietovaraston latausprosessin kehittämisen osittainen automatisointi Microsoft SQL Server 2008 -ympäristössä

Tässä työssä tutkitaan tietovaraston latausprosessin kehittämisen nopeuttamista Mic-rosoft SQL Server 2008 -ympäristössä. Työn teoriaosuudet on tarkoitettu tukemaan sekä työn tutkimus- että käytännönosia. Aiheeseen liittyviä tutkimuksia käytiin läpi parhaiden latausprosessin kehittämiseen kuluvaa aikaa vähentävien tapojen selvittä-miseksi. Nykytutkimus keskittyy valmistajasta riippumattomien mallien kehittämiseen ja valmistajakohtaisen latausprosessin luomiseen näiden mallien pohjalta. Yleinen konsensus parhaan mallin suhteen kuitenkin puuttuu. Aiheeseen liittyvien tutkimusten pohjalta esitetään arkkitehtuuri, joka saattaisi tule-vaisuudessa vähentää latausprosessin kehittämiseen kuluvaa aikaa huomattavasti. Tästä arkkitehtuurista luotiin yksinkertaistettu versio sekä siihen pohjautuva sovellus nopeuttamaan latausprosessin kehittämistä Microsoftin ETL-työkalulla.

Järjestelmätoimittajan suorituskyvyn mittaaminen johtamisen välineenä

Tutkimuksen tavoitteena on analysoida kokonaisratkaisuja tarjoavan järjestelmätoimittajan suorituskyvyn mittaamisen suunnittelua johdon päätöksenteon tukivälineeksi. Alitavoitteena oli suunnitella mittaristo case-yrityksen valitulle yksikölle sekä konsernitasolle. Tutkimuksen myötä havaittiin tarpeelliseksi tunnistaa järjestelmätoimittajan toimialatason vahvimmat ydinkyvykkyydet ja esittää ratkaisuja niiden mittaamiselle. Tutkimuksesta rajattiin mittariston hyödyntäminen yksilötason ohjauksessa. Tutkimusta lähestyttiin toiminta-analyyttisenä tapaustutkimuksena. Tutkimuksen yhteydessä määriteltiin järjestelmätoimittaja teollisen palveluliiketoiminnan toimijaksi, jonka mittaus painottuu asiakaslähtöisen toiminnan edistämiseen. Suurimmat haasteet muodostuivat aineettoman pääoman, pääosin uudistuvan ja uuden liiketoiminnan verkostojen mittaamisesta. Tutkimustuloksena voitiin havaita, että toimialatason keskeisimpiin ydinkyvykkyyksiin ja case-yrityksen linjaamiin menestystekijöihin pohjautunut tarkastelu onnistui tunnistamaan keskeisiä ongelmakohtia järjestelmätoimittajan mittariston suunnittelussa. Merkittävimmät toimenpidesuositukset ja laaditut mittariehdotukset painottavat asiakkaan prosessien tuntemista, oman osaamisen johtamista asiakkaan prosesseihin soveltuviksi, uusien innovaatioiden ja kyvykkyyksien luomista, erilaisten verkostojen tunnistamista ja kehittämistä, kyvykkyyksien johtamista ja tuotekeskeisen myynnin kehittämistä palvelukeskeiseen suuntaan. Tutkimus esittää näihin tuloksiin pohjautuvan mittariston ja prosessin aikana syntyneet mittariehdotukset.

The Environmental Status of the Port of HaminaKotka

This study is a part of the Ecologically Friendly Port Ust-Luga (EFP) project. The purpose of this study is to examine the environmental status of the Finnish ports and, more specifically, the Port of HaminaKotka. An analysis of the environmental status is performed mainly as a literature review, because the Finnish ports must comply with Finnish and EU legislation and with the binding international regulations and conventions created by different organizations. The International Maritime Organisation (IMO) has done groundbreaking work in the field of maritime safety and maritime environmental protection. The MARPOL convention has a great impact on decreasing pollution from international shipping and it applies to 99% of the world’s merchant tonnage. Pollution prevention covers: Oil pollution, Chemical pollution, Air pollution and GHG Emissions, Dumping of Wasted and Other Matters, Garbage, Sewage, Port Reception Facilities, Special Areas under MARPOL and Particularly Sensitive Sea Areas. There is also Pollution Prevention for other treaties like anti-fouling systems used on ships, the transfer of alien species by ships’ ballast water and the environmentally sound recycling of ships. There are more than twenty different EU and international regulations that influence ports and port operations in Finland. In addition, there is also national legislation that has an effect on Finnish ports. For the most part, the legislation for ports is common in the EU area, but the biggest and most important difference between the legislation in Finland and other EU countries is due to the Act on Environmental Impact Assessment Procedure. The Act states that the environmental impact assessment procedure shall be applied to projects that may have significant adverse environmental impacts, due to the special features of Finland`s nature and environment. In this Act, the term environmental impact refers to the direct and indirect effects inside and outside Finnish territory of a project or operations on human health, living conditions and amenity; soil, water, air, climate, organisms, interaction between them and biodiversity; community structure, buildings, landscape, townscape and cultural heritage; utilization of natural resources. In Finland, the Environmental Permit requires that ports collect all necessary information concerning environmental effects and make required reports to the Finnish authorities, stakeholders and the public. Commonly, environmental reporting is public and environmental achievements are emphasized in reporting and in media. At the moment, the problem in environmental reporting is that it’s difficult to compare data from different ports. There is enough data concerning the environmental effects and performance, but the manner of reporting and the quality of the data varies between ports. There are differences in the units and codes used, in some cases the information is not sufficient and it can even be rather unreliable. There are also differences regarding the subjects that are emphasized in reporting.

Relaatiotietokannan tiedonhallintajärjestelmän valintakriteerit

Tässä työssä käsitellään lähinnä relaatiomallia hyödyntäviä tiedonhallintajärjestelmiä. Tiedonhallintajärjestelmä hallitsee yleisesti tietokannan luontia, käyttöä ja muutoksia ja relaatiomallia käyttävät tiedonhallintajärjestelmät ovat jo 1970 -luvulta lähtien olleet hallitseva trendi tietokantamarkkinoilla. Työssä otetaan huomioon neljä eri tiedonhallintajärjestelmä-tyyppiä, jotka ovat keskitetyt, hajautetut, tietovarasto ja operatiiviset tiedonhallintajärjestelmät. Työssä selvitetään, miten näitä tiedonhallintajärjestelmiä voi verrata ja mitkä valintakriteerit vaikuttavat niiden valintaan.

Coaching-konstruktio strategian jalkauttamisessa

Tämän pro gradu – työn tavoitteena on selvittää miten coachingia voitaisiin hyödyntää strategian jalkauttamisessa esimiehen ja alaisen välisen viestinnän näkökulmasta. Tavoitteena on myös luoda ja toteuttaa konstruktio, jota voitaisiin käyttää johtamismenetelmänä esimiehen ja alaisen välisen viestinnän ohjaamisessa strategian jalkauttamisen hyväksi. Tutkielmassa sovelletaan kvalitatiivista ja kvantitatiivisista analyysitapaa ja tutkimusstrategiana on tapaustutkimus. Aineistonkeruu suoritetaan empiirisen osion osalta strukturoidun haastattelun avulla. Teoreettinen viitekehys rakentuu strategian jalkauttamisen ja esimies – alaisviestinnän aihepiireistä. Tutkielmassa kartoitetaan kohdeyrityksen strategian jalkauttamisen tasoa ja siinä tapahtuvia muutoksia coachingin seurauksena. Tutkielma nostaa esille niitä strategian jalkauttamisen osaalueita, joihin coachingilla voidaan mahdollisesti vaikuttaa. Aineiston analyysin perusteella coaching-työkalun käyttämisellä ei kuitenkaan pääosin ollut merkittäviä vaikutuksia strategian jalkauttamisen valittuihin osa-alueisiin. Työn suorittamisen tueksi saadun tiedon riittävyyden, oleellisen tiedon liikkumisen, strategian toteutumisesta keskustelun ja palautekäytäntöjen todettiin hieman parantuneen.

Tuotannon laadun vaikutus tuotteen kannattavuuteen ja laatuun – tapaustutkimus elektroniikkateollisuudesta

Tuotetakuusta aiheutuvat kustannukset ovat osa liiketoiminnan kulurakennetta, jolloin ne myös vaikuttavat liiketoiminnan kannattavuuteen. Takuukustannukset muodostuvat tuotteiden puutteellisesta laadusta, luotettavuudesta tai yleisesti tuotteiden kykenemättömyydestä saavuttaa niille asetettuja vaatimuksia. Tällöin takuukustannusten analyysissä poraudutaan tuotteiden ongelmien perimmäisiin syihin takuuliitännäisen datan avulla, pyrkimyksenä tarjota informaatiota todellisista tuotteiden ongelmien syistä. Tässä tutkimuksessa selvitetään tuotannon laadun vaikutusta tuotteen kannattavuuteen ja laatuun elektroniikkateollisuudessa. Tutkimus toteutettiin kvantitatiivisena tutkimuksena, jonka aineisto koostettiin elektroniikkateollisuudessa toimivan yrityksen keskitetystä tietovarastosta hyödyntämällä tietokantakyselyjä. Aineisto koostuu yhteensä 218493:sta kappaleesta tietyn tuotemallin tuotetta, jotka ovat valmistettu yhdessä tuotantolaitoksessa. Tutkimustulosten perusteella voidaan todeta tuotannon laadun vaikuttavan tuotteiden laatuun ja kannattavuuteen.

How Lean Six Sigma and Agile principles optimize ITIL-based processes

Imagine the potential implications of an organization whose business and IT processes are well aligned and are capable of reactively and proactively responding to the external and internal changes. The Philips IT Infrastructure and Operations department (I&O) is undergoing a series of transformation activities to help Philips business keeping up with the changes. I&O would serve a critical function in any business sectors; given that the I&O’s strategy switched from “design, build and run” to “specify, acquire and performance manage”, that function is amplified. In 2013, I&O’s biggest transforming programme I&O Futures engaged multiple interdisciplinary departments and programs on decommissioning legacy processes and restructuring new processes with respect to the Information Technology Internet Library (ITIL), helping I&O to achieve a common infrastructure and operating platform (CI&OP). The author joined I&O Futures in the early 2014 and contributed to the CI&OP release 1, during which a designed model Bing Box and its evaluations were conducted through the lens of six sigma’s structured define-measure-analyze-improve-control (DMAIC) improvement approach. This Bing Box model was intended to firstly combine business and IT principles, namely Lean IT, Agile, ITIL best practices, and Aspect-oriented programming (AOP) into a framework. Secondly, the author implemented the modularized optimization cycles according to the defined framework into Philips’ ITIL-based processes and, subsequently, to enhance business process performance as well as to increase efficiency of the optimization cycles. The unique of this thesis is that the Bing Box model not only provided comprehensive optimization approaches and principles for business process performance, but also integrated and standardized optimization modules for the optimization process itself. The research followed a design research guideline that seek to extend the boundaries of human and organizational capabilities by creating new and innovative artifacts. The Chapter 2 firstly reviewed the current research on Lean Six Sigma, Agile, AOP and ITIL, aiming at identifying the broad conceptual bases for this study. In Chapter 3, we included the process of constructing the Bing Box model. The Chapter 4 described the adoption of Bing Box model: two-implementation case validated by stakeholders through observations and interviews. Chapter 5 contained the concluding remarks, the limitation of this research work and the future research areas. Chapter 6 provided the references used in this thesis.

Systematic mapping study on integration of B2B customers in ERP

Business-to-business terminology is relatively new as a business concept, so is the enterprise resource planning system in information technology. Research, implementation and integration of these two concept has been observed for last two decades in this paper. One of the major success point for growth in business-to-business environment is the availability of internal and partner data. Enterprise resource planning system facilitates storing, analysis of such data and enables different business process automation, forecasting and numerous value creating activity. In order to achieve such functionality for B2B customers, integrating them within ERP is very useful. This paper aims at understanding and suggesting such integration through investigating related documentation of similar integration scenarios, infrastructure, models and architectures. The investigation of the topic of this paper has been made using systematic mapping study of related papers and listing and suggesting necessary ingredients that enables such integration. Furthermore, this paper also suggests possibilities to overcome challenges integration experts might face during the integration phase and opens doors to future research scope in the related fields.

Economic capital allocation

For my Licentiate thesis, I conducted research on risk measures. Continuing with this research, I now focus on capital allocation. In the proportional capital allocation principle, the choice of risk measure plays a very important part. In the chapters Introduction and Basic concepts, we introduce three definitions of economic capital, discuss the purpose of capital allocation, give different viewpoints of capital allocation and present an overview of relevant literature. Risk measures are defined and the concept of coherent risk measure is introduced. Examples of important risk measures are given, e. g., Value at Risk (VaR), Tail Value at Risk (TVaR). We also discuss the implications of dependence and review some important distributions. In the following chapter on Capital allocation we introduce different principles for allocating capital. We prefer to work with the proportional allocation method. In the following chapter, Capital allocation based on tails, we focus on insurance business lines with heavy-tailed loss distribution. To emphasize capital allocation based on tails, we define the following risk measures: Conditional Expectation, Upper Tail Covariance and Tail Covariance Premium Adjusted (TCPA). In the final chapter, called Illustrative case study, we simulate two sets of data with five insurance business lines using Normal copulas and Cauchy copulas. The proportional capital allocation is calculated using TCPA as risk measure. It is compared with the result when VaR is used as risk measure and with covariance capital allocation. In this thesis, it is emphasized that no single allocation principle is perfect for all purposes. When focusing on the tail of losses, the allocation based on TCPA is a good one, since TCPA in a sense includes features of TVaR and Tail covariance.

Effect of Material Recycling on the Feasibility of Solid Recovered Fuel Fired Power Plant

This master’s thesis examines the effects of increased material recycling on different waste-to-energy concepts. With background study and a developed techno-economic computational method the feasibility of chosen scenarios with different combinations of mechanical treatment and waste firing technologies can be evaluated. The background study covers the waste scene of Finland, and potential market areas Poland and France. Calculated cases concentrate on municipal solid waste treatment in the Finnish operational environment. The chosen methodology to approach the objectives is techno-economic feasibility assessment. It combines calculation methods of literature and practical engineering to define the material and energy balances in chosen scenarios. The calculation results together with other operational and financial data can be concluded to net present values compared between the scenarios. For the comparison, four scenarios, most vital and alternative between each other, are established. The baseline scenario is grate firing of source separated mixed municipal solid waste. Second scenario is fluidized bed combustion of solid recovered fuel produced in mechanical treatment process with metal separation. Third scenario combines a biomaterial separation process to the solid recovered fuels preparation and in the last scenario plastics are separated in addition to the previous operations. The results indicated that the mechanical treatment scenarios still need to overcome some problems to become feasible. Problems are related to profitability, residue disposal and technical reliability. Many uncertainties are also related to the data gathered over waste characteristics, technical performance and markets. With legislative support and development of further processing technologies and markets of the recycled materials the scenarios with biomaterial and plastic separation may operate feasibly in the future.

Sélection de modèle d'imputation à partir de modèles bayésiens hiérarchiques linéaires multivariés

Les logiciels utilisés sont Splus et R.

Analyse géographique des investissements internationaux de la China National Petroleum Corporation

Ce mémoire propose une analyse de l’expansion internationale de la China National Petroleum Corporation (CNPC) et des impacts de cette expansion sur la sécurité énergétique de la Chine. Dans le cadre de cette recherche, l’approvisionnement énergétique d’un pays est jugé sécuritaire lorsqu’une quantité suffisante de ressources nécessaires pour combler sa demande en énergie sont présentes, disponibles et accessibles et que son approvisionnement en services énergétiques demeure fiable et abordable. La recherche comporte quatre volets. Le premier volet porte sur les étapes de la restructuration de l’industrie pétrolière chinoise depuis 1949. Celle-ci est analysée au travers des changements dans les modes de gestion des compagnies pétrolières nationales et dans leurs relations avec le gouvernement chinois. Le deuxième volet traite de la diversification et des nouvelles spécialisations de CNPC. Ces aspects sont étudiés dans le cadre d’une analyse du pourcentage de ses actifs dans chaque segment industriel (aval, intermédiaire et amont) obtenus grâce à ses rapports annuels. Le troisième volet aborde la répartition géographique des activités de la compagnie que l’on étudie à l’aide d’une analyse approfondie de près de 150 investissements, acquisitions et contrats réalisés à l’étranger entre 1992 et 2014. Le quatrième volet aborde les impacts des investissements à l’étranger de la compagnie sur la sécurité énergétique de la Chine. Ces impacts sont mesurés par l’entremise d’une analyse des flux pétroliers internationaux vers la Chine que l’on compare à la production de CNPC par pays. Ce mémoire permet de déterminer que l’expansion internationale de CNPC sert d’abord et avant tout les intérêts économiques de la compagnie. Ce sont surtout ses investissements dans la construction d’infrastructures de transport (oléoducs, gazoducs ainsi que les usines et terminaux de liquéfaction de gaz naturel liquéfié) qui apportent des bénéfices directs à la sécurité énergétique de la Chine. La contribution des investissements dans les autres secteurs est beaucoup moins systématique et dépend largement de la période au cours de laquelle ils ont été effectués.

Análisis de las tensiones geopolíticas entre Kirguistán y Uzbekistán por el Valle de Fergana y sus recursos energéticos durante el periodo 2001-2010

Las tensiones geopolíticas entre Kirguistán y Uzbekistán por el Valle de Fergana durante el periodo 2001-2010 a partir de un análisis histórico de la formación de la población y la influencia de los diferentes imperios en la región. Adicionalmente, los aspectos relativos a la importancia de los recursos energéticos en el Valle de Fergana como la configuración de las tensiones generadas entre estos dos países, haciendo énfasis en el conflicto étnico latente que se ha generado en la zona. De se utilizarán la teoría constructivista de Alexander Wendt y la teoría de la geopolítica de Yves Lacoste.

PhD Students’ Research Group Networks: a Qualitative Approach

This article examines the networks within the research groups where Spanish PhD students are pursuing their doctorate. Capó et al. (2007) used quantitative data to predict PhD students’ publishing performance from their background, attitudes, supervisors’ performance and research group networks. Variables related to the research group network had a negligible explanatory power on student performance once the remaining variables had been accounted for. In this article, a qualitative follow up of the same students is carried out using extreme case sampling and indepth interviews. The qualitative research shows networking as important for students. Out of the 115 aspects that students mention in the interviews as relevant to publishing in the qualitative research, 92 have to do with their supervisors, their research group or their network as a whole. Similarly, out of the 50 hindrances mentioned, 20 have to do with the networks or relations. The most commonly mentioned network-related topics are research group members pushing PhD students to publish, meeting researchers outside the research group, existence of other PhD students in the group, help with the PhD from group members, supervisor’s interest in the thesis, the possibility of discussing with experts on the PhD’s topic and frequent contact with the supervisor and research group members. Some of these characteristics were not, however, measured in the conventional quantitative social network survey

BI nas organizações

O Business Intelligence é uma solução que suporta o processo de tomada de decisão numa organização, tendo como principais utilizadores os administradores, gestores de topo e directores, no fundo, utilizadores com poder de decisão. Este conjunto de ferramentas (BI) tem a capacidade de extrair, transformar/processar e carregar grandes volumes de dados provenientes das mais variadas fontes, sejam elas internas ou externas à organização. Além desta capacidade, o BI tem também a capacidade analítica dos dados providenciando aos utilizadores informação preciosa para a tomada de decisão. Considerando o tempo como um factor influenciador e diferenciador entre organizações, a escolha e a correcta implementação de uma solução de BI é essencial para o sucesso de uma organização. No entanto, muitas organizações implementam projectos com sucesso ao nível técnico, mas não conseguem obter os resultados esperados. Este facto ocorre quando se separa a componente tecnológica da cultura organizacional e das pessoas. É importante englobar na cultura da organização que a informação é um recurso estratégico para a obtenção dos objectivos. Este trabalho tem como objectivo avaliar soluções de BI e a forma como estas estão implementadas, procurando fornecer informações essenciais para o sucesso nas organizações. Para suportar a argumentação, realiza-se, nesta dissertação, um estudo a organizações Portuguesas líderes na área das telecomunicações. Este estudo baseou-se na análise das respostas a um questionário colocado a pessoas chave com a finalidade de avaliar a situação actual do BI nas organizações procurando salientar o real valor que este traz; de que forma é utilizado; se está bem implementado e principalmente se tem contribuído no suporte aos processos de tomada de decisão. O estudo ficou, porém, limitado devido ao feedback estatisticamente insuficiente, pelo que as conclusões da presente dissertação são meramente exploratórias, de natureza qualitativa e necessariamente prudentes nas generalizações.