Järnvägsbranschen står i dagsläget inför stora utmaningar med planerade infrastrukturprojekt och underhåll av befintlig järnväg. Med ökade förväntningar på  utbyggnaden av den framtida järnvägen, medför det en ökad risk för belastning på det nuvarande nätet. Baksidan av utbyggnaden kan bli fler inställda resor och  förseningar. Genom att dra nytta av tekniska innovationer såsom digitalisering och  automatisering kan det befintliga system och arbetsprocesser utvecklas för en  effektivare hantering.  Trafikverket ställer krav på Byggnadsinformationsmodeller (BIM) i upphandlingar. Projektering för signalanläggningar sker hos Sweco med CAD-programmet  Promis.e. Från programmet kan Baninformationslistor (BIS-listor) innehållande  information om objekts attribut hämtas. Trafikverket ställer krav på att attributen ska bestå av ett visst format eller ha specifika värden. I detta examensarbete  undersöks metoder för att automatisk verifiera ifall objekt har tillåtna värden från projekteringsverktyget samt implementering av en metod. Undersökta metoder  innefattar kalkyleringsprogrammet Excel, frågespråket Structured Query Language (SQL) och processen Extract, Transform and Load (ETL).  Efter analys av metoder valdes processen ETL. Resultatet blev att ett program  skapades för att automatiskt välja vilken typ av BIS-lista som skulle granskas och för att verifiera om attributen innehöll tillåtna värden. För att undersöka om kostnaden för programmen skulle gynna företaget utöver kvalitetssäkringen utfördes en  ekonomisk analys. Enligt beräkningarna kunde valet av att automatisera  granskningen även motiveras ur ett ekonomiskt perspektiv. / With increased expectations for the expansion of the future railway, this entails an increased load on the current railway network. The result of the expansion can be an increasing number of cancellations and delays. By taking advantage of technological innovations such as digitalization and automation, the existing system and work  processes can be developed for more efficient management.   The Swedish Transport Administration sets requirements for Building Information Modeling (BIM) in procurements. The planning of signal installations within the railway takes place in Sweco using the CAD program Promis.e. From the program, lists containing the information of the objects (BIS-lists) can be retrieved. The  Swedish Transport Administration requires that the attributes must consist of a  certain format or have specific values. In this thesis project, methods for automatic quality assurance of infrastructure information and the implementation of the method for rail projects were examined. The investigated methods include the  calculation program Excel, the query programming language SQL and the process of ETL.  After analyzing the methods, the ETL process was chosen. The result was that a  program was created to automatically select the type of BIS list that would be  reviewed and to verify that the examined attributes contained allowed values. In  order to investigate whether the cost of the programs would benefit the company in addition to the quality assurance, an economic analysis was carried out. According to the calculations, the choice of method could also be justified from an economic  perspective.

Extract, Transformation, and Load (ETL) system is responsible for the extraction of data from several sources, their cleansing, conforming and insertion into a data warehouse. The thesis is focused on building ETL methodology to better understanding of ETL process and its application in the real environment. I've worked on project "BI Cookbook" with Clever Decision, a software consulting company that specializes in Business Intelligence. The aim was to create ETL part of the BI methodology. This methodology has been designed to provide ease of use, flexible and extensible material for the purpose of building ETL solution. The main goal of this work is to introduce created ETL methodology, all of its components and the way in which it could be used. Following goal is to discuss options of its implementation and modification for the wide range of use. The main contribution of this work is to provide ideas of creating and implementing ETL methodology or ideas for creating methodology in general. The thesis is divided into three parts. The first theoretical part deals with basic definition, architecture and implementing of ETL system. The second part presents the proposed methodology. The last part contains of the possible options for implementation a modification of the methodology.

