<p>Företag: Midelfart Sonesson AB</p><p>Syfte: Studien skulle ge en bild av vilka kriterier som är betydelsefulla för företag vid rationalisering av lagerställen. Den skulle dessutom ge en bild av vilka tänkbara ekonomiska konsekvenser som kan följa efter en rationalisering. Genom en fallstudie av ett typföretag och genom kompletterande intervjuer med kunniga inom logistik och företagsekonomi skulle författarna undersöka vilka kriterier som företagen lägger mest vikt på när de ska starta ett så stort projekt som lagerställesrationalisering, samt förstå vad kostnadsbesparingen kan bli.</p><p>Metod: En studie av företaget Midelfart Sonesson AB har utförts. Primär- och sekundärdata har samlats in genom personliga intervjuer, litteratur, rapporter, och elektroniska källor.</p><p>Teori: Teorin består av nio olika avsnitt som kan tillämpas på ämnet i uppsatsen. Teorin används för att förstå företagets uppbyggnad, organisation och dess handlande. Det ger en förståelse av lagerhållning och lagerställesrationalisering.</p><p>Empiri: I empirin beskrivs företagets situation idag. Förslag från konsulten tas upp, angående den förändring och det val som de står inför. Material som inkommit genom intervjuer belyses även i empirin.</p><p>Slutsats: Kostnadseffektivitet med bibehållen kundservice är de viktigaste kriterierna. Stora kostnadsbesparingar kan göras vid lagerställesrationalisering.</p> / <p>Company: Midelfart Sonesson AB</p><p>Purpose: The essay should give a picture of which criteria are important to companies when rationalizing their warehouse places. It would also illustrate what the possible economic consequences could be after a rationalization. A case study of a typical company and in addition, interviews with experts in the areas of logistics and business administration should help the authors investigate which criteria the companies emphasize, when they start such a large project as warehouse place rationalizing, and also understand the cost effect.</p><p>Methodology: A study of the company Midelfart Sonesson AB has been done. Primary- and secondary data has been gathered through personal interviews, literature, reports and electronic sources.</p><p>Theoretical perspective: The theory consists of nine different sections that can be applied to the subject of this essay. The theory is used to understand a company’s build-up, organization and its action. It gives a comprehension of stock holding and warehouse place rationalization.</p><p>Empirical foundation: This is where the company’s situation of today is described. The consultant’s recommendations, concerning the transformation and the choice that has to be made, are described. Information received through interviews is also illustrated in the empirical foundation.</p><p>Conclusion: Cost efficiency with maintained customer service is the most important criteria. Large cost savings can be made through warehouse place rationalizing.</p>

Armatec tillhandahåller system, produkter och funktionella lösningar inom värme, kyla och process. Företaget har lager i Sverige, Norge och Danmark. Under senare tid har företaget sett att lagret i Norge utgör en stor kostnad. Armatec har därför börjat fundera på om de skulle tjäna på att centralisera logistikstrukturen dvs. stänga lagret i Norge och utöka centrallagret i Göteborg. Syftet meddetta examensarbete är att undersöka huruvida lagret behövs i Norge eller ej. Den metod som arbetet använder sig av är Dupont - modellen eller avkastningsmodellen. Genom att använda denna modell beräknas lagerkostnaderna, transportkostnaderna, lagerstorlek, kapacitetsutnyttjande osv. Dessutom gör man en analys av leveransprecision, leveranssäkerhet, leveranstid och leverensflexibilitet. Arbetet har gått genom dessa punkter och finner att lagerräntabiliteten ökar med 13% om företaget Armatec stänger sitt lager i Norge. Detta under villkor att leveransservicenivån förbättras. Transportkostnaderna ökar något men inte markant i det här sammanhanget. Arbetet berör också andra typer av metoder som behandlar lagerlokaliserings fråga nämligen tyndpunktsmetoden, matematiska modeller samt Analytic Hierarchy Process (AHP) Uppsatsen använder sig av en differentierad lagerhållningsränta för att beräkna lagerkostnaderna. Man har dock utgått ifrån en multivariabel ABC analys för att klassificera produkterna. En kvalitativ metod nämligen SWOT- analysen dvs. Styrka ,Svaghet, möjligheter och Hot avslutar detta arbete. Slutstaten med detta examensarbete är att Armatec skulle tjäna på en centralisering av lagerstrukturerna. Författaren vill påminna läsaren att Företaget vill behålla sitt lager i Köpenhamn. Det är därför Köpenhamn inte igår i arbetet. Företaget har inget lager i Finland. Arbetet visar också att den finska marknaden inte kommer att påverkas i samband med centralisering

