Desenho e implementação de um data warehouse para a empresa AdClick

Esta dissertação incide sobre a problemática da construção de um data warehouse para a empresa AdClick que opera na área de marketing digital. O marketing digital é um tipo de marketing que utiliza os meios de comunicação digital, com a mesma finalidade do método tradicional que se traduz na divulgação de bens, negócios e serviços e a angariação de novos clientes. Existem diversas estratégias de marketing digital tendo em vista atingir tais objetivos, destacando-se o tráfego orgânico e tráfego pago. Onde o tráfego orgânico é caracterizado pelo desenvolvimento de ações de marketing que não envolvem quaisquer custos inerentes à divulgação e/ou angariação de potenciais clientes. Por sua vez o tráfego pago manifesta-se pela necessidade de investimento em campanhas capazes de impulsionar e atrair novos clientes. Inicialmente é feita uma abordagem do estado da arte sobre business intelligence e data warehousing, e apresentadas as suas principais vantagens as empresas. Os sistemas business intelligence são necessários, porque atualmente as empresas detêm elevados volumes de dados ricos em informação, que só serão devidamente explorados fazendo uso das potencialidades destes sistemas. Nesse sentido, o primeiro passo no desenvolvimento de um sistema business intelligence é concentrar todos os dados num sistema único integrado e capaz de dar apoio na tomada de decisões. É então aqui que encontramos a construção do data warehouse como o sistema único e ideal para este tipo de requisitos. Nesta dissertação foi elaborado o levantamento das fontes de dados que irão abastecer o data warehouse e iniciada a contextualização dos processos de negócio existentes na empresa. Após este momento deu-se início à construção do data warehouse, criação das dimensões e tabelas de factos e definição dos processos de extração e carregamento dos dados para o data warehouse. Assim como a criação das diversas views. Relativamente ao impacto que esta dissertação atingiu destacam-se as diversas vantagem a nível empresarial que a empresa parceira neste trabalho retira com a implementação do data warehouse e os processos de ETL para carregamento de todas as fontes de informação. Sendo que algumas vantagens são a centralização da informação, mais flexibilidade para os gestores na forma como acedem à informação. O tratamento dos dados de forma a ser possível a extração de informação a partir dos mesmos.

The impact of driving styles on fuel consumption: a data-warehouse-and-data-mining-based discovery process

This paper discusses the results of applied research on the eco-driving domain based on a huge data set produced from a fleet of Lisbon's public transportation buses for a three-year period. This data set is based on events automatically extracted from the control area network bus and enriched with GPS coordinates, weather conditions, and road information. We apply online analytical processing (OLAP) and knowledge discovery (KD) techniques to deal with the high volume of this data set and to determine the major factors that influence the average fuel consumption, and then classify the drivers involved according to their driving efficiency. Consequently, we identify the most appropriate driving practices and styles. Our findings show that introducing simple practices, such as optimal clutch, engine rotation, and engine running in idle, can reduce fuel consumption on average from 3 to 5l/100 km, meaning a saving of 30 l per bus on one day. These findings have been strongly considered in the drivers' training sessions.

Join The Moment Transitários, S.A: relatório de estágio no departamento de operações

Apresentado ao Instituto de Contabilidade e Administração do Porto para a obtenção do grau de Mestre em Empreendedorismo e Internacionalização, sob orientação da Doutora Maria Clara Pinto Ribeiro

Resultados da Angioplastia Primária num Centro de Referência. Evolução Intra-Hospitalar

