Análise de desempenho de vendas em telecomunicações utilizando técnicas de mineração de dados

Nowadays, telecommunications is one of the most dynamic and strategic areas in the world. Organizations are always seeking to find new management practices within an ever increasing competitive environment where resources are getting scarce. In this scenario, data obtained from business and corporate processes have even greater importance, although this data is not yet adequately explored. Knowledge Discovery in Databases (KDD) appears then, as an option to allow the study of complex problems in different areas of management. This work proposes both a systematization of KDD activities using concepts from different methodologies, such as CRISP-DM, SEMMA and FAYYAD approaches and a study concerning the viability of multivariate regression analysis models to explain corporative telecommunications sales using performance indicators. Thus, statistical methods were outlined to analyze the effects of such indicators on the behavior of business productivity. According to business and standard statistical analysis, equations were defined and fit to their respective determination coefficients. Tests of hypotheses were also conducted on parameters with the purpose of validating the regression models. The results show that there is a relationship between these development indicators and the amount of sales

Análise dos indicadores de qualidade versus taxa de abandono utilizando método de regressão múltipla para serviço de banda larga

Telecommunication is one of the most dynamic and strategic areas in the world. Many technological innovations has modified the way information is exchanged. Information and knowledge are now shared in networks. Broadband Internet is the new way of sharing contents and information. This dissertation deals with performance indicators related to maintenance services of telecommunications networks and uses models of multivariate regression to estimate churn, which is the loss of customers to other companies. In a competitive environment, telecommunications companies have devised strategies to minimize the loss of customers. Loosing customers presents a higher cost than obtaining new ones. Corporations have plenty of data stored in a diversity of databases. Usually the data are not explored properly. This work uses the Knowledge Discovery in Databases (KDD) to establish rules and new models to explain how churn, as a dependent variable, are related to a diversity of service indicators, such as time to deploy the service (in hours), time to repair (in hours), and so on. Extraction of meaningful knowledge is, in many cases, a challenge. Models were tested and statistically analyzed. The work also shows results that allows the analysis and identification of which quality services indicators influence the churn. Actions are also proposed to solve, at least in part, this problem

Especificação e implementação de um modelo assíncrono para replicação, propagação e conciliação de bases de dados distribuídas

This graduate thesis proposes a model to asynchronously replicate heterogeneous databases. This model singularly combines -in a systematic way and in a single project -different concepts, techniques and paradigms related to the areas of database replication and management of heterogeneous databases. One of the main advantages of the replication is to allow applications to continue to process information, during time intervals when they are off the network and to trigger the database synchronization, as soon as the network connection is reestablished. Therefore, the model introduces a communication and update protocol that takes in consideration the environment of asynchronous characteristics used. As part of the work, a tool was developed in Java language, based on the model s premises in order to process, test, simulate and validate the proposed model

Psicologia e pobreza no Brasil: limites e perspectivas da produção de conhecimento e atuação do psicólogo

Poverty is a main theme in Brazil: according to official data, poverty reachs 70 million Brazilian people, and, between them, 20 million are unable to provide their basic needs. Psychology, as a welfare profession, and given its historical concerns with social actions, could not be away from this theme. Based on this, we ask: Which answers Psychology can provide, toward both the production of knowledge and the practice about social reality? The purpose of this paper is to investigate the psychological scientific production on poverty and the propositions, limits and impacts of psychological actions. We carried out a three stages documental based study analyzing Brazilian psychological literature: (1) online databases survey (312 papers identified); (2) 109 scientific abstracts accessed and coded; (3) selected 47 scientific papers read and analyzed. Results are presented in three sections: general description of the selected scientific production; characterization of the role of poverty in psychological literature; and themes presented at the papers. The academic production about the main theme (poverty) is dispersed, heterogeneous, and related to other fields of knowledge. Poverty is presented at these studies in many ways, such as: a criterium for sample design and the assessment of its psychological impacts; reports on professional experience with poor population; descriptions of this population group; relationship between poverty and others social themes; developmental and learning problems of poor children. In general, it appears that Psychology has improved the scientific production and experiences with poor population. However, it is necessary to build up theories and technical innovations and also to understand structural boundaries for professional practice with this population group

Algoritmos de agrupamento aplicados a dados de expressão gênica de câncer: um estudo comparativo

The use of clustering methods for the discovery of cancer subtypes has drawn a great deal of attention in the scientific community. While bioinformaticians have proposed new clustering methods that take advantage of characteristics of the gene expression data, the medical community has a preference for using classic clustering methods. There have been no studies thus far performing a large-scale evaluation of different clustering methods in this context. This work presents the first large-scale analysis of seven different clustering methods and four proximity measures for the analysis of 35 cancer gene expression data sets. Results reveal that the finite mixture of Gaussians, followed closely by k-means, exhibited the best performance in terms of recovering the true structure of the data sets. These methods also exhibited, on average, the smallest difference between the actual number of classes in the data sets and the best number of clusters as indicated by our validation criteria. Furthermore, hierarchical methods, which have been widely used by the medical community, exhibited a poorer recovery performance than that of the other methods evaluated. Moreover, as a stable basis for the assessment and comparison of different clustering methods for cancer gene expression data, this study provides a common group of data sets (benchmark data sets) to be shared among researchers and used for comparisons with new methods