Företag: Midelfart Sonesson AB Syfte: Studien skulle ge en bild av vilka kriterier som är betydelsefulla för företag vid rationalisering av lagerställen. Den skulle dessutom ge en bild av vilka tänkbara ekonomiska konsekvenser som kan följa efter en rationalisering. Genom en fallstudie av ett typföretag och genom kompletterande intervjuer med kunniga inom logistik och företagsekonomi skulle författarna undersöka vilka kriterier som företagen lägger mest vikt på när de ska starta ett så stort projekt som lagerställesrationalisering, samt förstå vad kostnadsbesparingen kan bli. Metod: En studie av företaget Midelfart Sonesson AB har utförts. Primär- och sekundärdata har samlats in genom personliga intervjuer, litteratur, rapporter, och elektroniska källor. Teori: Teorin består av nio olika avsnitt som kan tillämpas på ämnet i uppsatsen. Teorin används för att förstå företagets uppbyggnad, organisation och dess handlande. Det ger en förståelse av lagerhållning och lagerställesrationalisering. Empiri: I empirin beskrivs företagets situation idag. Förslag från konsulten tas upp, angående den förändring och det val som de står inför. Material som inkommit genom intervjuer belyses även i empirin. Slutsats: Kostnadseffektivitet med bibehållen kundservice är de viktigaste kriterierna. Stora kostnadsbesparingar kan göras vid lagerställesrationalisering. / Company: Midelfart Sonesson AB Purpose: The essay should give a picture of which criteria are important to companies when rationalizing their warehouse places. It would also illustrate what the possible economic consequences could be after a rationalization. A case study of a typical company and in addition, interviews with experts in the areas of logistics and business administration should help the authors investigate which criteria the companies emphasize, when they start such a large project as warehouse place rationalizing, and also understand the cost effect. Methodology: A study of the company Midelfart Sonesson AB has been done. Primary- and secondary data has been gathered through personal interviews, literature, reports and electronic sources. Theoretical perspective: The theory consists of nine different sections that can be applied to the subject of this essay. The theory is used to understand a company’s build-up, organization and its action. It gives a comprehension of stock holding and warehouse place rationalization. Empirical foundation: This is where the company’s situation of today is described. The consultant’s recommendations, concerning the transformation and the choice that has to be made, are described. Information received through interviews is also illustrated in the empirical foundation. Conclusion: Cost efficiency with maintained customer service is the most important criteria. Large cost savings can be made through warehouse place rationalizing.

In economically turbulent times, Business Intelligence (BI) is increasingly being used to mitigate risk and increase certainty. The evolution of BI from a series of technologies to a platform for supporting strategies is analyzed in this thesis. The concentration is on how BI can streamline manufacturing, quality assurance, marketing and customer service are evaluated, as are the potential payoffs of increasing the level of insight an organization has. The thesis also includes analysis of how the more complex value chain processes including build-to-order, configure-to-order and quote-to-order can be made more efficient and profitable through the inclusion of BI and its associated analytics and technologies. The inclusion of the Delphi research technique makes this paper unique and strong in its content as well. The role of BI has shifted from being used in specific functional areas of an organization to being strategic in scope. The intent of this thesis is to evaluate its contributions to the customer-facing processes that are the most complex and most challenging to sustain, making BI an indispensible platform for their successful execution on the base of theories and practical experience of the BI experts.