INTRODUCTION: Primary angioplasty is accepted as the preferred treatment for acute myocardial infarction in the first 12 hours. However, outcomes depend to a large extent on the volume of activity and experience of the center. Continuous monitoring of methods and results obtained is therefore crucial to quality control. OBJECTIVE: To describe the demographic, clinical and angiographic characteristics as well as in-hospital outcomes of patients undergoing primary PCI in a high-volume Portuguese center. We also aimed to identify variables associated with in-hospital mortality in this population. METHODS: This was a retrospective registry of consecutive primary PCIs performed at Santa Marta Hospital between January 2001 and August 2007. Demographic, clinical, and angiographic characteristics and in-hospital outcomes were analyzed. Independent predictors of in-hospital mortality were identified by multivariate logistic regression analysis. RESULTS: A total of 1157 patients were identified, mean age 61+/-12 years, 76% male. Mean pain-to-balloon time was 7.6 hours and primary angiographic success was 88%. Overall in-hospital mortality was 6.9%, or 5.5% if patients presenting in cardiogenic shock were excluded from the analysis. Previous history of heart failure, cardiogenic shock on admission, invasive ventilatory support, major hemorrhage, and age over 75 years were found to be associated with increased risk of in-hospital death. Conclusions: In this center primary PCI is effective and safe. Angiographic success rates and in-hospital mortality and morbidity are similar to other international registries. Patients at increased risk for adverse outcome can be identified by simple clinical characteristics such as advanced age, cardiogenic shock on admission, mechanical ventilation and major hemorrhage during hospitalization.

Intervenção Percutânea Urgente no Enfarte Agudo do Miocárdio por Lesão do Tronco Comum

BACKGROUND: ST-elevation myocardial infarction (STEMI) with the culprit lesion in the left main artery is a rare cardiac emergency with a poor prognosis. OBJECTIVE: Review and prognosis evaluation of primary percutaneous coronary intervention (PCI) performed in the setting of STEMI with left main occlusion in a single high-volume center. METHODS: Of the 483 primary or rescue PCIs performed and followed in our hospital during a 24-month period (August 2004 to July 2006), we retrospectively evaluated those involving left main procedures and analyzed in-hospital mortality and major cardiac events (MACE) in a 12-month follow-up. We found nine patients, age 68 +/- 9 years, five male, seven with multivessel disease and two with isolated left main disease. Rescue PCI was performed in three patients and primary PCI in the others. RESULTS: Seven patients presented in cardiogenic shock and two were classified in Killip class II on admission. Inotropic drugs, intra-aortic balloon pump and abciximab were used in eight patients. Drug-eluting stents were used in six patients, bare-metal stents in two, and isolated balloon angioplasty in one. Five patients (55%) died in the hospital and the four discharged home (two of them aged 81 and 82 years) were still alive and free from MACE at 12-month follow-up. CONCLUSIONS: Clinical presentation of STEMI with the culprit lesion in the left main artery was very severe. During PCI, drug-eluting stents, intra-aortic balloon pump and abciximab were used in almost all patients. This entity had a high mortality rate even though primary PCI was performed. Those who survived had a good mid-term prognosis.

Revalorization of spent coffee residues by a direct agronomic approach

Spent coffee grounds (SCG) represent a high-volume food waste worldwide, and several reuse approaches have been attempted. Herein, a greenhouse field experiment was carried out by cultivating Batavia lettuce with 5%, 10%, 15%, 20% and 30% (v/v) espresso SCG directly composted in the soil. Healthy vegetables were obtained for all treatments, without yield loss for up to 10% SCG. A progressive increment of green color intensity with increasing SCG content was observed, corroborated by the increase of their photosynthetic pigments (chlorophylls and carotenoids). Furthermore, total ascorbic acid and tocopherols showed statistical significant increases (p < 0.001) between control and all tested groups. Marked variations of nutritionally relevant minerals, particularly potassium, phosphorous and sodium were also revealed at higher percentage treatments (20% and 30%). This approach constitutes a clean, direct, simple and cost-effective measure to produce value-added vegetables, while reducing food waste disposal.

The Hybrid Approach for Palliation of Hypoplastic Left Heart Syndrome: Intermediate Results of a Single-Center Experience

