Į baigiamojo darbo sudėtį įeina SQL Server 2005, Reporting Services, bei kitų numatomų instrumentinių priemonių ir technologijų analizė, reikalavimų sistemai išgavimas, taip pat sistemos modulių projektavimas bei apjungimas ir realizacija. Sistema supruojektuota ir realizuota remiantis sudaryta specifikacija. Sistemos realizacijai naudojami Microsoft SQL Server 2005 bei Microsoft Visual Studio 2005 programavimo paketai. Taip pat pateikiama, jau realizuotos sistemos testavimo rezultatai ir išvados. / This final work includes SQL Server 2005, Reporting Services and other instrumental tools or technology analysis, requirement for the system extraction and also modules of the system projection, integration to one unit and realization. The system was designed and implemented in accordance with specification. To implement the system was used Microsoft SQL Server 2005 and Microsoft Visual Studio 2005 programming packages. Also there are the testing results of the system and final conclusions.

This work provides a survey of creation of the Business Intelligence by using QI information system data. The work concisely describes Business intelligence functions and its user's environment. QI system and the way of data storage are also defined in this dissertation. The following chapters describe the design and implementation of Business Intelligence itself over the actions made by registered employees. The proposal describes the design of a data storage system, a method of obtaining the necessary data from the QI information system, ETL process design, OLAP cubes design, and how to interpret the information in the form of reports. The last chapter then describes the realisation of all the proposed districts in MS SQL Server.