Aktuelle Studien belegen ein rasantes, mehrdimensionales Wachstum in analytischen Datenbanken: Das Datenvolumen verzehnfachte sich in den letzten vier Jahren, die Anzahl der Nutzer wuchs um durchschnittlich 25% pro Jahr und die Anzahl der Anfragen verdoppelte sich seit 2004 jährlich. Bei den Anfragen handelt es sich zunehmend um komplexe Verbundanfragen mit Aggregationen; sie sind häufig explorativer Natur und werden interaktiv an das System gestellt. Eine Möglichkeit, der Forderung nach Interaktivität bei diesem starken, mehrdimensionalen Wachstum nachzukommen, stellen Stichproben und eine darauf aufsetzende näherungsweise Anfrageverarbeitung dar. Diese Lösung bietet signifikant kürzere Antwortzeiten sowie Schätzungen mit probabilistischen Fehlergrenzen. Mit den Operationen Verbund, Gruppierung und Aggregation als Hauptbestandteile analytischer Anfragen ergeben sich folgende Anforderungen an das Design von Stichproben in analytischen Datenbanken: Zwischen den Stichproben fremdschlüsselverbundener Relationen ist die referenzielle Integrität zu gewährleisten, sämtliche Gruppen sind angemessen zu repräsentieren und Aggregationsattribute sind auf extreme Werte zu untersuchen. In dieser Dissertation wird für jedes dieser Teilprobleme ein Stichprobenverfahren vorgestellt, das sich durch speicherplatzbeschränkte Stichproben und geringe Schätzfehler auszeichnet. Im ersten der vorgestellten Verfahren wird durch eine korrelierte Stichprobenerhebung die referenzielle Integrität bei minimalem zusätzlichen Speicherplatz gewährleistet. Das zweite vorgestellte Stichprobenverfahren hat durch eine Berücksichtigung der Streuung der Daten eine angemessene Repräsentation sämtlicher Gruppen zur Folge und unterstützt damit beliebige Gruppierungen, und im dritten Verfahren ermöglicht eine mehrdimensionale Ausreißerbehandlung geringe Schätzfehler für beliebig viele Aggregationsattribute. Für jedes dieser Verfahren wird die Qualität der resultierenden Stichprobe diskutiert und bei der Berechnung speicherplatzbeschränkter Stichproben berücksichtigt. Um den Berechnungsaufwand und damit die Systembelastung gering zu halten, werden für jeden Algorithmus Heuristiken vorgestellt, deren Kennzeichen hohe Effizienz und eine geringe Beeinflussung der Stichprobenqualität sind. Weiterhin werden alle möglichen Kombinationen der vorgestellten Stichprobenverfahren betrachtet; diese Kombinationen ermöglichen eine zusätzliche Verringerung der Schätzfehler und vergrößern gleichzeitig das Anwendungsspektrum der resultierenden Stichproben. Mit der Kombination aller drei Techniken wird ein Stichprobenverfahren vorgestellt, das alle Anforderungen an das Design von Stichproben in analytischen Datenbanken erfüllt und die Vorteile der Einzellösungen vereint. Damit ist es möglich, ein breites Spektrum an Anfragen mit hoher Genauigkeit näherungsweise zu beantworten. / Recent studies have shown the fast and multi-dimensional growth in analytical databases: Over the last four years, the data volume has risen by a factor of 10; the number of users has increased by an average of 25% per year; and the number of queries has been doubling every year since 2004. These queries have increasingly become complex join queries with aggregations; they are often of an explorative nature and interactively submitted to the system. One option to address the need for interactivity in the context of this strong, multi-dimensional growth is the use of samples and an approximate query processing approach based on those samples. Such a solution offers significantly shorter response times as well as estimates with probabilistic error bounds. Given that joins, groupings and aggregations are the main components of analytical queries, the following requirements for the design of samples in analytical databases arise: 1) The foreign-key integrity between the samples of foreign-key related tables has to be preserved. 2) Any existing groups have to be represented appropriately. 3) Aggregation attributes have to be checked for extreme values. For each of these sub-problems, this dissertation presents sampling techniques that are characterized by memory-bounded samples and low estimation errors. In the first of these presented approaches, a correlated sampling process guarantees the referential integrity while only using up a minimum of additional memory. The second illustrated sampling technique considers the data distribution, and as a result, any arbitrary grouping is supported; all groups are appropriately represented. In the third approach, the multi-column outlier handling leads to low estimation errors for any number of aggregation attributes. For all three approaches, the quality of the resulting samples is discussed and considered when computing memory-bounded samples. In order to keep the computation effort - and thus the system load - at a low level, heuristics are provided for each algorithm; these are marked by high efficiency and minimal effects on the sampling quality. Furthermore, the dissertation examines all possible combinations of the presented sampling techniques; such combinations allow to additionally reduce estimation errors while increasing the range of applicability for the resulting samples at the same time. With the combination of all three techniques, a sampling technique is introduced that meets all requirements for the design of samples in analytical databases and that merges the advantages of the individual techniques. Thereby, the approximate but very precise answering of a wide range of queries becomes a true possibility.