Algoritmos de agrupamentos fuzzy intervalares e índice de validação para agrupamento de dados simbólicos do tipo intervalo

Symbolic Data Analysis (SDA) main aims to provide tools for reducing large databases to extract knowledge and provide techniques to describe the unit of such data in complex units, as such, interval or histogram. The objective of this work is to extend classical clustering methods for symbolic interval data based on interval-based distance. The main advantage of using an interval-based distance for interval-based data lies on the fact that it preserves the underlying imprecision on intervals which is usually lost when real-valued distances are applied. This work includes an approach allow existing indices to be adapted to interval context. The proposed methods with interval-based distances are compared with distances punctual existing literature through experiments with simulated data and real data interval

Cuidados de enfermagem ao paciente em pós-operatório de prostatectomia: revisão integrativa

Este estudo trata-se de revisão integrativa da literatura com objetivo de sintetizar o conhecimento produzido em artigos sobre os cuidados de enfermagem aos pacientes em pós-operatório de prostatectomia. Para seleção dos artigos foram consultadas cinco bases de dados – SCOPUS, CINAHL, PUBMED, LILACS e Cochrane – sendo incluídos dezenove artigos. Os resultados mostram estudos que se enquadram nos níveis II, IV, V, VI e VII de evidência, a maioria realizada nos Estados Unidos durante os anos de 1999 a 2011. Os cuidados de enfermagem identificados foram agrupados em seis categorias: acompanhamento psicológico, orientações pós-operatórias, tratamento da disfunção erétil, tratamento da incontinência urinária, tratamento da dor e tratamento da hiponatremia. Conclui-se que os estudos com maior nível de evidência identificado recomendam cuidados de enfermagem centrados no acompanhamento psicológico, nas orientações do período pós-operatório e no tratamento da disfunção erétil. Destaca-se ainda que tais recomendações concentram-se, sobretudo, nas ações de apoio emocional e educativo

Inventário das espécies de peixes da costa do Estado do Rio Grande do Norte e aspectos zoogeográficos da ictiofauna recifal do Oceano Atlântico

We present a checklist of the shores fishes of the coast of the Rio Grande do Norte state. Species were registered through the specimens collection, underwater records, samples in landings of artisanal fleet and by compilation of data from literature and ichthyologic collections, between January 2004 to 2006. A total of 440 species form 2 classes, 25 orders, 106 families and 253 genus were registered. It is believed that due the great increase of the number of species registered, the ichthyofauna of the coast of this state is reasonably known

Análise dos custos assistenciais de uma operadora de plano de saúde no Brasil

The relevance of rising healthcare costs is a main topic in complementary health companies in Brazil. In 2011, these expenses consumed more than 80% of the monthly health insurance in Brazil. Considering the administrative costs, it is observed that the companies operating in this market work, on average, at the threshold between profit and loss. This paper presents results after an investigation of the welfare costs of a health plan company in Brazil. It was based on the KDD process and explorative Data Mining. A diversity of results is presented, such as data summarization, providing compact descriptions of the data, revealing common features and intrinsic observations. Among the key findings was observed that a small portion of the population is responsible for the most demanding of resources devoted to health care

SISOnt: sistema de informação em saúde baseado em ontologias

The sharing of knowledge and integration of data is one of the biggest challenges in health and essential contribution to improve the quality of health care. Since the same person receives care in various health facilities throughout his/her live, that information is distributed in different information systems which run on platforms of heterogeneous hardware and software. This paper proposes a System of Health Information Based on Ontologies (SISOnt) for knowledge sharing and integration of data on health, which allows to infer new information from the heterogeneous databases and knowledge base. For this purpose it was created three ontologies represented by the patterns and concepts proposed by the Semantic Web. The first ontology provides a representation of the concepts of diseases Secretariat of Health Surveillance (SVS) and the others are related to the representation of the concepts of databases of Health Information Systems (SIS), specifically the Information System of Notification of Diseases (SINAN) and the Information System on Mortality (SIM)

Uma Análise de métodos de distriubuição de atributos em comitês de classificadores