由於科技快速進步，企業經營也隨著科技的進步而產生重大變化，不但需求變化快速，企業還要即時快速反應外在環境，於是企業對於資訊系統整合的議題越來越重視，希望將功能導向的系統轉變為流程導向的系統，將資訊有效的整合及標準化，讓企業能快速地與外在環境連結，進而提升整體營運績效。 整合的方法非常的多，大致上可分為四類。目前對於哪一種整合方法是最有效率、效益也無一定論。最主要的原因是不同的整合個案會有不同的整合需求，若只從理論方面來探討資訊系統整合所帶來的效用並無法具體地呈現其價值。 有鑑於此，本研究之目的是希望透過個案單位的作業模型，分析、建構出整合的資料模型。因此，本研究以階段性的方法設計資料整合模型及其運作方法。在第一、二階段當中，先針對個案單位的流程進行系統資料流程塑模及業務流程塑模，再從業務面及系統面找出資訊中斷的地方及因素，並將問題具體地描述出來。在第三階段中，本研究挑選了最適合此個案單位的整合方法，也就是使用資料層級（Data-Level）整合的方法，設計整合的資料模型將資訊流完整的串接起來以支援企業的決策需求。最後一階段則要利用ETL說明整合的系統運作模式，並說明此個案單位使用ETL時，可能會遇到的問題及初步的解決方法。 / Owing to rapid advances in technology, enterprises have a major change of the progress of science and technology. The enterprises not only change rapidly in demand, but also have to response to the external environment rapidly. Hence, enterprise information system integration issues get more attentions. Enterprises hope to improve their systems from function-oriented to process-oriented because the effective integration of information and standardization allows enterprises to quickly link with the external environment and to enhance the overall operating performance. However, there are many kinds of integrated approaches. At present, there is no substantive conclusion in approaches to integrate efficiently all systems in business. The main reason is that the integration of different cases has different integration requirements. Therefore, it cannot concretely show the value of system integration through the discussion of the theoretical aspects. In this thesis, this study aims to enhance the operation of a case to model, analyze, and construct an integrated data model. This research has 4 phases to construct integrated data model. In phase 1 and 2, this study builds the case data flow modeling and business process modeling and discovers information gap. In phase 3, the study selects the most suitable method for this case, that is, to use the data level integrated approach to design integrated data model. Finally, using ETL illustrates system operation mode and describes the case which may encounter problems and initial solutions follow in phase 4.

This thesis deals with Business Intelligence and its testing. It seeks to highlight the differences from the classical software testing and finally design a methodology for BI solutions testing that could be used in practice on real projects of BI companies. The aim of thesis is to design a methodology for BI solutions testing based on theoretical knowledge of Business Intelligence and software testing with an emphasis on the specific BI characteristics and requirements and also in accordance with Clever Decision's requirements and test it in practice on a real project in this company. The paper is written up on the basis of studying literature in the field of Business Intelligence and software testing from Czech and foreign sources as well as on the recommendations and experience of Clever Decision's employees. It is one of the few if not the first sources dealing with methodology for BI solutions testing in the Czech language. This work could also serve as a basis for more comprehensive methodologies of BI solutions testing. The thesis can be divided into theoretical and practical part. The theoretical part tries to explain the purpose of Business Intelligence use in enterprises. It elucidates particular components of the BI solution, then the actual software testing, various types of tests, with emphasis on the differences and specificities of Business Intelligence. The theoretical part is followed by designed methodology for BI solutions using a generic model for the BI/DW solution testing. The practical part's highlight is the description of real BI project testing in Clever Decision according to the designed methodology.

This paper deals with data warehouses and OLAP. These technologies are defined and described here. Then an introduction of the architecture of product MS SQL Server and its tools for work with data warehouses and OLAP folow. The knowledge gained is used for creation of sample application.

The main goal of this thesis is to summarize and introduce general theoretical concepts of Data Warehousing by using the systems approach. The thesis defines Data Warehousing and its main areas and delimitates Data Warehousing area in terms of higher-level area called Business Intelligence. It also describes the history of Data Warehousing & Business Intelligence, focuses on key principals of Data Warehouse building and explains the practical applications of this solution. The aim of the practical part is to perform the evaluation of theoretical concepts. Based on that, design and build Data Warehouse in environment of an existing company. The final solution shall include Data Warehouse design, hardware and software platform selection, loading with real data by using ETL services and building of end users reports. The objective of the practical part is also to demonstrate the power of this technology and shall contribute to business decision-making process in this company.