Syfte – Syftet med studien är att identifiera kritiska begränsningar i inlagringsprocessen i ett distributionslager för att därmed kunna effektivisera materialflödet. Studiens syfte uppnås genom att följande forskningsfrågor har formulerats: Vilka kritiska begränsningar kan förekomma i materialflödet i en inlagringsprocess i ett distributionslager? Hur kan de identifierade begränsningarna exkluderas i en inlagringsprocess? Metod – Studien hade en induktiv ansats och datainsamling skedde genom intervjuer, observationer, dokumentstudier och litteraturstudier. En fallstudie genomfördes på ett distributionslager och empiri och teori har jämförts för att kunna uppfylla studiens syfte. Resultat – Studiens resultat påvisar att de förekommande kritiska begränsningarna i ett distributionslager är brist på yta, materialhantering, automatiska system samt lagerlayout. Studiens slutsats är att begränsningarna är sammankopplade och påverkar varandra eftersom de ingår i samma process. För att exkludera begränsningarna bör distributionslager implementera diverse standarder i sin inlagringsprocess och arbeta med ständiga förbättringar. Implikationer – Studien bidrar inte med nya teorier men bidrar med praktisk nytta för distributionslager med liknande kriterier som studiens fallföretag. Begränsningar – Studien riktar enbart in sig på distributionslager och var en fallstudie av enfallsdesign. Genom att utföra flera liknande undersökningar på företag med liknande kriterier hade generaliserbarheten kunnat stärkas. / Purpose – The purpose of the study is to identify critical constraints in the inbound process at a distribution warehouse. To accomplish the purpose two research questions were formulated: Which critical constraints can occur in the material flow in the inbound process at a distribution warehouse? How can the identified constraints be excluded in the inbound process? Method – The study was performed inductively, and the data collection techniques were interviews, observations, document studies and literature studies. A single case study was performed at a distribution warehouse and the empirical data and theories were compared to accomplish the purpose of the study. Findings – The result of the study demonstrates that the critical constraints in the inbound process at a distribution warehouse are space, material handling, automatic systems and warehouse layout. The conclusion of the study is that the constraints are connected and affect each other since they are all included in the same process. To exclude the constraints different types of standards should be implemented in the inbound process, and distribution warehouses should work with continuous improvements. Implications – The study does not contribute to new theories but can be practically beneficial for distribution warehouses similar to the studies case study. Limitations – The study only focuses on one distribution warehouse and is therefore a single case study. The generalizability could have been higher if the study had been conducted at multiple distribution warehouses.

