A client focused business intelligence & analytics solution for the hospitality sector

Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceOne of the greatest needs of today's business is to know the customer or the type of customer it wants to reach, which makes a customer database a strategic weapon and one of the most important investments a company can make. The business world is becoming more competitive every day, we are constantly overwhelmed with advertisements of products we may like, product promotions we usually buy or discounts on the next purchase if we subscribe to the company’s newsletter. All of this creates a client customization, and any company that is not able to do this cannot keep up with its competition. This report details the project developed at Pestana Hotel Group, which consisted of a Business Intelligence solution, more specifically the development of a customer database with the creation of two tabular models using SQL Server tools, one specific for loyal customers and another, more general, with information about all Pestana customers, and two Power BI reports that allow the visualization of the information obtained in an effective and simplified way. This report contains a literature review that situates the reader on the subject addressed in this project, a chapter dedicated to the data modeling used to create the tabular models, and another on the creation of the reports.Uma das maiores necessidades dos negócios atuais é conhecer o seu cliente ou o tipo de cliente que quer atingir, o que torna uma base de dados de cliente uma arma estratégica e um dos mais importantes investimentos. O mundo empresarial está cada dia mais competitivo, somos constantemente assoberbados com anúncios de produtos que podemos gostar, promoções de produtos que costumamos comprar ou descontos na próxima compra caso subscrevamos a newsletter. Tudo isto cria uma personalização para o cliente, e qualquer empresa que não o consiga fazer não conseguirá acompanhar a concorrência. Este relatório detalha o projeto feito no Pestana Hotel Group, que consistiu numa solução de Business Intelligence, mais especificamente na construção de uma base de dados do cliente com a criação de dois modelos tabulares através de ferramentas do SQL Server, um específico para clientes fidelizados e outro mais geral com informação sobre todos os clientes Pestana, e dois relatórios em Power BI que permitem a visualização da informação obtida de uma forma eficaz e simplificada. O relatório contém uma revisão de literatura que situa o leitor sobre os assuntos abordados neste projeto, um capítulo dedicado à modelação dos dados de forma a criar os modelos tabulares e outro sobre a criação dos relatórios

Relações entre cultura organizacional e Qualidade de Vida no Trabalho no setor hoteleiro

Abstract.The objective of this study is to analyze the characteristics of organizational culture as a tool for quality of working life practices in the hotel sector. A semi-structured script was used and the content analysis technique was applied in interviews with the Human Resources coordinators of two hotels in the city of Goiânia - GO. The results revealed that the level of management and operations of the hotel chains induce the people management guidelines and their applications in the employees' routine. It is concluded that the organizational culture profile most favorable to good QLW practices is the one in which artifacts and values define the systematization of work and influence the positive perception of employees about quality of working life.   Keywords: organizational culture; quality of working life; hospitality.Resumen.El objetivo de este estudio es analizar las características de la cultura organizacional como herramienta para las prácticas de calidad de vida en el trabajo en el sector hotelero. Se utilizó un guión semiestructurado y se aplicó la técnica de análisis de contenido en entrevistas con los coordinadores de Recursos Humanos de dos hoteles en la ciudad de Goiânia - GO, que son una red nacional y una red internacional. Los resultados revelaron que el nivel de gestión y operaciones de las cadenas hoteleras inducen lineamientos de gestión de personas y sus aplicaciones en la rutina de los empleados. Se concluye que el perfil de cultura organizacional más favorable a las buenas prácticas de CVT es aquel en el que los artefactos y valores definen la sistematización del trabajo e influyen en la percepción positiva de los empleados sobre la calidad de vida en el trabajo. Palabras clave: cultura organizacional; calidad de vida en el trabajo; hospitalidad.O objetivo desse estudo é analisar as características da cultura organizacional como uma ferramenta para práticas de qualidade de vida no trabalho do setor hoteleiro. Foi utilizado roteiro semiestruturado e aplicada a técnica de análise de conteúdo em entrevistas com as coordenadoras de Recursos Humanos de dois hotéis da cidade de Goiânia - GO, sendo estes uma rede nacional e uma rede internacional. Os resultados revelaram que o nível de gerenciamento e operações das redes hoteleiras induzem às diretrizes de gestão de pessoas e suas aplicações na rotina dos funcionários. Conclui-se que o perfil de cultura organizacional mais favorável às boas práticas de QVT é aquele em que os artefatos e valores definem a sistematização do trabalho e influenciam na percepção positiva dos funcionários acerca da qualidade de vida no trabalho.

A Dynamic Analysis of Tuberculosis Dissemination to Improve Control and Surveillance

