An internal analysis of Amorim Turismo’s operations regarding food and beverage with a focus on operational efficiency and quality of service

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

Business Analytics

Atualmente o setor segurador enfrenta diversas dificuldades, não só pela crise económica internacional e pelo mercado cada vez mais competitivo, como também pelas exigências impostas pela entidade reguladora - Instituto de Seguros de Portugal (ISP). Desta forma, apenas as seguradoras que consigam monitorizar os seus riscos, adequando os prémios praticados, conseguirão sobreviver. A forma de o fazer é através de uma adequada tarifação. Neste contexto de elevada instabilidade, as plataformas de Business Intelligence (BI) têm vindo a desempenhar um papel cada vez mais importante no processo de tomada de decisão, nomeadamente, o Business Analytics (BA), que proporciona os métodos e ferramentas de análise. O objetivo deste projeto é desenvolver um protótipo de solução de BA que forneça os inputs necessários ao processo de tomada de decisão, através da monitorização da tarifa em vigor e da simulação do impacto da introdução de uma nova tarifa. A solução desenvolvida apenas abrange a tarifa de responsabilidade civil automóvel (RCA). Ao nível das ferramentas analíticas, o foco foi a análise visual, nomeadamente a construção de dashboards, onde se inclui a análise de sensibilidade ou what-if analysis (WIF). A motivação para o desenvolvimento deste projeto foi a constatação de inexistência de soluções para este fim nos ambientes profissionais em que estive envolvido.

The effect of key process operational conditions on enhanced biological phosphorus removal from wastewater

Enhanced biological phosphorus removal (EBPR) is the most economic and sustainable option used in wastewater treatment plants (WWTPs) for phosphorus removal. In this process it is important to control the competition between polyphosphate accumulating organisms (PAOs) and glycogen accumulating organisms (GAOs), since EBPR deterioration or failure can be related with the proliferation of GAOs over PAOs. This thesis is focused on the effect of operational conditions (volatile fatty acid (VFA) composition, dissolved oxygen (DO) concentration and organic carbon loading) on PAO and GAO metabolism. The knowledge about the effect of these operational conditions on EBPR metabolism is very important, since they represent key factors that impact WWTPs performance and sustainability. Substrate competition between the anaerobic uptake of acetate and propionate (the main VFAs present in WWTPs) was shown in this work to be a relevant factor affecting PAO metabolism, and a metabolic model was developed that successfully describes this effect. Interestingly, the aerobic metabolism of PAOs was not affected by different VFA compositions, since the aerobic kinetic parameters for phosphorus uptake, polyhydroxyalkanoates (PHAs) degradation and glycogen production were relatively independent of acetate or propionate concentration. This is very relevant for WWTPs, since it will simplify the calibration procedure for metabolic models, facilitating their use for full-scale systems. The DO concentration and aerobic hydraulic retention time (HRT) affected the PAO-GAO competition, where low DO levels or lower aerobic HRT was more favourable for PAOs than GAOs. Indeed, the oxygen affinity coefficient was significantly higher for GAOs than PAOs, showing that PAOs were far superior at scavenging for the often limited oxygen levels in WWTPs. The operation of WWTPs with low aeration is of high importance for full-scale systems, since it decreases the energetic costs and can potentially improve WWTP sustainability. Extended periods of low organic carbon load, which are the most common conditions that exist in full-scale WWTPs, also had an impact on PAO and GAO activity. GAOs exhibited a substantially higher biomass decay rate as compared to PAOs under these conditions, which revealed a higher survival capacity for PAOs, representing an advantage for PAOs in EBPR processes. This superior survival capacity of PAOs under conditions more closely resembling a full-scale environment was linked with their ability to maintain a residual level of PHA reserves for longer than GAOs, providing them with an effective energy source for aerobic maintenance processes. Overall, this work shows that each of these key operational conditions play an important role in the PAO-GAO competition and should be considered in WWTP models in order to improve EBPR processes.

Epidemiological, clinical, and operational aspects of leprosy patients assisted at a referral service in the state of Maranhão, Brazil

INTRODUCTION: Leprosy is an infectious disease caused by Mycobacterium leprae. The aim of this study was to describe the epidemiological, clinical, and operational aspects of leprosy carriers. METHODS: A cross-sectional study leprosy patients assisted in São Luis, MA, was performed. RESULTS: Of the 85 cases analyzed, 51.7% were male participants, and 60% were brown. Concerning the age, 54.8% of women were between 35 and 49 years, and 57.6% of men were between 20 and 34 years. Lepromatous leprosy was found in 42.3% of cases, and the multibacillary form was found in 72.9%. The skin smear was positive in 42.3%. The occurrence of reaction was found in 43.5% of cases, and 83.5% had no Bacillus Calmette-Guérin scar. Leprosy in the family was reported by 44.7% of the patients. Most of the individuals (96.4%) lived in houses made of brick with more than three rooms (72.6%) and two persons per room (65.1%). Concerning the level of education, 41.4% of women and 34.1% of men had more than one to three years of education. The most evaluated age group in the beginning of the treatment was that of 35 to 49 years with a Grade 0 incapability (64.5%), and that in the end was the age group of 20 to 34 (29.9%) with Grade 0, 30.7% Grade 1, and 11.5% Grade 2. CONCLUSIONS: The frequency of multibacillary forms found in this study and the cases in family members point out delayed diagnoses. Thus, early diagnosis and appropriate treatment are important in decreasing the outcome of disabilities.