Made available in DSpace on 2015-04-16T14:49:18Z (GMT). No. of bitstreams: 1 arquivototal.pdf: 1087884 bytes, checksum: 429902be9382cf69a51711eb3b6a7a19 (MD5) Previous issue date: 2009-07-22 / Coordenação de Aperfeiçoamento de Pessoal de Nível Superior - CAPES / Studies in the field of Information Technology (IT) have always been concerned with the technical aspects of the technology and neglect the social and organizational aspects. It is recognized that information systems (IS) have had some impact on the workplace, and the decision making process in the organizational environment. In the field of decision support systems, it is mentioned that the technology of Data Warehouse (DW) provides efficient access to integrate data and historical heterogeneous sources, helping the decision making process. With this function, the Data Warehouse technology is classified as analytical systems, which differentiated it from other kind of information systems such as the well recognized transaction information systems. However, the success of Data Warehouse is dependent upon many factors, including its development methodology steps. The information system development process has always emphasized the technological problems, neglecting that users are severe affecting by the technology. Studies in Information systems development methodology in Data Warehouse are very rare. So, how to develop Data Warehouse? The purpose of this study is to propose a methodology for the initial phase of a Data Warehouse development, increasing user s participation in the development context, based on the Participatory Design approach. The qualitative research method and action research were used in this work. The study was developed in the public agency named DATAPREV, which is the government information technology company for social security issues. One of DATAPREV project is to replace the analytical systems of the Brazilian Labour and Employment Ministry. For contractual reasons, the Employment and Income Generation Program, name PROGER, was selected for this study. As result of this, the PROGER s system was chosen, and among the seven phases proposed, the initiation phase was selected and divided into five activities as a guide to start the development of a Data Warehouse with users participation. The initiation phase was validated and used in other projects with the same objectives. Furthermore, as an action research work that involved system analysts, the study promoted the reduction in the gap between business practice and academic literature in the research field. / Estudos no campo de Tecnologia de Informação (TI) tem sempre se preocupado com os aspectos da tecnologia, negligenciando os aspectos sociais e organizacionais. Reconhece-se que os Sistemas de Informação (SI) tem tido alguns impactos no ambiente de trabalho e no processo de tomada de decisão nas organizações. No campo de sistemas de apoio às decisões, tem sido mencionado que a tecnologia de Data Warehouse (DW) proporciona acesso eficiente aos dados integrados e ao histórico de fontes heterogêneas. Por este motivo auxiliam o planejamento e o processo decisório, sendo classificados como sistemas analíticos, diferenciando-se de outras espécies de sistemas de informação, a exemplo dos reconhecidos sistemas de informações transacionais. Contudo, o sucesso do Data Warehouse depende de muitos fatores, incluindo os passos para sua construção. O processo tradicional de desenvolvimento de sistemas tem sempre enfatizado os problemas tecnológicos. Entretanto, os usuários que são severamente afetados pela tecnologia não são valorizados. Os estudos sobre metodologia de desenvolvimento de sistemas de Data Warehouse são muito raros. Então, como desenvolver Data Warehouse? O propósito deste estudo é propor uma metodologia para a fase inicial de desenvolvimento de um Data Warehouse, aumentando a participação do usuário no contexto de desenvolvimento, com base no enfoque do Desenho Participativo. A pesquisa qualitativa e a pesquisa-ação foram utilizadas no trabalho. O trabalho foi desenvolvido na empresa pública DATAPREV, que possui um projeto responsável por atender à solicitação do Ministério do Trabalho e Emprego (MTE) para a substituição de parte de seus sistemas analíticos, destacando o PROGER (Programa de Geração de Emprego e Renda). Como resultado chegou-se a elaboração de sete fases, sendo a fase de iniciação detalhada em cinco atividades. Em conjunto essas atividades apresentam um guia para iniciar o desenvolvimento de um Data Warehouse em parceria com os usuários. Todas as atividades para a iniciação do PROGER são apresentadas. Assim, a fase de iniciação foi validada e colocada em uso para outros projetos com a mesma necessidade. Além disso, por se tratar de uma pesquisa-ação que envolveu os próprios desenvolvedores, promoveu, em seu universo de estudo, a diminuição do abismo existente entre práticas comerciais e a literatura acadêmica.

