Escolha de indicadores para um relatório

This dissertation is aimed at helping organizations that implemented a Business Intelligence (BI) system without documenting to identify the reasons for the indicators choice either in the conception phase of the project or other. The example taken to present the methodology is a fictitious case study of an organization named BestBread. The aim of this dissertation is to demonstrate not only the necessary indicators in a report but also to describe why they are needed through a business goal representation. This dissertation approach focus mainly in using two methodologies, a simplified notation of the Business Intelligence model (BIM) and a systematic approach that aims to justify BI indicators through modelling report goals. This approach provides guidance to organizations that already implemented a BI tool by presenting a method to compare intuitive and systematic selection of indicators with the BI system existing indicators. The approach is applicable to define in a report its significant indicators. The steps needed to be executed are the following: 1- Model business goals; 2- Select indicators through an intuitive perspective; 3- Verify the indicators existence identified in the intuitive perspective; 4- Select indicators through a systematic perspective; 5- Verify the indicators existence identified in the systematic perspective; 6- Make a global comparison. The dissertation approach allowed an easier way to identify and explain the purpose of indicators to be used in a report. Also, the methodology presented could help the BI deployment phase to be quicker since users would be able to visualise through the representations the evaluation that the indicators could evoke in their business goals. Therefore, it could improve the use of the BI tool, its acceptance and maybe even users’ satisfaction with the tool.

Predição precoce de risco de Pré-eclâmpsia na doença hipertensiva e diabetes na gravidez: Papel de fatores angiogénicos