The objective of the researches in artificial intelligence is to qualify the computer to execute functions that are performed by humans using knowledge and reasoning. This work was developed in the area of machine learning, that it s the study branch of artificial intelligence, being related to the project and development of algorithms and techniques capable to allow the computational learning. The objective of this work is analyzing a feature selection method for ensemble systems. The proposed method is inserted into the filter approach of feature selection method, it s using the variance and Spearman correlation to rank the feature and using the reward and punishment strategies to measure the feature importance for the identification of the classes. For each ensemble, several different configuration were used, which varied from hybrid (homogeneous) to non-hybrid (heterogeneous) structures of ensemble. They were submitted to five combining methods (voting, sum, sum weight, multiLayer Perceptron and naïve Bayes) which were applied in six distinct database (real and artificial). The classifiers applied during the experiments were k- nearest neighbor, multiLayer Perceptron, naïve Bayes and decision tree. Finally, the performance of ensemble was analyzed comparatively, using none feature selection method, using a filter approach (original) feature selection method and the proposed method. To do this comparison, a statistical test was applied, which demonstrate that there was a significant improvement in the precision of the ensembles

Abordagem de construção de arquitetura homogênea para comitês via meta-aprendizagem

In the world we are constantly performing everyday actions. Two of these actions are frequent and of great importance: classify (sort by classes) and take decision. When we encounter problems with a relatively high degree of complexity, we tend to seek other opinions, usually from people who have some knowledge or even to the extent possible, are experts in the problem domain in question in order to help us in the decision-making process. Both the classification process as the process of decision making, we are guided by consideration of the characteristics involved in the specific problem. The characterization of a set of objects is part of the decision making process in general. In Machine Learning this classification happens through a learning algorithm and the characterization is applied to databases. The classification algorithms can be employed individually or by machine committees. The choice of the best methods to be used in the construction of a committee is a very arduous task. In this work, it will be investigated meta-learning techniques in selecting the best configuration parameters of homogeneous committees for applications in various classification problems. These parameters are: the base classifier, the architecture and the size of this architecture. We investigated nine types of inductors candidates for based classifier, two methods of generation of architecture and nine medium-sized groups for architecture. Dimensionality reduction techniques have been applied to metabases looking for improvement. Five classifiers methods are investigated as meta-learners in the process of choosing the best parameters of a homogeneous committee.

Possibilidades de enfoque CTS para o ensino superior de química: proposta de uma abordagem para ácidos e bases