Indoor location-based analytics systems: Portuguese market compettive assessment and entry procing strategy of BIPs' technology in Sonae Sierra Shopping malls stores

This project attempts to provide an in-depth competitive assessment of the Portuguese indoor location-based analytics market, and to elaborate an entry-pricing strategy for Business Intelligence Positioning System (BIPS) implementation in Portuguese shopping centre stores. The role of industry forces and company’s organizational resources platform to sustain company’s competitive advantage was explored. A customer value-based pricing approach was adopted to assess BIPS value to retailers and maximize Sonae Sierra profitability. The exploratory quantitative research found that there is a market opportunity to explore every store area types with tailored proposals, and to set higher-than-tested membership fees to allow a rapid ROI, concluding there are propitious conditions for Sierra to succeed in BIPS store’s business model in Portugal.

Sustainable urban planning: parameters to the operational process

In modern society, energy consumption and respect for the environment have become essential aspects of urban planning. The rising demand for alternative sources of energy, coupled with the decline in the construction sector and material usage, gives the idea that the thinking on modern cities, where attention is given to reduced energy consumption, savings, waste recycling and respect for the surrounding environment, is being put into practice. If we examine development of the city over recent centuries, by means of the theories of the most famous and influential urban planners, it is possible to identify the major problems caused by this type of planning. For this reason, in recent urban planning the use of systems of indicators that evaluate and certify land environmentally and energetically guides the master plan toward a more efficient city model. In addition the indicators are targeted on key factors determined by the commissioner or the opportunities the territory itself provides. Due the complexity of the environmental mechanics, the process of design and urban planning has become a challenging issue. The introduction of the indicators system has made it possible to register the life of the process, with a spiral route that allows the design itself to be refined. The aim of this study, built around the creation of a system of urban sustainability indicators that will evaluate highly eco-friendly cities, is to develop a certification system for cities or portions of them. The system will be upgradeable and objective, will employ real data and will be concerned with energy production and consumption.

A data-driven analytics approach in the study of pneumonia’s fatalities

As huge amounts of data become available in organizations and society, specific data analytics skills and techniques are needed to explore this data and extract from it useful patterns, tendencies, models or other useful knowledge, which could be used to support the decision-making process, to define new strategies or to understand what is happening in a specific field. Only with a deep understanding of a phenomenon it is possible to fight it. In this paper, a data-driven analytics approach is used for the analysis of the increasing incidence of fatalities by pneumonia in the Portuguese population, characterizing the disease and its incidence in terms of fatalities, knowledge that can be used to define appropriate strategies that can aim to reduce this phenomenon, which has increased more than 65% in a decade.

Detection of road accident accumulation zones with a visual analytics approach

Nowadays, road accidents are a major public health problem, which increase is forecasted if road safety is not treated properly, dying about 1.2 million people every year around the globe. In 2012, Portugal recorded 573 fatalities in road accidents, on site, revealing the largest decreasing of the European Union for 2011, along with Denmark. Beyond the impact caused by fatalities, it was calculated that the economic and social costs of road accidents weighted about 1.17% of the Portuguese gross domestic product in 2010. Visual Analytics allows the combination of data analysis techniques with interactive visualizations, which facilitates the process of knowledge discovery in sets of large and complex data, while the Geovisual Analytics facilitates the exploration of space-time data through maps with different variables and parameters that are under analysis. In Portugal, the identification of road accident accumulation zones, in this work named black spots, has been restricted to annual fixed windows. In this work, it is presented a dynamic approach based on Visual Analytics techniques that is able to identify the displacement of black spots on sliding windows of 12 months. Moreover, with the use of different parameterizations in the formula usually used to detect black spots, it is possible to identify zones that are almost becoming black spots. Through the proposed visualizations, the study and identification of countermeasures to this social and economic problem can gain new grounds and thus the decision- making process is supported and improved.

Data analytics: abordagem para visualização da informação

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

Malolactic fermentation in winemaking: evaluation of operational parameters

Dissertação de mestrado em Bioengenharia

The appraisal of anaerobic digestion in Ireland to develop improved designs and operational practice