RESUMO: A pré-eclâmpsia tem elevada morbi-mortalidade materna e perinatal. A sua etiologia multi-fatorial tem sido objeto de investigação, não sendo ainda totalmente conhecida. Não se conhece também a razão da diferente suscetibilidade individual e das diferentes expressões da doença. A hipertensão crónica e a diabetes são fatores de risco reconhecidos, e o adiamento da maternidade contribui para que estas duas patologias sejam atualmente mais prevalentes entre as mulheres grávidas. Uma vez que o seu quadro fisiopatológico precede em meses o quadro clínico, tem-se investigado a possibilidade de serem encontrados marcadores precoces e indicadores de risco. Em Portugal, os estudos relativos à hipertensão na gravidez são escassos, bem como a investigação sobre fatores de risco e marcadores para a mesma. No sentido de avaliar possíveis marcadores de risco para o desenvolvimento de préeclâmpsia ou complicações hipertensivas foi colhida, para esta dissertação, uma amostra de 1215 mulheres que frequentaram a consulta de Hipertensão ou de Diabetes na gravidez de um centro terciário, entre 2004 e 2013. Optou-se pela realização de três estudos independentes, abrangendo os dois primeiros um leque temporal de 9 e de 2 anos respetivamente. O primeiro, centrado na hipertensão, pesquisou, em 521 mulheres com hipertensão na presente ou em anterior gravidez, fatores de risco capazes de influenciar a progressão para pré-eclâmpsia. O segundo, direcionado para a diabetes gestacional, considerou uma amostra de 334 grávidas, parte das quais tinha também hipertensão crónica e procurou identificar fatores que contribuíram para o aparecimento de complicações hipertensivas. O terceiro estudo, realizado em 2012 e 2013, em três coortes de grávidas com hipertensão crónica, com diabetes gestacional, e sem estas patologias - procurou avaliar no 1º trimestre o comportamento de dois marcadores placentares obtidos no 1º trimestre - proteína plasmática A associada à gravidez (PAPP-A) e o fator de crescimento placentar (PlGF) - e o seu papel, quer como bio-marcadores isolados, quer em associação aos fatores de risco encontrados nos anteriores estudos, na construção de um modelo preditivo de préeclâmpsia. No primeiro estudo, a nuliparidade, a hipertensão gestacional, a fluxometria das artérias uterinas com IP superiores ao P95 entre as 20-22 semanas e a existência de restrição de crescimento fetal, foram os fatores que contribuíram para a construção de um modelo preditivo de pré-eclâmpsia. No segundo estudo, a coexistência de diabetes e hipertensão crónica agravou o prognóstico, associando-se as complicações hipertensivas à multiparidade, obesidade, idade materna e etnia negra. No terceiro estudo verificou-se uma redução da PlGf e da PAPP-A no 1º trimestre nas duas primeiras coortes, comparativamente à coorte sem patologia; na análise separada de cada coorte, quando se verificaram complicações hipertensivas ou pré-eclâmpsia, as concentrações de PlGf e PAPP-A também foram inferiores. Contudo, na elaboração de um modelo preditivo de pré-eclâmpsia, em conjunto com marcadores encontrados, apenas a PlGf pode ser integrada no modelo preditivo, o que se verificou na coorte com hipertensão crónica. Os marcadores bioquímicos em estudo tiveram valores inferiores nas coortes com patologia hipertensiva, demonstrando uma deficiente produção destas proteínas placentares nestas situações, podendo ser importante a sua pesquisa. Contudo, neste estudo, apenas na coorte de hipertensão crónica a PlGf teve participação como fator de risco, na construção de um modelo preditivo de pré-eclâmpsia.--------------------------------------------------------------------------------------------------ABSTRACT: Preeclampsia is associated with a great maternal and perinatal morbimortality. Its multifactorial etiology has been under investigation and is still insufficiently understood. The reason why there are differences in individual susceptibility and differences in expressions of the disease is still unknown. Chronic hypertension and diabetes are known risk factors for preeclampsia and maternity delay contributes to the great prevalence of these pathologies among pregnant women. As the physiopathological signs antedate by months the clinical course of the disease, early risk factors and biological markers are object of clinical research. In Portugal, scarce clinical studies were devoted to hypertension in pregnancy and to risk factors and markers of this pathology. This dissertation inquires 1215 pregnant women who were treated for hypertension or diabetes in a tertiary care center between 2004 and 2013, in order to find risk markers for hypertensive complications or preeclampsia. We conducted three independent studies for this purpose. In the first one we investigated which risk factors could influence the progression to preeclampsia in 521 pregnant women with present or past history of hypertension. The second one was conducted to find what factors were associated to hypertensive complications, with a sample of 334 pregnant women with gestational diabetes, some also with chronic hypertension, addressing the identification of the factors contributing to hypertensive complications. The third study was conducted between 2012 and 2013 with three cohorts of pregnant women, with chronic hypertension, gestational diabetes, and in the third one, pregnant women had a low risk pregnancy. The objective of the study was to evaluate the behavior of two placental markers – PAPP-A and PlGf – obtained in the first trimester, and the role of these markers as isolated biomarkers or in association with other risk factors, in order to define a predictive model of early preeclampsia. In the first study, nuliparity, gestational hypertension, uterine arteries doppler with PI above P95 between 20-22 weeks of gestation and the presence of fetal growth restriction were the markers involved in a predictive model for preeclampsia. In the second study the cohort with the coexistence of diabetes and hypertension had registered worse result and hypertensive complications were associated to multiparity, obesity, maternal age and black ethnicity. In the third study there was a reduction of the PlGf and a PAPP-A concentration for the first trimester in the two first cohorts comparatively to the low risk cohort; the separate analysis of each cohort showed that plGf and PAPP-A concentrations were reduced when hypertensive complications appeared. However, when trying to find a preeclampsia predictive model, only plGf gave significant results for being considered in the model and this was only possible in the chronic hypertension cohort. The biochemical markers investigated in this study were reduced in the cohorts when high blood pressure complications occurred, showing a defective production of these placenta proteins, and suggesting that they should be investigated as first trimester biomarkers. Nevertheless, for this research, in the cohort of chronic hypertension only PlGf had a significant result, when multivariate analysis of all the risk factors was considered for the construction of a preeclampsia predictive model.