Made available in DSpace on 2015-05-14T12:36:29Z (GMT). No. of bitstreams: 1 parte1.pdf: 3149727 bytes, checksum: 501b860d063bed8174828ab1c9287d13 (MD5) Previous issue date: 2009-05-29 / Coordenação de Aperfeiçoamento de Pessoal de Nível Superior / This work propose to use technologies of databases with the aim of providing decision support for managers of sector of sanitation, given that the services of water supply for use of the population are a key indicator of quality of life. The fundamental idea is to collect operational data, reduce them to the scope of the problem, organize them into a repository of data, and finally apply the techniques OLAP and Data Mining algorithms to obtain results that give managers a better understanding of the behavior and profile of the company. To facilitate the application of the techniques of Data Mining is necessary that the data are stored properly. Accordingly, an alternative for increasing the efficiency in storage, management and operation of data to support the decision based on the development of Data Warehouse. This is source of strategic information of the business, creating a competitive differential for the company. In this context, was required to implement the repository of data, Data Warehouse, to store, integrate and carry out consultations on the multidimensional data from the company of water supply. Therefore, this Master's thesis aims to design a Data Warehouse relating to Departmental Business, also known as Data Mart; applied the technology on the OLAP multidimensional cubes of data, and run the Data Mining algorithms to the generation of a decision support system to minimize the apparent losses in the urban water supply system. / Esta dissertação se propõe a utilizar tecnologias de Banco de Dados com a finalidade de oferecer apoio à decisão para os gestores do setor de saneamento, haja vista que os serviços de abastecimento de água para uso da população se constituem em um dos principais indicadores da qualidade de vida da humanidade. A idéia fundamental consiste em coletar os dados operacionais, reduzi-los ao escopo de um problema, organizá-los em um repositório de dados, e finalmente aplicar as tecnologias OLAP e os algoritmos de Mineração de Dados, a fim de obter resultados que proporcionem aos gestores um melhor entendimento do comportamento e perfil da companhia. Para facilitar a aplicação de técnicas de Mineração de Dados é necessário que estes dados estejam armazenados apropriadamente. Neste sentido, uma das alternativas para o aumento da eficiência no armazenamento, gestão e operação dos dados para o suporte a decisão baseia-se no desenvolvimento do Data Warehouse. Este ambiente constitui fontes de informações estratégicas do negócio, gerando um diferencial competitivo para a companhia. Diante deste contexto, se fez necessário a implementação do repositório de dados, o Data Warehouse, para armazenar, integrar e realizar as consultas multidimensionais sobre os dados extraídos da companhia de abastecimento de água. Portanto, esta dissertação de mestrado tem como objetivos projetar um Data Warehouse Departamental referente ao setor comercial, também conhecido como Data Mart; aplicar as tecnologias OLAP sobre os cubos de dados multidimensionais; e executar algoritmos de Mineração de Dados visando a geração de um sistema de apoio à decisão para minimização das perdas aparentes no sistema de abastecimento urbano de água.