INTRODUCTION: Hypoplastic left heart syndrome (HLHS) is a major cause of cardiac death during the first week of life. The hybrid approach is a reliable, reproducible treatment option for patients with HLHS. Herein we report our results using this approach, focusing on its efficacy, safety and late outcome. METHODS: We reviewed prospectively collected data on patients treated for HLHS using a hybrid approach between July 2007 and September 2014. RESULTS: Nine patients had a stage 1 hybrid procedure, with seven undergoing a comprehensive stage 2 procedure. One patient completed the Fontan procedure. Five patients underwent balloon atrial septostomy after the hybrid procedure; in three patients, a stent was placed across the atrial septum. There were three deaths: two early after the hybrid procedure and one early after stage two palliation. Overall survival was 66%. CONCLUSIONS: In our single-center series, the hybrid approach for HLHS yields intermediate results comparable to those of the Norwood strategy. The existence of dedicated teams for the diagnosis and management of these patients, preferably in high-volume centers, is of major importance in this condition.

Improving contact center cost efficiency and customer experience in a retail company

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Management from the NOVA – School of Business and Economics

Structure-property relationships in polymer nanocomposites

Tese de Doutoramento em Ciência e Engenharia de Polímeros e Compósitos

A comunicação do compromisso para com o desenvolvimento sustentável, das organizações portuguesas certificadas em qualidade, ambiente e segurança

Dissertação de mestrado em Engenharia Industrial (área de especialização em Qualidade, Segurança e Manutenção)

Application of multivariate statistical process control to fuel cell manufacturing

Univariate statistical control charts, such as the Shewhart chart, do not satisfy the requirements for process monitoring on a high volume automated fuel cell manufacturing line. This is because of the number of variables that require monitoring. The risk of elevated false alarms, due to the nature of the process being high volume, can present problems if univariate methods are used. Multivariate statistical methods are discussed as an alternative for process monitoring and control. The research presented is conducted on a manufacturing line which evaluates the performance of a fuel cell. It has three stages of production assembly that contribute to the final end product performance. The product performance is assessed by power and energy measurements, taken at various time points throughout the discharge testing of the fuel cell. The literature review performed on these multivariate techniques are evaluated using individual and batch observations. Modern techniques using multivariate control charts on Hotellings T2 are compared to other multivariate methods, such as Principal Components Analysis (PCA). The latter, PCA, was identified as the most suitable method. Control charts such as, scores, T2 and DModX charts, are constructed from the PCA model. Diagnostic procedures, using Contribution plots, for out of control points that are detected using these control charts, are also discussed. These plots enable the investigator to perform root cause analysis. Multivariate batch techniques are compared to individual observations typically seen on continuous processes. Recommendations, for the introduction of multivariate techniques that would be appropriate for most high volume processes, are also covered.

Efficacy of Patient Selection for Diagnostic Coronary Angiography in Suspected Coronary Artery Disease

AbstractBackground:Guidelines recommend that in suspected stable coronary artery disease (CAD), a clinical (non-invasive) evaluation should be performed before coronary angiography.Objective:We assessed the efficacy of patient selection for coronary angiography in suspected stable CAD.Methods:We prospectively selected consecutive patients without known CAD, referred to a high-volume tertiary center. Demographic characteristics, risk factors, symptoms and non-invasive test results were correlated to the presence of obstructive CAD. We estimated the CAD probability based on available clinical data and the incremental diagnostic value of previous non-invasive tests.Results:A total of 830 patients were included; median age was 61 years, 49.3% were males, 81% had hypertension and 35.5% were diabetics. Non-invasive tests were performed in 64.8% of the patients. At coronary angiography, 23.8% of the patients had obstructive CAD. The independent predictors for obstructive CAD were: male gender (odds ratio [OR], 3.95; confidence interval [CI] 95%, 2.70 - 5.77), age (OR for 5 years increment, 1.15; CI 95%, 1.06 - 1.26), diabetes (OR, 2.01; CI 95%, 1.40 - 2.90), dyslipidemia (OR, 2.02; CI 95%, 1.32 - 3.07), typical angina (OR, 2.92; CI 95%, 1.77 - 4.83) and previous non-invasive test (OR 1.54; CI 95% 1.05 - 2.27).Conclusions:In this study, less than a quarter of the patients referred for coronary angiography with suspected CAD had the diagnosis confirmed. A better clinical and non-invasive assessment is necessary, to improve the efficacy of patient selection for coronary angiography.