Scientific education has been passing by redefinitions, contestations and new contributions from the research on science teaching. One contribution is the idea of science and technology literacy, allowing the citizens not only knowing science but also understand aspects on the construction and motivation of scientific and technological research. In accordance with this idea, there is the Science-Technology-Society (STS) studies which, since the 1970s, has been contributing for science teaching and learning according to the comprehension of the relationships with society in the Western countries of the North. In Brazil, this approach began to gain projection from the 1990s when the first essays on the theme were published. Currently, there is a clear influence of this approach on the national curriculum guidelines, especially for the area of Natural Sciences, and also on the textbooks chosen by the High School National Program (Programa Nacional do Ensino Médio). However, there seems to be a gap in relation to the discussion on the specific curricular component seen in college on this approach. Thus, this study aims at adopting the approach STS, face to the preparation of complimentary educational material on acid and bases concepts studied in the course of General Chemistry of the Natural Sciences graduation program. To this end, it was performed a bibliographical research aiming at making the state-of-the-art in in these concepts in specific literature to science teaching. It is divided in two stages: systematic study (with sixteen journals chosen according to Qualis-Capes and an unsystematic study with direct search in databases and references in the papers of the systematic study. The studies had their content analyzed and the categories chosen a priori were the level of education, the acid-base theory adopted, and the strategy/theoretical frame of reference adopted. A second stage aimed at identifying attitudes and beliefs on STS (Science-Technology-Society) and CSE (Chemistry-Society-Environment) of students in the teacher and technologist training course in three diferent institutions: UTFPR, UFRN and IFRN. In this study, it was used two questionnaires, composed of a Likert scale, semantic differential scale and open questions. The quantitative data reliability was estimated through Cronbach’s alpha method, and tha data were treated according to classic statistics, using the mean as the centrality measures, and the mean deviation as dispersion. The qualitative data were treated according to the content analysis with categories taken from the reading of answers. In the third stage, it was analyzed the presence of STS and CSE content in chapters on acid and bases concepts of nine General Chemistry textbooks, frequently used in graduation programs in public institutions of the state of Rio Grande do Norte. The results showed that there are few proposals of acid and bases teaching, and they are generally aimed at High School or at instrumentation for teaching courses, and no course for General Chemistry. The student’s attitudes and beliefs show the presence of a positivist point of view based on the concept of Science and Technology neutrality and the salvation of its mediation. The books analysis showed just a few content on STS and CSE are found in the studied chapters, and they are generally presented disjointedly in relation to the rest of the main text. In the end, as suggestion to solve the absence of proposals STS in General Chemistry books, as well as the student’s positivist attitudes, it was developed some educational material to be used in the course of General Chemistry at College. The material is structured to introduce a historical view of the concepts preparation, present the use of materials, the industrial and technological processes, and social and environmental consequences of this activities

Validação do conteúdo do diagnóstico de enfermagem proteção ineficaz para pacientes submetidos à hemodiálise

Methodological study, in order to validate the content of the nursing diagnosis protection ineffective in patients undergoing hemodialysis. The research took place in two stages, namely: concept analysis and content analysis of the instrument by experts. T he first step was operationalized through an integrative review of the databaes LILACS, CINAHL, PubMed, Scopus and Cochrane, with the key words protection and hemodialysis, in October and November 2013. The sample consisted of 32 articles, which were analyz ed by a c areful reading to identify the sections that correspond ed to the defining attributes , antecedents and consequences of protection in patients undergoing hemodialysis. T he interpretation for the diagnosis of effective protection was made by transpos ing the components of the diagnosis (definition, defining characteristics and related factors) to the denial form . In the second stage, we elaborated an instrument with the components of the nursing diagnostic s studied and proceeded to the analysis conduct ed in April 2014 by 22 specialists in nephrology and in the terminology of the NANDA International, selected by means of th e Lattes Platform . We used the binomial test to assess the proportion of experts who rated each item as appropriate, considering a si gnificance level of 5%. The project was approved by the Ethics Committee of the institution responsible for the research, an opinion on num b er 387 837 and CAAE 18486413.0.0000.5537. The results show that the proposal for the nursing diagnosis of ineffectiv e protection in patients undergoing hemodialysis is: definition - the same as that presented in the NANDA International Taxonomy II, location - domain safety / protection and class injury. Related factors are: Absence of routine vaccines; Non - adherence to care related to vascular access; Non - adherence to infection control measures; Non - adherence to prescribed diet; Non - adherence to drug therapy; Presence of comorbidities; Drug abuse; Immune disorders; Extremes of age; Abnormal blood profiles; Drugs that red uce immunity; and side effects and adverse treatment - related. The defining characteristics are: Presence of invading the bloodstream; Nutritional disorders; Increase in the number of hospitalizations; Uncontrolled dry weight; Infected vascular access; Vasc ular inadequate access; Increased blood pressure; fever; Bleeding disorder; Disability immunity; fatigue; weakness; itching; and maladaptive response to stress. It follows that the identification of the defining attributes, antecedents and consequences inc reased the wealth of vocabulary, allowing the construction of theoretical and empirical definitions for a broader understanding of the concept protection. Furthermore, the study contributed to the enrichment of nursing specific body of knowledge, as well a s in the direction of nursing care for patients undergoing hemodialysis.

Construção e validação de instrumento de coleta de dados do casal grávido no âmbito da atenção básica

The research aimed to construct and validate a data collection instrument of pregnant couple as part of primary care. It was considered hypothesis that level of agreement from 70% among participants to validate the expert panel. The document has been based on the Theory of Human Needs by Horta and adjusted by Garcia and Cubas. It is a study of methodological type developed in four stages: identification of empirical indicators to pregnant women through an integrative literature review; evaluation of empirical indicators and their relation to human needs by focus group; structuring of the second version of instrument by categorization of indicators and appearance and content validation of the third version of instrument by judges, by use of Delphi technique. The collection of data was the first stage in months from August to October 2014 in the Journal of Midwifery and Women's Health and Scopus, PubMed, Lilacs, CINAHL, Cochrane databases. The remaining steps were carried out from November 2014 to February 2015. For the focus group was counted with participation of six experts through two meetings. As for the judges, it was obtained a population of 63 and final sample of 51 judges divided into 46 basic health units of Municipal City Health Natal/RN, Brazil. The study was approved by the Research Ethics Committee of Universidade Federal do Rio Grande do Norte, under Protocol number 876.200. For data analysis of the first stage it was used descriptive statistics and results are presented in tables and charts. At that stage were identified 162 empirical indicators and, when they were related to human needs, 64 by them were on psycobiological, 97 on psychosocial and one (1) on psychospiritual needs. Regarding the second and third stages, data were treated by process of categorizing and analyzing the Content Validity Index. The indicators obtained a 100% validation index. In appearance and content validation phase of instrument non-validated items were excluded and other items obtained index above 70%. Furthermore, it obtained 99% content validity index in the second version and 95.7% in the third version of the instrument as a whole and, therefore, validated tool. This instrument contains Health Institution, pregnant woman and her partner identification data, information on the human needs of the pregnant and items pertaining to systematize the collection of pregnant couple data during prenatal care. By the conclusion of the study, nurse shall have an instrument to collect the data of pregnant couple in primary care innovative by considering psychobiological, psychosocial and psychospiritual pregnant needs and insert health and sociodemographic data of pregnant partner in the context of pregnancy. Also, the document will serve as a tool for teaching and research in obstetrical nursing.