[pt] Atualmente, a Tecnologia da Informação (TI) tem assumido papel essencial para o alcance da administração eficiente, tanto no nível estratégico como no operacional, oferecendo benefícios para os negócios que incluem redução de custo, aumento da produtividade, qualidade, flexibilidade e inovação. E um dos recursos empregados é a implantação de um Sistema de Gestão de Armazéns, denominado Warehouse Management System (WMS), software que recebe as informações pertinentes ao armazém, gerando respostas para uma melhor movimentação, armazenagem, separação e expedição dos produtos, conforme as necessidades da organização. No entanto, a implantação de um sistema WMS pode ser considerada bem mais do que um projeto de tecnologia, que envolve mudanças estruturais e comportamentais, tornando-se um processo de risco relativamente alto e complexo. Este trabalho tem como objetivo identificar e planejar respostas aos riscos na implantação de um WMS no novo armazém de uma grande empresa brasileira do setor de cosméticos. Os resultados obtidos comprovaram inúmeras atividades que devem ser gerenciadas em favor do não comprometimento dos objetivos propostos da empresa, embora sabendo que o risco é algo incerto quanto à sua ocorrência. Ainda assim, para os futuros usuários do WMS, compreender a inclusão do gerenciamento de riscos nos seus projetos de implantação irá trazer maior probabilidade de sucesso, pois quanto mais forem conhecidos os riscos e as ações de mitigação, mais confiança e segurança as empresas terão em projetos desta natureza. / [en] Currently, Information Technology (IT) has assumed crucial role for achieving the efficient administration at both the strategic and the operational, providing business benefits that include reducing costs, increasing productivity, quality, flexibility and innovation. And one of the resources used is the implementation of a Warehouse Management System, called Warehouse Management System (WMS) software that receives the relevant information to the warehouse, generating responses for improved handling, storage, picking and shipping of products as the organization s needs. However, the implementation of a WMS system can be considered much more than a technology project that involves structural and behavioral changes, becoming a process of relatively high risk and complex. This study aims to identify and plan responses to the risks of implementing a new WMS in the warehouse of a large company in the cosmetics industry. The results confirmed many activities that must be managed in favor of non-commitment of the proposed objectives of the company, while knowing that the risk is somewhat uncertain as to its occurrence. Still, for future users of the WMS, to understand the inclusion of risk management in their deployment projects will bring greater likelihood of success, because as more becomes known risks and mitigating actions, more confidence and security firms will take into projects of this nature.

Os sistemas de integração de dados que usam a arquitetura de data warehouse (DW) têm se tornado cada vez maiores e mais difíceis de gerenciar devido à crescente heterogeneidade das fontes de dados envolvidas. Apesar dos avanços tecnológicos e científicos, os projetos de DW ainda são muito lentos na geração de resultados pragmáticos. Este trabalho busca responder à seguinte questão: como pode ser reduzida a complexidade do desenvolvimento de sistemas de DW que integram dados provenientes de sistemas transacionais heterogêneos? Para isso, apresenta duas contribuições: 1) A criação de diretrizes metodológicas baseadas em ciclos de modelagem conceitual e análise de dados para guiar a construção de um sistema modular de integração de dados. Essas diretrizes foram fundamentais para reduzir a complexidade do desenvolvimento do projeto internacional Retrovirus Epidemiology Donor Study-II (REDS-II), se mostrando adequadas para serem aplicadas em sistemas reais. 2) O desenvolvimento de um método de validação de lotes de dados candidatos a serem incorporados a um sistema integrador, que toma decisões baseado no perfil estatístico desses lotes, e de um projeto de sistema que viabiliza o uso desse método no contexto de sistemas de DW. / Data integration systems that use data warehouse (DW) architecture are becoming bigger and more difficult to manage due to the growing heterogeneity of data sources. Despite the significant advances in research and technologies, many integration projects are still too slow to generate pragmatic results. This work addresses the following question: how can the complexity of DW development for integration of heterogeneous transactional information systems be reduced? For this purpose, we present two contributions: 1) The establishment of methodological guidelines based on cycles of conceptual modeling and data analysis to drive construction of a modular data integration system. These guidelines were fundamental for reducing the development complexity of the international project Retrovirus Epidemiology Donor Study-II (REDS-II), proving suited to be applied in real systems. 2) The development of a validation method of data batches that are candidates to be incorporated into an integration system, which makes decisions based on the statistical profile of these batches, and a project of a system that enables the use of this method in DW systems context.