Factores de rendimiento en aplicaciones híbridas

En el entorno actual, diversas ramas de las ciencias, tienen la necesidad de auxiliarse de la computación de altas prestaciones para la obtención de resultados a relativamente corto plazo. Ello es debido fundamentalmente, al alto volumen de información que necesita ser procesada y también al costo computacional que demandan dichos cálculos. El beneficio al realizar este procesamiento de manera distribuida y paralela, logra acortar los tiempos de espera en la obtención de los resultados y de esta forma posibilita una toma decisiones con mayor anticipación. Para soportar ello, existen fundamentalmente dos modelos de programación ampliamente extendidos: el modelo de paso de mensajes a través de librerías basadas en el estándar MPI, y el de memoria compartida con la utilización de OpenMP. Las aplicaciones híbridas son aquellas que combinan ambos modelos con el fin de aprovechar en cada caso, las potencialidades específicas del paralelismo en cada uno. Lamentablemente, la práctica ha demostrado que la utilización de esta combinación de modelos, no garantiza necesariamente una mejoría en el comportamiento de las aplicaciones. Por lo tanto, un análisis de los factores que influyen en el rendimiento de las mismas, nos beneficiaría a la hora de implementarlas pero también, sería un primer paso con el fin de llegar a predecir su comportamiento. Adicionalmente, supondría una vía para determinar que parámetros de la aplicación modificar con el fin de mejorar su rendimiento. En el trabajo actual nos proponemos definir una metodología para la identificación de factores de rendimiento en aplicaciones híbridas y en congruencia, la identificación de algunos factores que influyen en el rendimiento de las mismas.

The Swiss cohort of elderly patients with venous thromboembolism (SWITCO65+): rationale and methodology.

Venous thromboembolism (VTE) is common and has a high impact on morbidity, mortality, and costs of care. Although most of the patients with VTE are aged ≥65 years, there is little data about the medical outcomes in the elderly with VTE. The Swiss Cohort of Elderly Patients with VTE (SWITCO65+) is a prospective multicenter cohort study of in- and outpatients aged ≥65 years with acute VTE from all five Swiss university and four high-volume non-university hospitals. The goal is to examine which clinical and biological factors and processes of care drive short- and long-term medical outcomes, health-related quality of life, and medical resource utilization in elderly patients with acute VTE. The cohort also includes a large biobank with biological material from each participant. From September 2009 to March 2012, 1,863 elderly patients with VTE were screened and 1003 (53.8 %) were enrolled in the cohort. Overall, 51.7 % of patients were aged ≥75 years and 52.7 % were men. By October 16, 2012, after an average follow-up time of 512 days, 799 (79.7 %) patients were still actively participating. SWITCO65+ is a unique opportunity to study short- and long-term outcomes in elderly patients with VTE. The Steering Committee encourages national and international collaborative research projects related to SWITCO65+, including sharing anonymized data and biological samples.

Introduction of an automated system for the diagnosis and quantification of hepatitis B and hepatitis C viruses.

Hepatitis B virus (HBV) and Hepatitis C virus (HCV) infections pose major public health problems because of their prevalence worldwide. Consequently, screening for these infections is an important part of routine laboratory activity. Serological and molecular markers are key elements in diagnosis, prognosis and treatment monitoring for HBV and HCV infections. Today, automated chemiluminescence immunoassay (CLIA) analyzers are widely used for virological diagnosis, particularly in high-volume clinical laboratories. Molecular biology techniques are routinely used to detect and quantify viral genomes as well as to analyze their sequence; in order to determine their genotype and detect resistance to antiviral drugs. Real-time PCR, which provides high sensitivity and a broad dynamic range, has gradually replaced other signal and target amplification technologies for the quantification and detection of nucleic acid. The next-generation DNA sequencing techniques are still restricted to research laboratories.The serological and molecular marker methods available for HBV and HCV are discussed in this article, along with their utility and limitations for use in Chronic Hepatitis B (CHB) diagnosis and monitoring.