Background: Detailed analysis of the dynamic interactions among biological, environmental, social, and economic factors that favour the spread of certain diseases is extremely useful for designing effective control strategies. Diseases like tuberculosis that kills somebody every 15 seconds in the world, require methods that take into account the disease dynamics to design truly efficient control and surveillance strategies. The usual and well established statistical approaches provide insights into the cause-effect relationships that favour disease transmission but they only estimate risk areas, spatial or temporal trends. Here we introduce a novel approach that allows figuring out the dynamical behaviour of the disease spreading. This information can subsequently be used to validate mathematical models of the dissemination process from which the underlying mechanisms that are responsible for this spreading could be inferred. Methodology/Principal Findings: The method presented here is based on the analysis of the spread of tuberculosis in a Brazilian endemic city during five consecutive years. The detailed analysis of the spatio-temporal correlation of the yearly geo-referenced data, using different characteristic times of the disease evolution, allowed us to trace the temporal path of the aetiological agent, to locate the sources of infection, and to characterize the dynamics of disease spreading. Consequently, the method also allowed for the identification of socio-economic factors that influence the process. Conclusions/Significance: The information obtained can contribute to more effective budget allocation, drug distribution and recruitment of human skilled resources, as well as guiding the design of vaccination programs. We propose that this novel strategy can also be applied to the evaluation of other diseases as well as other social processes.Instituto do Milenio REDE-TBConselho Nacional de Desenvolvimento Cientifico e Tecnologico (CNPq)Coordenacao de Aperfeicoamento de Pessoal de Nivel Superior (CAPES)Fundacao de Amparo a Pesquisa do Estado de Sao Paulo (FAPESP)Fundacao de Amparo a Ciencia e Tecnologia do Estado de Pernambuco (FACEPE)[0012-05.03/04]Fundacao de Amparo a Ciencia e Tecnologia do Estado de Pernambuco (FACEPE)[0203-1.05/08

Complete blood count parameters as biomarkers of retinopathy of prematurity: a Portuguese multicenter study

© The Author(s) 2023. Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/.Purpose: To evaluate complete blood count (CBC) parameters in the first week of life as predictive biomarkers for the development of retinopathy of prematurity (ROP). Methods: Multicenter, prospective, observational study of a cohort of preterm infants born with gestational age (GA) < 32 weeks or birth weight < 1500 g in eight Portuguese neonatal intensive care units. All demographic, clinical, and laboratory data from the first week of life were collected. Univariate logistic regression was used to assess risk factors for ROP and then multivariate regression was performed. Results: A total of 455 infants were included in the study. The median GA was 29.6 weeks, and the median birth weight was 1295 g. One hundred and seventy-two infants (37.8%) developed ROP. Median values of erythrocytes (p < 0.001), hemoglobin (p < 0.001), hematocrit (p < 0.001), mean corpuscular hemoglobin concentration (p < 0.001), lymphocytes (p = 0.035), and platelets (p = 0.003) of the group of infants diagnosed with ROP any stage were lower than those without ROP. Mean corpuscular volume (MCV) (p = 0.044), red blood cell distribution width (RDW) (p < 0.001), erythroblasts (p < 0.001), neutrophils (p = 0.030), neutrophils-lymphocytes ratio (p = 0.028), and basophils (p = 0.003) were higher in the ROP group. Higher values of MCV, erythroblasts, and basophils remained significantly associated with ROP after multivariate regression. Conclusion: In our cohort, the increase in erythroblasts, MCV, and basophils in the first week of life was significantly and independently associated with the development of ROP. These CBC parameters may be early predictive biomarkers for ROP.Open access funding provided by FCT|FCCN (b-on). This work was supported by the Laboratório de Genética and the Instituto de Saúde Ambiental (ISAMB) of the Faculdade de Medicina of Universidade de Lisboa and the Instituto de Investigação Científica Bento da Rocha Cabral. The writing of the manuscript was also supported by funds from Fundação para a Ciência e a Tecnologia to ISAMB (ref. UIDB/04295/2020 and UIDP/04295/2020). This work was also part of a doctoral project funding by the company CUF with a PhD grant in Medicine awarded in 2021 and by the Portuguese Society of Ophthalmology with a PhD grant awarded in 2019.info:eu-repo/semantics/publishedVersio

SARS-CoV-2 introductions and early dynamics of the epidemic in Portugal

Genomic surveillance of SARS-CoV-2 in Portugal was rapidly implemented by the National Institute of Health in the early stages of the COVID-19 epidemic, in collaboration with more than 50 laboratories distributed nationwide. Methods By applying recent phylodynamic models that allow integration of individual-based travel history, we reconstructed and characterized the spatio-temporal dynamics of SARSCoV-2 introductions and early dissemination in Portugal. Results We detected at least 277 independent SARS-CoV-2 introductions, mostly from European countries (namely the United Kingdom, Spain, France, Italy, and Switzerland), which were consistent with the countries with the highest connectivity with Portugal. Although most introductions were estimated to have occurred during early March 2020, it is likely that SARS-CoV-2 was silently circulating in Portugal throughout February, before the first cases were confirmed. Conclusions Here we conclude that the earlier implementation of measures could have minimized the number of introductions and subsequent virus expansion in Portugal. This study lays the foundation for genomic epidemiology of SARS-CoV-2 in Portugal, and highlights the need for systematic and geographically-representative genomic surveillance.We gratefully acknowledge to Sara Hill and Nuno Faria (University of Oxford) and Joshua Quick and Nick Loman (University of Birmingham) for kindly providing us with the initial sets of Artic Network primers for NGS; Rafael Mamede (MRamirez team, IMM, Lisbon) for developing and sharing a bioinformatics script for sequence curation (https://github.com/rfm-targa/BioinfUtils); Philippe Lemey (KU Leuven) for providing guidance on the implementation of the phylodynamic models; Joshua L. Cherry (National Center for Biotechnology Information, National Library of Medicine, National Institutes of Health) for providing guidance with the subsampling strategies; and all authors, originating and submitting laboratories who have contributed genome data on GISAID (https://www.gisaid.org/) on which part of this research is based. The opinions expressed in this article are those of the authors and do not reflect the view of the National Institutes of Health, the Department of Health and Human Services, or the United States government. This study is co-funded by Fundação para a Ciência e Tecnologia and Agência de Investigação Clínica e Inovação Biomédica (234_596874175) on behalf of the Research 4 COVID-19 call. Some infrastructural resources used in this study come from the GenomePT project (POCI-01-0145-FEDER-022184), supported by COMPETE 2020 - Operational Programme for Competitiveness and Internationalisation (POCI), Lisboa Portugal Regional Operational Programme (Lisboa2020), Algarve Portugal Regional Operational Programme (CRESC Algarve2020), under the PORTUGAL 2020 Partnership Agreement, through the European Regional Development Fund (ERDF), and by Fundação para a Ciência e a Tecnologia (FCT).info:eu-repo/semantics/publishedVersio

Transition of plasmodium sporozoites into liver stage-like forms is regulated by the RNA binding protein pumilio

Many eukaryotic developmental and cell fate decisions that are effected post-transcriptionally involve RNA binding proteins as regulators of translation of key mRNAs. In malaria parasites (Plasmodium spp.), the development of round, non-motile and replicating exo-erythrocytic liver stage forms from slender, motile and cell-cycle arrested sporozoites is believed to depend on environmental changes experienced during the transmission of the parasite from the mosquito vector to the vertebrate host. Here we identify a Plasmodium member of the RNA binding protein family PUF as a key regulator of this transformation. In the absence of Pumilio-2 (Puf2) sporozoites initiate EEF development inside mosquito salivary glands independently of the normal transmission-associated environmental cues. Puf2- sporozoites exhibit genome-wide transcriptional changes that result in loss of gliding motility, cell traversal ability and reduction in infectivity, and, moreover, trigger metamorphosis typical of early Plasmodium intra-hepatic development. These data demonstrate that Puf2 is a key player in regulating sporozoite developmental control, and imply that transformation of salivary gland-resident sporozoites into liver stage-like parasites is regulated by a post-transcriptional mechanism

Efeito do estresse sobre a secreção de glicocorticoides como causa da infertilidade: The effect of stress on glucocorticoid secretion as a cause of infertility

Evidências sugerem que a patogênese de desordens reprodutivas, tais como a infertilidade, pode envolver perturbações no eixo hipotalâmico relacionadas ao estresse físico ou emocional. Este estudo se refere a uma revisão bibliográfica que busca reunir informações acerca do funcionamento dos hormônios reprodutivos sob condições de estresse como possível causa psicossomática da infertilidade

Physiological responses and production of 'Syrah' vines as a function of training systems

Plant architecture and its interaction with agricultural practices and environmental constraints is determinant for grapevine canopy structure, which is related to carbon assimilation, bud fertility and fruit quality. In this context, this study evaluated the performance of field-grown 'Syrah' grapevines conducted by two management systems: Vertical Shoot Position (VSP) or a modified Geneva Double Curtain (GDC), in Pirapora, state of Minas Gerais, Brazil, during the winters of 2007 and 2008. The evaluations of leaf area, water relations and net CO2 assimilation were made at the end of the ripening period. Yield per vine and per hectare were estimated and mean berry weight and diameter, total soluble solids, pH and titratable acidity were evaluated during berry ripening. The grapevines trained in VSP had higher water status as compared to GDC, shown by differences in pre-dawn leaf water potential (&#968;pd) and stem water potential (&#968;stem). However, the CO2 assimilation was similar in both training systems. Fruit exposure was higher in VSP than in GDC, which contributed to increasing berry temperature. At harvest, the berries in GDC reached values near to 23 ºBrix whereas berries in VSP showed values near 21 ºBrix

Dependência psicológica de Benzodiazepínicos: Psychological dependence on Benzodiazepines

O crescente&nbsp;aumento do seu uso&nbsp;no&nbsp;começo&nbsp;do século XXI, os ansiolíticos&nbsp;vêm&nbsp;se tornando a&nbsp;“porta de fuga” para nova e&nbsp;também&nbsp;velha geração. Geração&nbsp;essa,&nbsp;que cada vez mais vem&nbsp;sendo consumida&nbsp;por distúrbios de ansiedade, insônia e quadros depressivos&nbsp;de forma exponencial. (Faculdade de Ciências Farmacêuticas de Ribeirão Preto – 2019).&nbsp;Este trabalho, avalia o uso e possível dependência psicológica dos benzodiazepínicos, a partir de um levantamento&nbsp;bibliográfico de forma&nbsp;sistemática de&nbsp;pesquisas&nbsp;dentro da literatura científica acerca do assunto.&nbsp