Mesophilic Anaerobic Digestion treating sewage sludge was investigated at five full-scale sewage treatment plants in Ireland. The anaerobic digestion plants are compared and evaluated in terms of design, equipment, operation, monitoring and management. All digesters are cylindrical, gas mixed and heated Continuously Stirred Tank Reactors (CSTR), varying in size from 130m3 to 800m3. Heat exchanger systems heat all digesters. Three plants reported difficulties with the heating systems ranging from blockages to insufficient insulation and design. Exchangers were modified and replaced within one year of operation at two plants. All but one plant had Combined Heat and Power (CHP) systems installed. Parameter monitoring is a problem at all plants mainly due to a lack of staff and knowledge. The plant operators consider pH and temperature the most important parameters to be measured in terms of successful monitoring of an anaerobic digester. The short time taken and the ease at which pH and temperature can be measured may favour these parameters. Three laboratory scale pilot anaerobic digesters were operated using a variety of feeds over at 144-day period. Two of the pilots were unmixed and the third was mechanically mixed. As expected the unmixed reactors removed more COD by retention of solids in the digesters but also produced greater quantities of biogas than the mixed digester, especially when low solids feed such as whey was used. The mixed digester broke down more solids due to the superior contact between the substrate and the biomass. All three reactors showed good performance results for whey and sewage solids. Scum formation occurred giving operational problems for mixed and unmixed reactors when cattle slurry was used as the main feed source. The pilot test was also used to investigate which parameters were the best indicators of process instability. These trials clearly indicated that total Volatile Fatty Acid (VFA) concentrations was the best parameter to show signs of early process imbalance, while methane composition in the biogas was good to indicate possible nutrient deficiencies in the feed and oxygen shocks. pH was found to be a good process parameter only if the wastewater being treated produced low bicarbonate alkalinities during treatment.

Device-specific weighted T-score for two quantitative ultrasounds: operational propositions for the management of osteoporosis for 65 years and older women in Switzerland.

The World Health Organization (WHO) criteria for the diagnosis of osteoporosis are mainly applicable for dual X-ray absorptiometry (DXA) measurements at the spine and hip levels. There is a growing demand for cheaper devices, free of ionizing radiation such as promising quantitative ultrasound (QUS). In common with many other countries, QUS measurements are increasingly used in Switzerland without adequate clinical guidelines. The T-score approach developed for DXA cannot be applied to QUS, although well-conducted prospective studies have shown that ultrasound could be a valuable predictor of fracture risk. As a consequence, an expert committee named the Swiss Quality Assurance Project (SQAP, for which the main mission is the establishment of quality assurance procedures for DXA and QUS in Switzerland) was mandated by the Swiss Association Against Osteoporosis (ASCO) in 2000 to propose operational clinical recommendations for the use of QUS in the management of osteoporosis for two QUS devices sold in Switzerland. Device-specific weighted "T-score" based on the risk of osteoporotic hip fractures as well as on the prediction of DXA osteoporosis at the hip, according to the WHO definition of osteoporosis, were calculated for the Achilles (Lunar, General Electric, Madison, Wis.) and Sahara (Hologic, Waltham, Mass.) ultrasound devices. Several studies (totaling a few thousand subjects) were used to calculate age-adjusted odd ratios (OR) and area under the receiver operating curve (AUC) for the prediction of osteoporotic fracture (taking into account a weighting score depending on the design of the study involved in the calculation). The ORs were 2.4 (1.9-3.2) and AUC 0.72 (0.66-0.77), respectively, for the Achilles, and 2.3 (1.7-3.1) and 0.75 (0.68-0.82), respectively, for the Sahara device. To translate risk estimates into thresholds for clinical application, 90% sensitivity was used to define low fracture and low osteoporosis risk, and a specificity of 80% was used to define subjects as being at high risk of fracture or having osteoporosis at the hip. From the combination of the fracture model with the hip DXA osteoporotic model, we found a T-score threshold of -1.2 and -2.5 for the stiffness (Achilles) determining, respectively, the low- and high-risk subjects. Similarly, we found a T-score at -1.0 and -2.2 for the QUI index (Sahara). Then a screening strategy combining QUS, DXA, and clinical factors for the identification of women needing treatment was proposed. The application of this approach will help to minimize the inappropriate use of QUS from which the whole field currently suffers.

Inversion Analytics: Análisis sobre rentabilidad de inversiones mediante VAN y TIR

Inversion Analytics es una herramienta para facilitar el análisis en inversiones que se planteen en pequeñas, medianas y grandes empresas, en el que se plasmará toda la información necesaria para determinar los valores que entran en juego en la inversión. La aplicación realiza esta función mediante el cálculo de VAN (Valor Actual Neto) y TIR (Tasa Interna de Rentabilidad) de una inversión determinada, a partir de la información introducida por el usuario y teniendo en cuenta los distintos métodos de amortización de la inversión inicial, así como los distintos enfoques o supuestos en el que clasificaremos el horizonte temporal de la misma.