Tai darbas apie duomenų saugyklos ir OLAP galimybių panaudojimą skaitmeninės antžeminės televizijos paslaugos pardavimo procese. Atlikta išsami probleminės srities analizė, duomenų saugyklos, integravimo, kubų projektavimas ir realizavimas. Darbas atliktas, pasinaudojant MS SQL Server 2005 analizavimo ir integravimo paslaugomis. / This master`s work investigates data warehouse and OLAP tools opportunities research and practical use in organization which produces DVB-T (digital video broadcasting terrestrial) service for end-users. This work consist of problem analysis, data warehouse, data integration, data cubes project and realization. Realization was done using Ms SQL Server 2005 analysis and integration services.

Šiame darbe tiriama galimybė analizuoti įtakas, lemiančias studentų mokymosi universitete sėkmę. Remiamasi duomenų gavybos algoritmais. Sukurtas būdas, kaip prognozuoti, ar būsimas studentas, remiantis jo turimais stojimo balais bei ankstesnės kartos patirtimi, sėkmingai užbaigs studijas. Pradžioje aptariamos galimos duomenų gavybos taikymo sritys, būtini etapai, tam skirta programinė įranga. Detalizuojami Microsoft SQL Server 2008 palaikomi duomenų gavybos algoritmai. Keturi iš jų sėkmingai pritaikyti pasirinktos dalykinės srities analizei. Sukurta analitinė sistema, sugebanti įvertinti stojimo balų įtakas, universitete dėstomų dalykų įtakas galimybei sėkmingai baigti studijas. Atliktas tyrimas, nustatyti, kuris duomenų gavybos algoritmas yra tinkamiausias prognozuoti studentų iškritimą. / This paper describes a research of evaluation of influences, causing a success to graduate university. The research is based on the data mining algorithms. There has been developed way to predict if a prospective student will successfully graduate the university or not. The prediction is based on the data of earlier generation of students, and school’s marks of prospective student. First part of paper describes the spheres, where data mining is adapted. Then, there is detailed stages used in data mining process; reviewed most popular data mining tools. After Microsoft SQL Server data mining algorithms were analyzed, it became clear witch ones are most suitable for the selected research area. The realization part explains how data mining can serve to improve the study process in university. This can be achieved by analyzing influences of different study disciplines to the ability to graduate the university. The last part of paper describes the performed experiment, witch showed the most appropriate algorithm to make predictions about ability to graduate the university.

The subject of the diploma thesis entitled "Business Intelligence in Microsoft Dynamics AX" is to analyze the functionality of the ERP system Microsoft Dynamics AX 2009 in the area of Business Intelligence and Reporting with the reflection of the current market position of the company. The goal is to set the basic definition of the relationship between ERP and Business Intelligence systems, further defining the possibilities of MS Dynamics AX in BI in the terms of their practical use and also to describe the fundamental technological aspects. The aim of the work is evaluation and definition particular steps during implementation based on methodology MS Sure Step 2010 together with description of deployment process. As a reflection of insufficient coverage of some of the areas is mentioned solution of the company Circon Circle Consulting. Also is realized proposal for BI for AX cost accounting module, including designing data mart, ETL and report with respect to specifics, such as the parent-child hierarchies and many-to-many relationship between fact tables and dimensions. The contribution of this work is mainly evident for the consultants of the system, to who is provided insight into the important and for users attractive functionality and also is offered possible implementation process. Technically oriented readers may appreciate the solutions for Cost Accounting and potential approaches to the concept of data mart or other areas where they meet the above-mentioned aspects.

<p>This master’s thesis was performed at PartnerTech AB in Åtvidaberg. It addresses the problem of managing test results obtained from testing electronics manufactured by PartnerTech. PartnerTech has developed a test system, called Tor, which performs tests on manufactured boards and stores the test results in files. The Tor system consists of both hardware and software part, where the software runs on an ordinary PC with MS DOS/Windows 2000. The effects on the existing Tor system that this thesis implies are minimal. </p><p>This work focuses on a way of storing the produced test files in a database. In this work a data model has been developed, implemented, and evaluated together with a system that imports test files into the database and a graphical user interface that allows a user to easily search and browse the stored test results. It is also possible to print test reports from the Tor system. For implementing the database system Microsoft SQL Server 2000 was chosen as database server and an XML based data format was chosen to import and export data to and from the database. Two alternative graphical user interface applications were developed and compared - one server based on Microsoft IIS and one client based in Microsoft Access. For advanced data manipulation certain parts of the system were developed in Microsoft Excel.</p>

This work contains the design solution and implementation of importing data mining tool Weka to the Visual Studio and Microsoft SQL Server 2012 by Managed Plug-in algorithm. In this thesis is describe, how is possible to create new Managed Plug-In algorithm and how is possible to import tool Weka into it. To use tool Weka in the new Managed Plugin Algorithm, is used the IKVM port. The IKVM can create from Weka tool new C# library, which can be used by Managed Plug-in Algorithm.

This master’s thesis was performed at PartnerTech AB in Åtvidaberg. It addresses the problem of managing test results obtained from testing electronics manufactured by PartnerTech. PartnerTech has developed a test system, called Tor, which performs tests on manufactured boards and stores the test results in files. The Tor system consists of both hardware and software part, where the software runs on an ordinary PC with MS DOS/Windows 2000. The effects on the existing Tor system that this thesis implies are minimal. This work focuses on a way of storing the produced test files in a database. In this work a data model has been developed, implemented, and evaluated together with a system that imports test files into the database and a graphical user interface that allows a user to easily search and browse the stored test results. It is also possible to print test reports from the Tor system. For implementing the database system Microsoft SQL Server 2000 was chosen as database server and an XML based data format was chosen to import and export data to and from the database. Two alternative graphical user interface applications were developed and compared - one server based on Microsoft IIS and one client based in Microsoft Access. For advanced data manipulation certain parts of the system were developed in Microsoft Excel.

Designing and creating the finished OLAP solutions within Business Intelligence for an undertaking by the customer's requirements using standard technologies and practices that are designed for this purpose. This work describes the work of the design, creation and deployment of the finished project Business Intelligence solution that allows the customer to perform more accurate analysis of their own data in the context of controlling.

This master thesis deals with the software support of one Financial and Property Analysis of Municipalities (FAMA). The co-author of this method is Doctor Petr Toth from the Institute of Public Administration and Regional Development at University of Economics in Prague. The method is supported by Microsoft Access database application and two C++ applications ArisDestiller and Prognoza at present time. The aim of this thesis is to evaluate the present software support of Financial and Property Analysis and implement an alternative solution based on Business Intelligence tools. Chosen part of analysis is implemented in the pilot project using Microsoft SQL Server 2005 environment. The thesis focuses mainly on using integration tools for XML data. The contribution of the thesis is to implement data warehouse, which uses the municipalities‘annual bills in XML format from the database of Ministry of Finance of the Czech Republic. The Financial and Property Analysis method and the current software support are discussed in the first half of this thesis. The other half of the work is dedicated to the Business Intelligence pilot project. Both means of software support are reviewed and compared from various perspectives in the conclusion.